How to Work With Worksheet Tabs in Excel
Pinterest Stumbleupon Whatsapp
Advertisement

Every Excel workbook contains at least one worksheet. You can create multiple worksheets to help organize your data, and each worksheet is shown as a tab at the bottom of the Excel window. These tabs make it easier to manage your worksheets.

Currently, the Excel worksheet row limit is over 1 million, and the column limit is 16.384. It may seem like you’ll never reach that limit, but with certain tasks, you might just get to that limit. Maybe you have a list of millions of email addresses for your marketing campaign.

If you find you are reaching the row or column limit, you can break up the data onto multiple worksheets, or tabs. You can export the Excel file into a CSV file by going to File > Export > Change File Type > CSV (Comma delimited) (*.csv) and then splitting the single, large CSV file into smaller files How to Split a Huge CSV Excel Spreadsheet Into Separate Files How to Split a Huge CSV Excel Spreadsheet Into Separate Files One of Microsoft Excel's shortcomings is the limited size of a spreadsheet. If you need to make your Excel file smaller or split a large CSV file, read on! Read More .

Today we’ll look at how to work with tabs in Excel to efficiently manage multiple worksheets in one workbook.

Insert a New Tab

To add another Excel worksheet to your workbook, click the tab after which you want to insert the worksheet. Then, click the plus icon to the right of the tab bar.

add an excel worksheet

The new tab is numbered with the next sequential sheet number, even if you’ve inserted the tab in another location. In our example, our new sheet is inserted after Sheet3, but is numbered Sheet6.

add an excel worksheet

Need to search your Excel sheets for data? Learn how to use the INDEX and MATCH formulas Search Excel Spreadsheets Faster: Replace VLOOKUP With INDEX and MATCH Search Excel Spreadsheets Faster: Replace VLOOKUP With INDEX and MATCH Still using VLOOKUP to search for information in your spreadsheet? Here's how INDEX and MATCH can provide a better solution. Read More  instead of VLOOKUP!

Rename a Tab

New tabs are named Sheet1, Sheet2, etc. in sequential order. If you have multiple worksheets in your workbook, it’s helpful to name each of them to help you organize and find your data.

To rename a tab, either double-click on the tab or right-click on it and select Rename. Type a new name and press Enter.

Each tab must have a unique name.

rename an excel worksheet tab

Scroll Through Tabs

If you have a lot of tabs, they may not all display at once, depending on the size of your Excel window. There are a couple of ways you can scroll through your tabs.

You’ll see three horizontal dots on one or both ends of the tab bar. Click the three dots on one end to scroll through the tabs in that direction. Then, click on the three dots on the other end to scroll back the other way.

scroll through excel worksheet tabs

You can also click the right and left arrows on the right side of the tab bar to scroll through the tabs. These arrows also have other uses, as indicated by the popup that displays when you move your mouse over one of them.

scroll through excel worksheet tabs

View More Tabs on the Tab Bar

The scrollbar at the bottom of the Excel window takes up room that could be used for your worksheet tabs. If you have a lot of tabs, and you want to see more of them at once, you can widen the tab bar.

Hover your mouse over the three vertical dots to the left of the scrollbar, until it turns into two vertical lines with left and right arrows. Click and drag the three dots to the right to make the tab bar wider. You’ll start seeing more of your tabs displayed.

view more excel workbook tabs

Need to print your Excel sheet? We show you how to format the document to print your spreadsheet on a single page How to Print an Excel Spreadsheet on One Single Page How to Print an Excel Spreadsheet on One Single Page A beautifully crafted spreadsheet loses all its appeal when it comes printed on nine sheets of paper, with half of them empty. We show you how to get everything nicely on one single page. Read More .

Copy or Move a Tab

You can make an exact copy of a tab in the current workbook or in another open workbook, which is useful if you need to start with the same data from one tab on a new tab. You can also move tabs to another location in the same workbook or another open workbook. Right-click on the tab you want to copy or move and select Move or Copy.

copy or move an excel worksheet tab

On the Move or Copy dialog box, the currently active workbook is selected in the To book drop-down list. If you want to copy or move the tab to another workbook, make sure that workbook is open and select it from the list. You can only copy or move tabs to open workbooks.

In the Before sheet list box, select the sheet, or tab, before which you want to insert the copied (or moved) tab.

If you’re copying the tab, and not moving it, make sure the Create a copy box is checked and click OK. If the Create a copy box is not checked, the tab will be moved to the chosen location instead of copied.

copy an excel worksheet tab

If you copied the tab, the new tab contains the same exact data as the original tab and has the same name as the original tab followed by a version number. You can rename the tab as we described in the Rename a Tab section above.

If you moved the tab, the name remains the same. A version number is not added.

copy an excel worksheet tab

If you only want to move a tab a short distance within the same workbook, you can manually move the tab to the new location. Click and hold the tab until you see a triangle at the upper-left corner of the tab. Then, move the tab until the triangle points to where you want to move the tab and release the mouse.

move an excel worksheet tab

Delete a Tab

You can delete worksheets in your workbook, even those containing data. You will lose the data on a deleted Excel worksheet, and it might cause errors if other worksheets refer to data 5 Excel Document Settings You Must Never Forget to Check 5 Excel Document Settings You Must Never Forget to Check When you pick an Excel template or share a spreadsheet, it may contain custom settings that you don't want anyone to see. Always check these settings. Read More on the deleted worksheet.

Remember, a workbook must contain at least one worksheet, so you can’t delete a worksheet if it’s the only one in your workbook.

To delete an Excel worksheet, right-click on the tab for the worksheet you want to delete and select Delete.

delete an excel worksheet tab

If the worksheet you’re deleting contains data, the following confirmation dialog box displays. Click Delete, if you’re sure you want to delete the data on the worksheet.

delete an excel worksheet tab

Keep Your Excel Data Organized

Tabs are a great way to keep your Excel data organized and make it easy to find. You can customize the tabs to organize your data in the best way that suits your needs.

You can also speed up navigation and data entry on your worksheets using keyboard shortcuts 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & Mac 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows & Mac Keyboard shortcuts can save you a lot of time! Use these Microsoft Excel shortcuts to speed up working with spreadsheets on Windows and Mac. Read More , as well as these tips to save time in Excel 14 Tips to Save Time in Microsoft Excel 14 Tips to Save Time in Microsoft Excel If Microsoft Excel has consumed a lot of your time in the past, let us show you how to get some of it back. These simple tips are easy to remember. Read More . If your workbook contains sensitive information, you can password protect your Excel file How to Password Protect an Excel File in Just a Minute How to Password Protect an Excel File in Just a Minute You need to password protect your Excel files to keep your spreadsheets safe. We'll show you how and we promise it only takes a minute. Read More .

Do you have any more tips for making the most out of Excel worksheet tabs? Share your ideas and experiences with us in the comments below.

Enjoyed this article? Stay informed by joining our newsletter!

Enter your Email

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. MrPivot
    December 26, 2017 at 11:13 pm

    You lose credibility right at the beginning of your article. Excel had 16,384 columns. That is no where near the same a the number of rows.

    • Tina Sieber
      December 29, 2017 at 9:19 am

      Thank you for catching this error! As the editor, I should have fact-checked the number. I've corrected it now.

    • Lori Kaufman
      December 29, 2017 at 10:22 am

      Thanks for pointing out the error. I should have double-checked the number while writing the article.

  2. darshan
    December 22, 2017 at 9:11 am

    Great loved it