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