
Not necessary to select the immediate left or right columns. Identify the hidden column/s and select the from a left column to right beyond the hidden column/s. Unhide other single or multiple column/sġ.

This method can also be used to unhide any single column. Then go to ‘ Visibility’ > ‘ Hide & Unhide’ > ‘ Unhide Column’Ĥ. Then go to ‘ Home’ tab > ‘Format’ button to get the dropdown menu.ģ. Type ‘ A1’ in the ‘ Name Box’ and press Enter Key to select the first hidden column.Ģ. When it comes to unhide the columns, there are a few ways to do it as explained below.ġ. The hidden columns can be identified because the numbers are skipped and a double line will be displayed when the cursor is on the place of the hidden columns. When the pointer changes from the selection arrow to a double arrow - this will happen as the mouse pointer nears the Select All cell - right-click and choose Unhide.When you have some data columnsthat you don’t want to display can be hidden from the sheet.

Hiding a column tucks data out of sight without interfering with its function. Even you won’t want to see all of it all the time. Confidentiality aside, sometimes endless data is just a nuisance. Not everything in your worksheet needs to be privy to everyone. Fortunately, there are two simple tricks for unhiding it.

The secret to unhiding column A in an Excel worksheetĪfter you hide column A, it might seem like it's gone forever.
