Home MS Excel TutorialExcelTips and Tricks How To Unhide Columns In Excel

How To Unhide Columns In Excel

by Easy Excel Tutorials

How To Unhide Columns In Excel

In this lesson you will learn how to unhide columns in your spreadsheet. This tutorial lets you to see hidden data.

Some of cells are hidden? Read this tutorial and learn how to see every column in Excel.

Your sheet looks like this.

Excel hidden columns

As you can see columns D,E and F are missing. They are hidden.

To unhide click button in the corner near to A and 1. It will highlight whole Sheet.

Excel highlight sheet

Next go to Ribbon > Home tab > Cells section. Click Format > Hide & Unhide > Unhide Columns.

Excel Unhide Columns

Done! You did it! Columns are unhidden.

Excel Unhidden Columns


You can download the Template here – Download

Further reading: 
Basic concepts 
Getting started with Excel
Cell References

You may also like