Working with Multiple Worksheets
When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.
- Open a new workbook and name each of the worksheets something other than Sheet1, Sheet2, or Sheet3. Name your worksheets descriptively so you can remember what data each sheet contains.
- Group all three sheets.
- Enter some information into the grouped worksheets.
- Navigate your workbook, and observe how your information was copied to all grouped worksheets.
- Ungroup all three worksheets.