| Chapter Objectives (See related pages)
Design a multiple-sheet workbook and understand when it is useful |
| | |
(See page(s) MOS XL03S-5-6)
Modify the onscreen window layout |
| | |
(See page(s) MOS XL03E-5-3)
Set the default number of worksheets |
| | |
(See page(s) MOS XL03S-5-4)
Insert, delete, and reposition worksheets in a workbook |
| | |
(See page(s) MOS XL03E-4-4)
Creating a workbook template |
| | |
(See page(s) MOS XL03S-3-4)
Rename a worksheet tab and color it |
| | |
(See page(s) MOS XL03S-5-7)
Establish worksheet page settings |
| | | Group worksheets in a workbook and enter data in multiple sheets at once |
| | | Consolidate and summarize data using three-dimensional formulas |
| | |
(See page(s) MOS XL03E-1-13)
Use cell Watch |
| | | Reference cells in other workbooks using link formulas |
| | | Maintain and update linked workbooks |
|