Ctrl+6: Hide and Display Objects

The shortcut Ctrl+6 is to switch between hiding and displaying objects.

Step 1: Click anywhere in the worksheet;

Step 2: Press and hold the Ctrl key, then press number 6 from the keyboard in the alphanumeric area. The objects will disappear.

Press the shortcut Ctrl+6 again to show the objects.

Check More Excel Shortcuts

Leave a Reply