Working with sheets: insert, rename, move, switch

In this lesson

1. 1. Switch sheets

   One Excel file is called a workbook. It can have many sheets.

   The sheet tabs are at the bottom. This workbook has a Jan sheet and a Feb sheet.

2. 2. Switch with the keyboard

   In Excel, Ctrl+Page up (Mac: Ctrl+Page up or Option+Left arrow) goes to the sheet on the left.

   Ctrl+Page down (Mac: Ctrl+Page down or Option+Right arrow) goes to the sheet on the right.

   (In this browser, use the mouse instead. The shortcut works in Excel.)

3. 3. Insert a sheet

   This shortcut adds a new, empty sheet.

   In Excel, it goes to the left of the sheet you are on.

4. 4. Rename a sheet

   Give every sheet a clear name. Then people can find things fast.

5. 5. Move a sheet

   Keep the months in order. You can drag a tab to a new place.

6. 6. Try it yourself

   Now do all three things on your own.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.