Working with Multiple Worksheets

Use multiple worksheets in Excel when working with a large amount of data so it is better organized and easier to find content.

Challenge!

  1. Open our practice workbook.
  2. Insert a new worksheet, and rename it Q1 Summary.
  3. Move the Expenses Summary worksheet to the far right, then move the Q1 Summary worksheet so that it is between March and April.
  4. Create a copy of the Expenses Summary worksheet by right-clicking the tab. Do not just copy and paste the content of the worksheet into a new worksheet.
  5. Change the color of the January tab to blue and the color of the February tab to red.
  6. Group the worksheets September, October, and November.
  7. When you're finished, your workbook should look something like this:

    Multiple Worksheets