Excel Hack

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

Ribbon is hidden

The ribbon is hidden.

Unhide Ribbon

Unhide Ribbon

Press Ctrl + F1. The ribbon is now unhide.

Unhide the window

Window in hidden state

The window is hidden.

Confirm the file name and press Enter

Press Alt + W + U. The Unhide dialog box appears.

Confirm the workbook to be unhide.

Window Unhide

Press Enter. The window has been unhide.

Unhide objects

Objects are hidden

The object is hidden on the sheet.

Unhide Objects

Press Ctrl + 6.

The object is now redisplayed.

Unhide data in the same column

Select the cells for which you want the column data to be displayed

Select the cells in which you want the column data to be reflected.

Select the column data you want to input

Press Alt + (Down Arrow key) to list the column data.

Press (Down arrow key) several times to select the data you wish to reflect.

Select from and enter column data

Press Enter. The selected cell now reflects the column data.

Articles related to Shortcut & Unhide

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments