Hiding and unhiding columns in your spreadsheet is a convenient way to show just the data that you need to focus on. Now and then, you may accidentally hide a column and wonder where it went. Here’s how to unhide columns in Excel.
Read more: How to add, hide, or remove columns or rows in Google Sheets
QUICK ANSWER
To unhide a column in Excel, select the columns adjacent to the one(s) hidden, then right-click and select Unhide from the drop-down menu.
How to unhide columns in Excel
You will see a grey double-line between the two adjacent columns to indicate that a column is hidden in your spreadsheet. SImply double-click on that to reveal the hidden column.
Adam Birney / Android Authority
Alternatively, you can select both adjacent columns by clicking and holding over them or pressing Ctrl on the keyboard to select them. Then, right-click the selected columns and choose Unhide.
Adam Birney / Android Authority
If your columns are not unhiding, double-check that View–> Freeze panes isn’t enabled.
If your rows are not unhiding, double-check that View–> Freeze panes isn’t enabled.
If you’re familiar with VBA and macros, you can also insert the following basic macro to unhide all of your columns. This can save a little bit of time instead of using the menu.
Sub UnhideAllColumns ()
Cells.EntireColumn.Hidden = False
Click the triangle symbol in the top left corner between your column and rows in Excel to select your entire sheet. Then, right-click and choose Unhide.
