Excel Hack

Hide shortcut in Excel

Hiding in Excel is one of those tasks that many users take for granted. In most cases, it is done using the mouse. If you need to hide rows or columns frequently, it is recommended that you use shortcuts. There are also shortcuts to hide ribbons, windows, etc. It is useful to remember these shortcuts.

Hide shortcut

Hide the ribbon

Windows
Ctrl + F1

Mac
command + F1

Hide the window

Windows
Access key: Alt + W + H

Mac
None

Hide the objects

Windows
Ctrl + 6

Mac
command + 6 or control + 6

Hide the ribbon

For information on how to hide the ribbon with a shortcut, see below.

Total Time: 1 minute

Ribbon is displayed

Ribbon is displayed

The ribbon is displayed.

Ribbon is hidden

Hide ribbon

Press Ctrl + F1. The ribbon is now hidden.

Hide the window

Window is displayed

The window is displayed on the sheet.

Hiding window

Press Alt + W + H. The window on the sheet is now hidden.

Hide the objects

Displaying Objects

One object is displayed on the sheet.

Objects are hidden

Press Ctrl + 6. The object is hidden.

Articles related to Hide & Shortcut