HomeApplicationOffice information

How to Add a New Tab in Excel

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. Open your...
Part 1 of 3:

Adding a Single Sheet

  1. How to Add a New Tab in Excel Picture 1How to Add a New Tab in Excel Picture 1
    Open your workbook in Excel. 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. How to Add a New Tab in Excel Picture 2How to Add a New Tab in Excel Picture 2
    Click the "+" button at the end of your sheet tabs. This will create a new blank sheet after your existing sheets.[1]
    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.
    2. On Mac, press ⌘ Command+T to create a new tab.
  3. How to Add a New Tab in Excel Picture 3How to Add a New Tab in Excel Picture 3
    Create a copy of an existing sheet. You can quickly copy a sheet (or sheets) by selecting it, holding Ctrl/⌥ Opt, and then dragging the sheet. This will create a new copy that contains all of the data from the original.[2]
    1. Press and hold Ctrl/⌥ Opt and click multiple sheets to select them if you want to copy more than one sheet at once.
  4. How to Add a New Tab in Excel Picture 4How to Add a New Tab in Excel Picture 4
    Double-click a tab to rename it. The text will become highlighted, and you can type whatever you'd like as the tab name.
  5. How to Add a New Tab in Excel Picture 5How to Add a New Tab in Excel Picture 5
    Right-click a tab and select "Tab Color" to color it. You can select from a variety of preset colors, or click "More Colors" to make a custom color.
  6. How to Add a New Tab in Excel Picture 6How to Add a New Tab in Excel Picture 6
    Change the number of default sheets for new workbooks. You can adjust Excel's settings to change the number of sheets that appear by default whenever a new workbook is created.
    1. Click the File tab or Office button and select "Options."
    2. In the "General" or "Popular" tab, find the "When creating new workbooks" section.
    3. Change the number for "Include this many sheets."
  7. How to Add a New Tab in Excel Picture 7How to Add a New Tab in Excel Picture 7
    Click and drag tabs left and right to reorder them. 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.
Part 2 of 3:

Adding Multiple Sheets

  1. How to Add a New Tab in Excel Picture 8How to Add a New Tab in Excel Picture 8
    Hold .⇧ 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. How to Add a New Tab in Excel Picture 9How to Add a New Tab in Excel Picture 9
    Click the "Insert ▼" button in the Home tab. This will open addition Insert options. Be sure to click the ▼ part of the button so that you open the menu.
  3. How to Add a New Tab in Excel Picture 10How to Add a New Tab in Excel Picture 10
    Select "Insert Sheet." 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.
Part 3 of 3:

Inserting a Sheet Template

  1. How to Add a New Tab in Excel Picture 11How to Add a New Tab in Excel Picture 11
    Create or download the template you want to use. 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. How to Add a New Tab in Excel Picture 12How to Add a New Tab in Excel Picture 12
    Right-click the tab you want to insert the template in front of. When you insert a template as a sheet, it will be added in front of the tab you have selected.
  3. How to Add a New Tab in Excel Picture 13How to Add a New Tab in Excel Picture 13
    Select "Insert" from the right-click menu. This will open a new window allowing you to select what you want to insert.
  4. How to Add a New Tab in Excel Picture 14How to Add a New Tab in Excel Picture 14
    Select the template you want to insert. Your downloaded and saved templates will be listed in the "General" tab. Select the template you want to use and click "OK."
  5. How to Add a New Tab in Excel Picture 15How to Add a New Tab in Excel Picture 15
    Select your new tab. Your new tab (or tabs if the template had more than one sheet) will be inserted in front of the tab you had selected.
3.7 ★ | 19 Vote
tabsheetnewsheets

You should read it

Maybe you are interested

Office information