Unhide shortcut in Excel

• Release Feb 1, 2022Update Aug 24, 2022
• Written in Excel for Microsoft 365 version 2202

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.