How to Add a New Tab in Excel

Adding a Single Sheet

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. 
   Click the "+" button at the end of your sheet tabs. This will create a new blank sheet after your existing sheets.^{[1] X Research source}

   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. 
   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] X Research source}

   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. 
   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. 
   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. 
   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. 
   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.