Uživatelská příručka k Uletu

Začněte používat Ulet pro {platform}.

Switch Between Worksheets on Windows

A workbook can contain several worksheets with different purposes. The Riverside sample has Expenses for the source rows and Summary for a small set of linked results.

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

Select a worksheet tab

  1. Open a fresh working copy of the expense workbook.

  2. Locate the worksheet tabs at the bottom of the editor.

  3. Select Summary.

  4. Check the active tab and the worksheet heading before entering any data.

English workbook with the Summary tab active and its budget total and practice subtotal visible

View screenshot at full size

The active worksheet tab identifies the view currently shown in the editor.

Compare detail and summary

In the unchanged sample, Summary shows Total expenses of 100 and Practice subtotal of 20. Select Expenses to inspect the five input rows, then return to Summary.

A selected cell address belongs to the active worksheet. B2 on Summary has a different role from B2 on Expenses, so check the tab name whenever you move between them.

Inspect a linked result

Select a summary result and inspect its formula in the formula bar. The sheet name in a cross-sheet reference identifies where the inputs are stored. Keep the intended worksheet active before making your next edit.

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.

Add a second worksheet named Summary. Enter Riverside budget in A1, Total expenses in A2, =SUM(Expenses!B2:B6) in B2, Practice subtotal in A3, =SUM(Expenses!B2:B3) in B3, Budget status in A4, and Draft in B4. The initial results are 100 and 20.

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

Kancelářský balík pro každodenní práci na jednom místě.

Zobrazit funkce