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.

How to Unhide Columns in Excel

To unhide columns in Microsoft Excel, follow these steps:

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

Another option is to use the keyboard shortcut "Ctrl" + "0" (zero) to unhide the selected columns.

Note: If none of the columns are selected, then Excel will unhide all hidden columns in the worksheet.