If you don't check the Create a copy box, the tab will be moved to the chosen location instead of copied.

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, https://support.office.com/en-us/article/Move-or-copy-a-sheet-0e5acaa3-5968-4d7d-b5ce-eb67b2d93521, agregar una nueva hoja en un libro de Excel, ajouter une nouvelle feuille de calcul dans un classeur Excel, consider supporting our work with a contribution to wikiHow, Click the File tab or Office button and select "Options.". How can I have one Excel file and create a tab for each day? The copied tab will have the same name as the original tab followed by a version number.

You can also speed up navigation and data entry on your worksheets using keyboard shortcuts, as well as use these tips to save time in Excel.

To efficiently manage more than one spreadsheet in a single workbook, we have some tips to help you work with tabs in Excel.

Then, click the plus sign icon on the right of the tab bar. Right click on the "Sheet 1" tab in the bottom left of the page. Join our newsletter for tech tips, reviews, free ebooks, and exclusive deals! Learn more... You can add tabs in Excel, called "Worksheets," to keep your data separate but easy to access and reference. wikiHow's.

Select "insert" from the popup menu to add a new worksheet tab.

You will lose the data on a deleted Excel worksheet, and it might cause errors if other worksheets refer to data on the deleted worksheet. Click the three dots on one end to scroll through the tabs in that direction. There are a couple of ways you can scroll through your tabs. Then, drag the tab until the triangle points to where you want it and then release it. New tabs are named Sheet1, Sheet2, etc. You can also move a tab to another location in the same workbook or a different open workbook. Since a workbook must contain at least one spreadsheet, you can't delete a sheet if it's the only one in your workbook. If you're copying the tab, and not moving it, make sure to check the Create a copy box.

You can also save them in separate templates.

Save them with 2 different names. If you move the tab, the name will remain the same; a version number is not added. We show you how to format the document to print your spreadsheet on a single page.

In our example screenshot, our new sheet is inserted after Sheet3, but is numbered Sheet6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9d\/Add-a-New-Tab-in-Excel-Step-1-Version-4.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-1-Version-4.jpg","bigUrl":"\/images\/thumb\/9\/9d\/Add-a-New-Tab-in-Excel-Step-1-Version-4.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":343,"bigWidth":"728","bigHeight":"543","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Add-a-New-Tab-in-Excel-Step-2-Version-3.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/7\/7f\/Add-a-New-Tab-in-Excel-Step-2-Version-3.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/ef\/Add-a-New-Tab-in-Excel-Step-3-Version-3.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-3-Version-3.jpg","bigUrl":"\/images\/thumb\/e\/ef\/Add-a-New-Tab-in-Excel-Step-3-Version-3.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e6\/Add-a-New-Tab-in-Excel-Step-4-Version-3.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-4-Version-3.jpg","bigUrl":"\/images\/thumb\/e\/e6\/Add-a-New-Tab-in-Excel-Step-4-Version-3.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/23\/Add-a-New-Tab-in-Excel-Step-5-Version-3.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/23\/Add-a-New-Tab-in-Excel-Step-5-Version-3.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/17\/Add-a-New-Tab-in-Excel-Step-6-Version-3.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/1\/17\/Add-a-New-Tab-in-Excel-Step-6-Version-3.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/90\/Add-a-New-Tab-in-Excel-Step-7.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-7.jpg","bigUrl":"\/images\/thumb\/9\/90\/Add-a-New-Tab-in-Excel-Step-7.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-7.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/22\/Add-a-New-Tab-in-Excel-Step-8.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-8.jpg","bigUrl":"\/images\/thumb\/2\/22\/Add-a-New-Tab-in-Excel-Step-8.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-8.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/25\/Add-a-New-Tab-in-Excel-Step-9.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-9.jpg","bigUrl":"\/images\/thumb\/2\/25\/Add-a-New-Tab-in-Excel-Step-9.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-9.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d6\/Add-a-New-Tab-in-Excel-Step-10.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-10.jpg","bigUrl":"\/images\/thumb\/d\/d6\/Add-a-New-Tab-in-Excel-Step-10.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-10.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c6\/Add-a-New-Tab-in-Excel-Step-11.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-11.jpg","bigUrl":"\/images\/thumb\/c\/c6\/Add-a-New-Tab-in-Excel-Step-11.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-11.jpg","smallWidth":460,"smallHeight":346,"bigWidth":"728","bigHeight":"547","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/83\/Add-a-New-Tab-in-Excel-Step-12.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-12.jpg","bigUrl":"\/images\/thumb\/8\/83\/Add-a-New-Tab-in-Excel-Step-12.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-12.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/06\/Add-a-New-Tab-in-Excel-Step-13.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-13.jpg","bigUrl":"\/images\/thumb\/0\/06\/Add-a-New-Tab-in-Excel-Step-13.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-13.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e3\/Add-a-New-Tab-in-Excel-Step-14.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-14.jpg","bigUrl":"\/images\/thumb\/e\/e3\/Add-a-New-Tab-in-Excel-Step-14.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-14.jpg","smallWidth":460,"smallHeight":344,"bigWidth":"728","bigHeight":"545","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/90\/Add-a-New-Tab-in-Excel-Step-15.jpg\/v4-460px-Add-a-New-Tab-in-Excel-Step-15.jpg","bigUrl":"\/images\/thumb\/9\/90\/Add-a-New-Tab-in-Excel-Step-15.jpg\/aid1439575-v4-728px-Add-a-New-Tab-in-Excel-Step-15.jpg","smallWidth":460,"smallHeight":345,"bigWidth":"728","bigHeight":"546","licensing":"

License: Creative Commons<\/a>
\n<\/p>


\n<\/p><\/div>"}.

We use cookies to make wikiHow great.

Excel starts you with one sheet (three if you're using 2007), but you can add as many additional sheets as you'd like. You’ll see the tab and the sheet disappear from the workbook view. Click and drag the three dots to the right to make the tab bar wider. You can delete worksheets (tabs) in your workbook, even those containing data. Please consider making a contribution to wikiHow today. On Windows, the scrollbar at the bottom of the Excel window takes up room that could be used for your worksheet tabs. If the worksheet you're deleting contains data, a dialog box displays. What could be causing that? Then, click on your tab and then type.

New tabs are named Sheet1, Sheet2, etc.

So be sure that you actually want to remove the sheet.

Select a contiguous range of sheets by holding the Shift key while clicking the first and last tabs in the range of sheets.

On Windows, you'll see three horizontal dots on one or both ends of the tab bar.

Select a color from the pop-out window.

How can I tab all of the columns of my spreadsheet so I can sort them?