How to Restore All Hidden Columns in Excel


Microsoft Excel software has a practical feature that allows you to hide columns, which makes it easier to manage spreadsheets containing an extensive amount of data. Also, columns are occasionally hidden accidentally when resizing certain data fields. With a few simple steps, Excel helps you restore columns and access hidden data, saving you the time and effort of manually searching the workbook.

  • Open the spreadsheet in Excel.

  • Click on the arrow in the top left corner of the Excel spreadsheet. This highlights all data in the workbook.

  • Click "Format" in the "Cells" menu along the top of the page. A drop-down menu appears.

  • Click "Hide & Unhide" under the "Visibility" heading, then click "Unhide Columns." Changes are applied instantly and all columns are visible.

Related Searches


  • Photo Credit Stockbyte/Stockbyte/Getty Images
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!