How To Unhide Tabs In Excel

To unhide tabs in Excel, right-click on any visible tab, select “Unhide” from the context menu, and then choose the hidden tab(s) to be shown.

Excel is a powerful tool for data analysis and manipulation, widely used by professionals in various industries. With its many features and functions, it’s common to have multiple tabs or sheets in an Excel workbook to organize and categorize data.

However, there may be times when you accidentally hide tabs in Excel, making it difficult to access or view the information you need. Whether it’s due to a mistakenly clicked button or an unintentional action, don’t worry! In this blog post, we will guide you through the process of unhiding tabs in Excel, ensuring that you can quickly restore your hidden data. So let’s dive in and discover the simple and effective methods to unhide those tabs and regain control of your Excel workbooks.

How To Unhide Tabs In Excel: Step-by-Step


Step 1: Open Excel,

To open Excel, locate and click on its icon either on your desktop, taskbar or in your computer’s program files. This action will launch the Excel program, allowing you to create and modify spreadsheets.

Next Step

Step 2: Open the Worksheet,

Click on the “File” tab and choose “Open” to easily locate and select the desired worksheet for unhiding tabs, making it convenient and efficient for your navigation through the software.

Next Step

Step 3: Accessing the Home Tab,

To unhide tabs in Excel, click on the “Home” tab on the main toolbar.

Next Step

Step 4: Find the Format button,

In the “Cells” group of the “Home” tab, the “Format” button can be found. This button is typically positioned towards the far right of the toolbar, providing easy access to various formatting options for your spreadsheet data.

Next Step

Step 5: Click on Format,

Click on the ‘Format’ button located in the ‘Cells’ group. This action will launch a dropdown menu, granting you access to various formatting options for your selected cells.

Next Step

Step 6: Select Hide & Unhide,

From the dropdown menu, simply hover your mouse over the option “Hide & Unhide” and a new submenu will instantly appear for you to explore.

Next Step

Step 7: Unhiding the Sheet,

To reveal a hidden sheet, click on “Unhide Sheet” found in the “Hide & Unhide” submenu. In case of multiple hidden tabs, a window opens, allowing you to select the specific sheet you wish to unhide.

Next Step

Step 8: Choose Sheet to Unhide,

When multiple sheets are hidden, a list of hidden sheets will be displayed. Simply click on the desired sheet and click OK to unhide it.


In this blog post, we have explored the different methods to unhide tabs in Excel. Whether you accidentally hid tabs or received a workbook with hidden sheets, the steps outlined here will help you bring them back to visibility. From using the right-click method to using VBA code, we have provided you with a range of options to choose from based on your preference and comfort level with Excel. Remember, hiding tabs can be a useful feature, but it’s equally important to know how to unhide them when needed. With the information and techniques shared here, you can now confidently unhide tabs and navigate your Excel workbooks more efficiently. Happy un-hiding!

Table of Contents