Best daily deals
Best daily deals

Links on Android Authority may earn us a commission. Learn more.

How to unhide columns in Excel

Did your column disappear? Here's how to find it.
By
August 3, 2022

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.

excel 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.

unhide column excel
Adam Birney / Android Authority

You should now be able to see all of your columns. To hide columns, follow the same steps but select Hide instead.


Read more: How to separate text into columns on Google Docs

FAQs

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

EndSub

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.