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
Open a fresh working copy of the expense workbook.
Locate the worksheet tabs at the bottom of the editor.
Select Summary.
Check the active tab and the worksheet heading before entering any data.

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.

