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
Microsoft Excel screenshot 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.