Working with Multiple Worksheets

When working in Excel group worksheets and freeze certain cells to more effectively navigate worksheets.

Challenge!

  • 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.