How to unhide columns in Excel

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


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.

unhide column excel

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.

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.

For all the latest Technology News Click Here 

 For the latest news and updates, follow us on Google News

Read original article here

Denial of responsibility! is an automatic aggregator around the global media. All the content are available free on Internet. We have just arranged it in one platform for educational purpose only. In each content, the hyperlink to the primary source is specified. All trademarks belong to their rightful owners, all materials to their authors. If you are the owner of the content and do not want us to publish your materials on our website, please contact us by email – [email protected]. The content will be deleted within 24 hours.