where can i find developer tab in excel 2010

Right-clicking these tabs provides you with the ability to rename them like we showed in the section above, as well as the ability to hide or unhide tabs, change the color of a tab, or even select all of the sheets in your workbook at the same time. 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. 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.

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

Where can i find developer tab in excel 2010