Unhide shortcut in Excel
In Excel, shortcuts can be used to unhide rows and columns, as well as ribbons, windows, and data in the same column. Most of the unhide is done with the mouse, but shortcuts can dramatically improve work efficiency. We recommend that you learn to use shortcuts and make it a habit to do so, as improved work efficiency leads to increased productivity.
Shortcut for Unhide
Unhide the ribbon
Windows
Ctrl + F1
Mac
command + option + R
Unhide the window
Windows
Access key: Alt + W + U
Mac
None
Unhide objects
Windows
Ctrl + 6
Mac
command + 6 or control + 6
Unhide data in the same column
Windows
Alt + ↓ (Down Arrow key)
Mac
option + ↓ (Down Arrow key)
Unhide the ribbon
For information on how to unhide a hidden ribbon, see below.
Total Time: 1 minute
Ribbon is hidden
The ribbon is hidden.
Unhide Ribbon
Press Ctrl + F1. The ribbon is now unhide.
Unhide the window
The window is hidden.
Press Alt + W + U. The Unhide dialog box appears.
Confirm the workbook to be unhide.
Press Enter. The window has been unhide.
Unhide objects
The object is hidden on the sheet.
Press Ctrl + 6.
The object is now redisplayed.
Unhide data in the same column
Select the cells in which you want the column data to be reflected.
Press Alt + ↓ (Down Arrow key) to list the column data.
Press ↓ (Down arrow key) several times to select the data you wish to reflect.
Press Enter. The selected cell now reflects the column data.