Hiding and unhiding columns on your spreadsheet is a handy option to display simply the knowledge that you want to concentrate on. Every now and then, you might by chance cover a column and sweetness the place it went. Right here’s the best way to unhide columns in Excel.
Learn extra: How to add, hide, or remove columns or rows in Google Sheets
QUICK ANSWER
To unhide a column in Excel, make a choice the columns adjoining to the only(s) hidden, then right-click and make a choice Unhide from the drop-down menu.
Find out how to unhide columns in Excel
You’ll see a gray double-line between the 2 adjoining columns to signify {that a} column is hidden on your spreadsheet. SImply double-click on that to show the hidden column.
Adam Birney / Android Authority
Then again, you’ll make a choice each adjoining columns through clicking and keeping over them or urgent Ctrl at the keyboard to make a choice them. Then, right-click the chosen columns and make a selection Unhide.
Adam Birney / Android Authority
In case your columns aren’t unhiding, double-check that View–> Freeze panes isn’t enabled.
In case your rows aren’t unhiding, double-check that View–> Freeze panes isn’t enabled.
Should you’re accustomed to VBA and macros, you’ll additionally insert the next elementary macro to unhide your whole columns. This will save just a little little bit of time as a substitute of the usage of the menu.
Cells.EntireColumn.Hidden = False
Click on the triangle image within the best left nook between your column and rows in Excel to make a choice all of your sheet. Then, right-click and make a selection Unhide.
