lasascricket.blogg.se - How to unhide a column in excel in windows

You can then choose Column from the Format menu and then choose Unhide.Ī third method is even niftier, provided you have a good eye and a steady mouse pointer. If you release the mouse button when the pointer is over the gray block that marks the intersection of the row and column headers (the blank gray block just above the row headers), then column B and everything to its left, including the hidden column A, are selected. Choose Column from the Format menu, then choose Unhide.Īnother way to display the first column is to click on the header for column B, and then drag the mouse to the left.Cell A1 is now selected, even though you cannot see it on the screen.

In the Reference field at the bottom of the dialog box, enter A1.

Choose Go To from the Edit menu, or press F5.

To unhide the left-most columns of a worksheet when they are hidden, follow these steps: If you later want to unhide column A, the solution isn't so obvious. For instance, if you hide column A, Excel will dutifully follow out your instructions. What isn't so easy is displaying a hidden column if that column is the left-most column in the worksheet. Excel makes it easy to hide and unhide columns.