Hide shortcut in Excel

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

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

The ribbon is displayed.

Ribbon is hidden

Press Ctrl + F1. The ribbon is now hidden.

Hide the window

The window is displayed on the sheet.

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

Hide the objects

One object is displayed on the sheet.

Press Ctrl + 6. The object is hidden.