But hidden cells or worksheets can be a problem for people that need to work with the hidden data, so you might be looking for a quick way to unhide everything that a previous editor might have hidden in your Excel file. Our short guide below will walk you through the process of displaying items that may have previously been hidden in your file.  

Unhide Hidden Rows, Columns and Worksheets in Excel 2010

The steps below will result in an Excel 2010 workbook that no longer has any hidden rows, columns or worksheets. If you are unable to unhide everything by using these steps, then elements of your workbook may be locked. If that is the case, then you will need the password for the workbook. Once you have the password, you can unlock the worksheet or the workbook by following the steps in this article. If everything inside the file is hidden, then scroll to the bottom of this article to see how to unhide the entire window.   Step 1: Open the workbook in Excel 2010.   Step 2: Click the cell at the top-left corner of the spreadsheet, between the 1 and the A. This is going to select every cell in the worksheet.

    Step 3: Right-click one of the column letter headings at the top of the spreadsheet, then click the Unhide option.

    Step 4: Right-click one of the row number headings at the left side of the spreadsheet, then click the Unhide option.

    Step 5: Right-click one of the sheet tabs at the bottom of the spreadsheet, then click the Unhide option.

    Step 6: Select the sheet to unhide, then click the OK button. You will need to repeat steps 5 and 6 if there are multiple hidden sheets.

   

Unhiding the Excel Window

  Step 1: Click the View tab at the top of the window.

    Step 2: Click the Unhide button in the Windows section of the navigational ribbon.

    Step 3: Select the name of your workbook from the list of options, then click the OK button.

    It is also possible for someone to completely hide the sheet tabs in an Excel file. This article will show you how to unhide the sheet tabs if they are not visible. After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites. His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well. Read his full bio here.

You may opt out at any time. Read our Privacy Policy

How to Unhide Everything in Excel 2010 - 33How to Unhide Everything in Excel 2010 - 17How to Unhide Everything in Excel 2010 - 12How to Unhide Everything in Excel 2010 - 86How to Unhide Everything in Excel 2010 - 5How to Unhide Everything in Excel 2010 - 71How to Unhide Everything in Excel 2010 - 33How to Unhide Everything in Excel 2010 - 75