lkpforkids.blogg.se - How to unhide a column in excel manually

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.

Hover the mouse over column B’s header cell and move left.

Now, choose Column from the Format menu, and the choose Unhide. Doing so will selecteverything to the left, including column A. Release the mouse with the pointer over the Select All cell (the blank gray cell that intersects the header and row cells). Don’t click any borders, just drag the selection mouse pointer (the fat arrow pointing down).

Click column B’s header cell and drag the mouse pointer to the left.

Don’t panic, column A isn’t gone forever, and there’s more than one way to unhide it: Selecting just column B won’t select column A. That works fine until you try to unhide column A, as there’s only one adjacent column, column B. After selecting the hidden column and its adjacent columns, choose Column from the Format menu and then select Unhide. You’re really selecting three columns: the hidden column and both columns on either side of it. Select the columns that are adjacent to the hidden column. Unhiding a column takes a bit of specialized knowledge, but it isn’t difficult. To hide a column, select it, choose Column from the Format menu, and then select Hide. SEE: Download: Build your Excel skills with these 10 power tips (TechRepublic)

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.