How to Add a New Tab in Microsoft Excel: Your Ultimate Guide

PDF download Download Article
Easy and quick ways to create new tabs in Excel
PDF download Download Article

You can add tabs in Excel, called "Worksheets," to keep your data separate but easy to access and reference. Excel starts you with one sheet (three if you're using 2007), but you can add as many additional sheets as you'd like.

Quick Steps

  1. Open your document in Microsoft Excel.
  2. Click on the "+" button at the bottom of the screen, next to your current sheet tab.
  3. Double click the sheet tab to rename it.
Method 1
Method 1 of 3:

Adding a Single Sheet

PDF download Download Article
  1. Start up Excel from the Start menu (Windows) or the Applications folder (Mac) and open the workbook you want to add tabs to. You'll be prompted to select a file when you launch Excel.
  2. This will create a new blank sheet after your existing sheets. [1]
    • You can also press ⇧ Shift + F11 to create a new sheet in front of the selected sheet. For example, if you have Sheet1 selected and then press ⇧ Shift + F11 , a new sheet called Sheet2 will be created in front of Sheet1.
    • On Mac, press ⌘ Command + T to create a new tab.
    Advertisement
  3. You can quickly copy a sheet (or sheets) by selecting it, holding Ctrl (Windows) or ⌥ Opt (Mac), and then dragging the sheet. This will create a new copy that contains all of the data from the original. [2]
    • Press and hold Ctrl / ⌥ Opt and click multiple sheets to select them if you want to copy more than one sheet at once.
  4. The text will become highlighted, and you can type whatever you'd like as the tab name.
  5. You can select from a variety of preset colors, or click "More Colors" to make a custom color.
  6. You can adjust Excel's settings to change the number of sheets that appear by default whenever a new workbook is created.
    • Click the File tab or Office button and select "Options."
    • In the "General" or "Popular" tab, find the "When creating new workbooks" section.
    • Change the number for "Include this many sheets."
  7. Once you have multiple tabs, you can click and drag them to change the order that they appear. Drag the tab left or right to put it in a new position in your tab row. This will not affect any of your formulas or references.
    8. Advertisement
Method 2
Method 2 of 3:

Adding Multiple Sheets

PDF download Download Article
  1. ⇧ Shift and select the number of sheets you want to create. For example, if you want to add three sheets at once, hold ⇧ Shift and select three existing sheets. In other words, you'll need to already have three sheets to quickly create three new sheets using this command.
  2. This will open additional Insert options. Be sure to click the ▼ part of the button so that you open the menu.
  3. This will create new blank sheets based on the number of sheets you had selected. They will be inserted before the first sheet in your selection.
    4. Advertisement
Method 3
Method 3 of 3:

Inserting a Sheet Template

PDF download Download Article
  1. You can turn any of your worksheets into templates by selecting the "Excel Template (*.xltx)" format when you save the file. This will save the current spreadsheet into your Templates directory. You can also download a variety of templates from Microsoft when creating a new file.
  2. When you insert a template as a sheet, it will be added in front of the tab you have selected.
  3. This will open a new window allowing you to select what you want to insert.
  4. Your downloaded and saved templates will be listed in the "General" tab. Select the template you want to use and click "OK."
  5. Your new tab (or tabs if the template had more than one sheet) will be inserted in front of the tab you had selected.
    6. Advertisement

Community Q&A

Search
Add New Question
  • Question
    How do I name a file in Excel?
    Community Answer
    Go to the file tab on the top left hand side and then click on save as and name the file.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 3 Helpful 4
  • Question
    How can I change the position of a tab?
    Community Answer
    Click and drag the tab you want to move to the position you want it moved to.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 5 Helpful 5
  • Question
    How do I add a row in my Excel spreadsheet?
    Community Answer
    You need to right click the area on the left side where you want the additional row. Then, you can click "add row."
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 1 Helpful 1
See more answers
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Video

      Tips

      • You can apply changes to several tabs at once by grouping them. Hold the Ctrl key while clicking each tab to create a group. Select a contiguous range of sheets by holding the Shift key while clicking the first and last tabs in the range of sheets. Release the Ctrl and Shift keys and click any other tab to ungroup the sheets.
        Thanks
        Helpful 0 Not Helpful 0
      • It is easier to manage your tabs by giving them a distinctive name- it could be a month, a number, or something unique so that it describes what exactly is in the tab.
        Thanks
        Helpful 0 Not Helpful 0
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      You Might Also Like

      5 Easy Steps to Unmerge Cells in Microsoft Excel
      How to
      Apply Conditional Formatting in Excel
      How to
      Make a Spreadsheet in Excel
      How to
      Manage Priorities with Excel
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      Advertisement

      References

      1. ↑ https://support.office.com/en-us/article/Insert-or-delete-a-worksheet-19d3d21e-a3b3-4e13-a422-d1f43f1faaf2?ui=en-US&rs=en-US&ad=US&fromAR=1
      2. ↑ https://support.office.com/en-us/article/Move-or-copy-a-sheet-0e5acaa3-5968-4d7d-b5ce-eb67b2d93521

      About This Article

      In other languages
      Thanks to all authors for creating a page that has been read 377,130 times.

      Is this article up to date?

      Advertisement