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.
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.
- Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A
- Right click any row number or anywhere inside the sheet (but not on column letters).
- Press [Unhide] in the pop-up menu. All hidden rows should now be visible.
- Right click on any column letter.(Only left click on column top letter will work.)
- 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.
- Press [Ctrl] + [A] to select the complete sheet.
If only the part with data is selected, then hit [Ctrl] + [A] again.
- 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.
- 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.
- Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A.
- Right click on any row number or inside the sheet.
- 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.
- Press [Ctrl] + [A] to select the complete sheet.
If only the part with data is selected, then hit [Ctrl] + [A] again.
- 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.
- Left click with the mouse in the upper left corner of the sheet, above row 1 and left of column A.
- Right click with the mouse on any column letter.
(Only left click on column top letter will work.) - 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.
- Press [Ctrl] + [A] to select the complete sheet.
If only the part with data is selected, then hit [Ctrl] + [A] again.
- 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
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)
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.