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.
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.
Next go to Ribbon > Home tab > Cells section. Click Format > Hide & Unhide > Unhide Columns.
Done! You did it! Columns are unhidden.
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.