General discussion

Locked

Hide/unide Excel worksheet

By Adisha ·
One of my clients has problems where a worksheet gets accidentally hidden. She can't remember the keys she pressed. It is straightforward to unhide (windows > unhide) but as you can imagine very frustrating!

Does anyone know the key combination that hides a worksheet?

Many thanks for your help in advance.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by ShaunJanzen In reply to Hide/unide Excel workshee ...

Press Alt then O then H then H.

Collapse -

by Adisha In reply to

Although this works - this is not quite the key combination I was looking for

Collapse -

by misscrf In reply to Hide/unide Excel workshee ...

This is all I could find on keyboard shortcuts...

Display and use windows

ALT+TAB
Switch to the next program.

ALT+SHIFT+TAB
Switch to the previous program.

CTRL+ESC
Display the Windows Start menu.

CTRL+W or CTRL+F4
Close the selected workbook window.

CTRL+F5
Restore the window size of the selected workbook window.

F6
Switch to the next pane in a worksheet that has been split (Window menu, Split command).

SHIFT+F6
Switch to the previous pane in a worksheet that has been split.

CTRL+F6
When more than one workbook window is open, switch to the next workbook window.

CTRL+SHIFT+F6
Switch to the previous workbook window.

CTRL+F7
When a workbook window is not maximized, perform the Move command (on the Control menu for the workbook window). Use the arrow keys to move the window, and when finished press ESC.

CTRL+F8
When a workbook window is not maximized, perform the Size command (on the Control menu for the workbook window). Use the arrow keys to resize the window, and when finished press ESC.

CTRL+F9
Minimize a workbook window to an icon.

CTRL+F10
Maximize or restore the selected workbook window.

PRTSCR
Copy a picture of the screen to the Clipboard.
ALT+PRINT SCREEN Copy a picture of the selected window to the Clipboard.

Collapse -

by Adisha In reply to

Thanks for the detailed list of shortcuts. I finally got to the root of the problem. There was a hidden macro running in the background that was activated on pressing the keys.

Collapse -

by Adisha In reply to Hide/unide Excel workshee ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums