Unhide rows and columns in Microsoft Excel

Unhide rows and columns in Microsoft Excel

Today’s article is an introduction into unhide all rows and columns in Microsoft Excel. There are a several ways to do this. Bellow we will explain and give examples of 6 methods to unhide rows, columns or everything in one go.

Sample files for Unhide rows and columns in Microsoft Excel

The Excel icon links to an Excel file that can be used for training purposes.


Unhide all rows and columns by use of the mouse.

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

Unhide rows and columns in Microsoft Excel by use of 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

Unhide all rows and columns by use of the keyboard shortcuts.

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

Unhide rows and columns in Microsoft Excel, select all
  1. Press [Ctrl] + [A] to select the complete sheet.

    If only the part with data is selected, then hit [Ctrl] + [A] again.
Unhide rows and columns in Microsoft Excel, unhide rows
  1. Press [Ctrl] + [Shift] + [9] to unhide all rows.

    (Use [9] above [O] and [P], not the Num-Lock [0])

All hidden rows should now be visible.

Unhide rows and columns in Microsoft Excel, unhide columns
  1. Press [Ctrl] + [Shift] + [0] to unhide all columns.

    (Use [0] above [O] and [P], not the Num-Lock [0])

All hidden columns should now be visible.


Use the mouse to unhide all rows in Excel

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

Unhide rows and columns in Microsoft Excel
  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

Use the keyboard to unhide all rows in Excel

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.
  1. 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.


Use the mouse to unhide all columns in Excel

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

Unhide rows and columns in Microsoft Excel
  1. Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A.
Unhide rows and columns in Microsoft Excel
  1. Right click with the mouse on any column letter.
    (Only left click on column top letter will work.)
  2. Press [Unhide] in the pop-up menu.

All hidden columns should now be visible


Use the keyboard to unhide all columns in Excel

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.
  1. 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.


Attached you will find a PDF for print out and an Excel sheet containing a record set with hidden rows and columns. So feel free to download and try out the methods above.

Hope you cherished our article about unhiding rows and columns in a dataset in Microsoft Excel

More tips and tricks on Office-Tips.net….

Microsoft Excel keyboard and mouse shortcuts

Microsoft Excel keyboard and mouse shortcuts

In most data programs it makes the user experience so much better it you have knowledge about some keyboard and mouse shortcuts. The contents of this session consists of a set of Microsoft Excel keyboard and mouse shortcuts.

Click here to learn some nice to know keyboard and mouse shortcuts.


Change Office menu language (Microsoft Office)

Change Office menu language (Microsoft Office)

Among users of Office products that doesn’t have English as their native language there is often a wish to change language. That is because they find it easier and handier to use their native language in Office. This article describes how to change Office menu language (Microsoft Office).

What we are looking at then is not to change the spellcheck or synonyms language. That is in fact to change all menus, help texts, codes and so on.

Click here to learn how to change Microsoft Office menu language.


Office-Tips.net article overview

Do you wish to read more of our articles about office products? To get a full overview of all Office-Tips.net articles it is just to [click here].

If user guidance to Excel is the topics you are looking for. Then it is just to [Click here]. This page shows an overview of all Microsoft Excel related articles.

RSS
Follow by Email
LinkedIn
Share