This article was co-authored by How.com.vn staff writer, Hannah Dillon. Hannah Dillon is a Technology Writer and Editor at How.com.vn. She graduated with a B.A. in Journalism from North Dakota State University in 2013 and has since worked in the video game industry as well as a few newspapers. From a young age Hannah has cultivated a love for writing and technology, and hopes to use these passions in tandem to help others in the articles she writes for How.com.vn.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 362,312 times.
Learn more...
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
- Open your document in Microsoft Excel.
- Click on the "+" button at the bottom of the screen, next to your current sheet tab.
- Double click the sheet tab to rename it.
Steps
- 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.
- Click the "+" button at the end of your sheet tabs. 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 - Create a copy of an existing sheet. 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.
- Double-click a tab to rename it. The text will become highlighted, and you can type whatever you'd like as the tab name.
- 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.
- 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.
- 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."
- 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.
- 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.
- Click the "Insert ▼" button in the Home tab. This will open additional Insert options. Be sure to click the ▼ part of the button so that you open the menu.
- 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.
- 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.
- 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.
- Select "Insert" from the right-click menu. This will open a new window allowing you to select what you want to insert.
- 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."
- 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.
Community Q&A
- QuestionHow do I name a file in Excel?Community AnswerGo to the file tab on the top left hand side and then click on save as and name the file.
- QuestionHow can I change the position of a tab?Community AnswerClick and drag the tab you want to move to the position you want it moved to.
- QuestionHow do I add a row in my Excel spreadsheet?Community AnswerYou need to right click the area on the left side where you want the additional row. Then, you can click "add row."
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
- 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
References
About This Article
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.