Guide d’utilisation de Ulet

Premiers pas avec Ulet pour {platform}.

Enter and Edit Cell Values in a Workbook on Windows

A worksheet cell can hold a label, a number, or a formula. This walkthrough changes one numeric input in the English Riverside expense workbook and checks the result after saving.

For matching example data, use the Practice workbook section at the end of this guide.

Edit an existing cell

  1. Open your working copy of Riverside-Expense-Tracker.xlsx.

  2. On the Expenses worksheet, select B2, the Amount cell beside Paper.

  3. Enter 16 and press Enter to commit the value.

  4. Select B2 again and check that the formula bar displays 16.

English expense worksheet with Paper amount 16 and the recalculated total 104

View screenshot at full size

The selected input and its dependent total make the effect of the edit visible.

Check the change

The original Paper amount is 12. Replacing it with 16 increases the expense total from 100 to 104. The other expense rows retain their original amounts.

Click another cell after entering a value to distinguish the committed cell value from text that is still being edited. Select the cell again whenever you need to inspect its contents.

Save and reopen

Press Ctrl+S, close the document tab, and reopen the same working file. Check B2 and the Total row again. Keeping the master sample separate lets you repeat this exercise without changing your starting document.

Practice workbook

To reproduce this example, start with a separate practice copy. On Ulet Home, choose Sheets. Rename the first worksheet Expenses and enter the following values in A1:E6. Enter amounts as numbers.

Item

Amount

Category

Owner

Status

Paper

12

Supplies

Alex

Complete

Pens

8

Supplies

Sam

Complete

Desk lamp

45

Equipment

Jordan

Planned

Notebook

15

Supplies

Alex

Planned

Storage box

20

Equipment

Sam

In progress

Enter Total in A7 and =SUM(B2:B6) in B7. The initial total is 100. Column widths, colors, and number formatting are presentation choices; the values and cell addresses are what the exercise depends on.

Press Ctrl+Shift+S to choose a practice folder and save as Riverside-Expense-Tracker.xlsx. Reopen this named copy before following the exercise above. Keep your original documents separate.

Ulet

Votre suite bureautique tout-en-un pour le quotidien.

Voir les fonctionnalités