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
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.