How to create tabs in an Excel spreadsheet

Written by stephen byron cooper Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to create tabs in an Excel spreadsheet
Excel tabs mimic folder tabs in a filing system. (Jupiterimages/liquidlibrary/Getty Images)

The standard Excel spreadsheet is actually called a “Workbook.” This is because the files may contain several sheets. To further distinguish the sheets of a book from the original concept of the spreadsheet, each sheet in a workbook is called a “Worksheet.” You can switch between worksheets in a workbook by clicking on a tab at the bottom of the workspace. Each tab is attached to a different worksheet. Each new workbook begins with three tabs already set up. These are called “Sheet1,” “Sheet2” and “Sheet3.” You can rename these tabs to give them more meaningful names and you can also create new tabs.

Skill level:


  1. 1

    Open Excel with a new workbook. If this is the first instance of the program you have open, the blank workbook will be called the default name of “Book1.”

  2. 2

    Look at the bottom of the clean worksheet. You will see three tabs. The first tab is attached to the current worksheet and you can switch to other worksheets by clicking on their tabs. Next to “Sheet3” you will see a smaller tab.

  3. 3

    Click on the tab stump to create a new tab. Alternatively, you can create a new tab by holding down the “Shift” key and pressing “F11” at the same time.

Tips and warnings

  • You can rename any tab by hovering over it with the mouse pointer and then pressing the right mouse button. In the right-click menu press “Rename.” The name of the tab will become editable. Click elsewhere in the sheet to save the changes.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.