How to unhide all rows & columns in Excel
(mouse version)

In this article we will explain an easy way of unhiding all rows and columns in Excel by use of the mouse.

  1. Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A
  2. Right click any row number or anywhere inside the sheet (but not on column letters).
  3. Press [Unhide] in the pop-up menu.
    All hidden rows should now be visible
  4. Right click on any column letter.
    (Only left click on column top letter will work.)
  5. Press [Unhide] in the pop-up menu.
    All hidden columns should now be visible

How to unhide all rows & columns in Excel
(Keyboard version)

This part explains how to unhide all rows and columns in Excel by use of the keyboard.

  1. Press [Ctrl] + [A] to select the complete sheet.
    If only the part with data is selected, then hit [Ctrl] + [A] again.

  2. Press [Ctrl] + [Shift] + [9] to unhide all rows.
    (Use [9] above [I] and [O], not the Num-Lock [0])
    All hidden rows should now be visible.

  3. Press [Ctrl] + [Shift] + [0] to unhide all columns.
    (Use [0] above [I] and [O], not the Num-Lock [0])
    All hidden columns should now be visible.

How to unhide all rows in Excel
(mouse version)

In this part we will use the mouse to unhide all rows but keep any hidden columns.

1. Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A.

2. Right click on any row number or inside the sheet.

3. Press [Unhide] in the pop-up menu.
All hidden rows should now be visible

How to unhide all rows in Excel
(Keyboard version)

Here is a short explanation how to unhide all rows by use of the keyboard but keep hidden columns.

  1. Press [Ctrl] + [A] to select the complete sheet.
    If only the part with data is selected, then hit [Ctrl] + [A] again.

  2. Press [Ctrl] + [Shift] + [9] to unhide all rows.
    (Use [9] above [I] and [O], not the Num-Lock [9])

All hidden rows should now be visible.

How to unhide all columns in Excel
(mouse version)

In this section we will use the mouse to unhide all columns but keep hidden rows.

  1. Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A.

  2. Right click with the mouse on any column letter.
    (Only left click on column top letter will work.)

  3. Press [Unhide] in the pop-up menu.

All hidden columns should now be visible

How to unhide all columns in Excel
(Keyboard version)

Here is a short story how to unhide all columns with use of the keyboard.

  1. Press [Ctrl] + [A] to select the complete sheet.
    If only the part with data is selected, then hit [Ctrl] + [A] again.

  2. Press [Ctrl] + [Shift] + [0] to unhide all columns.
    (Use [0] above [I] and [O], not the Num-Lock [0])

All hidden columns should now be visible.

Please follow and like us:
error
RSS
Follow by Email
Facebook
Twitter
LinkedIn