| Scenario |
| A company
has four trading divisions:
The managing director wants the
data consolidated and reported:
-
In Total
-
North, South and East
|
|
| Method |
- The consolidated data is in the
"Consolidation" sheet.
- When you first open this workbook the
"Consolidation" sheet shows a total consolidation.
- To exclude "West" for the
second report, drag it outside the bread-roll sandwich.
- Press F9 if recalculation is set to
manual.
- Click on "Consolidation" to
inspect the revised result.
|
|
| Moving a sheet |
To move a sheet within the
current workbook:
- click on a sheet's tab
- hold down the left mouse key and drag
the sheet along the row of sheet tabs to its new location.
|
|
