pasobmichael.blogg.se - Cannot unhide a column in excel

Cannot unhide a column in excel how to#

Now select the sheet which you want to hide.Ĭlick Hide Sheet from Hide & Unhide options. Repeat the same procedure for it, from Format –> Hide & Unhide options, click Hide Columns, upon click the selected columns will be hidden. The rows 2,3,5 and 7 numbers are now hidden.įor hiding the columns in specific sheet, select the columns you want to hide. Upon click it will automatically hide the selected rows. Now from Hide & Unhide options, click Hide Rows. Selection hold Ctrl key) you want to hide and navigate to Home tab.įrom Cells group, click Format button. In desired spreadsheet select the rows (for multiple non-contagious

Right click on one of the selected rows.

Continue to hold down the CTRL key and left click on the rest of rows to be hidden.

Press and hold down the CTRL key on the keyboard.

In the row header left click on the first row to be hidden.

The selected rows and row numbers will be hidden from view.įor example, you want to hide rows 3, 5, and 7.

In the row header drag select to highlight all of the rows you want to hide.

The selected row and the row number will be be hidden from view.įor example, you want to hide rows 4, 5, and 6.Right click on the row header of the row to be hidden.When you hide a row in a worksheet, data in that row can still be used and referenced in the worksheet. The row header is the gray bar along the left edge of the worksheet containing the row numbers.

Cannot unhide a column in excel how to#

These instructions show you how to hide rows by right clicking on the row header. Your previously missing column A magically reappears.As with all things Microsoft, there is more than one way to hide rows in an Excel worksheet. When your mouse pointer changes to this special double-headed arrow, all you have to do is right-click and choose Unhide. It is different, however, because instead of a black line dividing the double arrows, there are two black lines with a gap between them. This double-headed arrow is a bit difficult to describe it looks most closely like the double-headed arrow that appears when you position the pointer over the dividing line between column headers. If you move your mouse pointer into the column header area, and then slowly move it to the left, you notice that it turns into a double-headed arrow with a blank spot in the middle as you position the pointer over the small area immediately to the left of the column B header.

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.