![add developer tab in excel 2010 add developer tab in excel 2010](https://www.lifewire.com/thmb/yvNPcDMHeLAde64EKILG1fvcYmY=/1458x1009/filters:no_upscale():max_bytes(150000):strip_icc()/001-add-macros-in-excel-4176395-7d1a5367069240a2bba483bc5edec760.jpg)
The example image below is from Microsoft Excel 2010, but still applies in future Excel versions such as Excel 2013, 2016, and Excel for Office 365. The worksheet tabs in your workbook display near the bottom of the window. Where Do Sheet Tabs Display in a Workbook in Excel? If you want to rename worksheet tabs in Excel, you can do so if you right-click on one of the tabs, then choose the Rename option. If you haven’t renamed them, then they probably say something like Sheet1, Sheet2, Sheet3, etc.
![add developer tab in excel 2010 add developer tab in excel 2010](https://www.techonthenet.com/excel/questions/images/developer_tab2013_002.gif)
What is a Worksheet Tab in Excel?Ī worksheet tab in Excel is a small button below your cells that allows you to navigate between the different worksheets in your file. Select the sheet name of the worksheet that you wish to unhide, then click the OK button. This is going to open the Unhide dialog box.
![add developer tab in excel 2010 add developer tab in excel 2010](https://www.excelcampus.com/wp-content/uploads/2018/07/Select-the-Developer-checkbox-and-then-click-OK.png)
You can do this by right-clicking one of your visible worksheet tabs, then choosing the Unhide option. This is a pretty common occurrence in a large Excel file, particularly if includes a lot of formulas that reference data which may not need to be visible or accessible to others who work with that file. If you are able to see some sheet tabs at the bottom of the screen, then you may need to unhide worksheets individually instead.
#Add developer tab in excel 2010 how to
How to Unhide a Single Worksheet Tab in Excel Our article continues below with additional information on showing worksheet tabs in Excel. Step 5: Click the OK button at the bottom of the window to apply the change.