Show / Hide

 

Hide/Unhide

Shortcut

Description

CTRL+0

Hide current column

 CTRL+9

Hide current row

CTRL+SHIFT+9

Unhide current row

CTRL+SHIFT+(

Unhide rows within selection

CTRL+SHIFT+)

Unhide columns within selection

CTRL+6

Alternates between hiding and displaying objects

 

Outline Symbol Display

Shortcut

Description

CTRL+8

Toggle outline symbol display

 

Visible Cells

Shortcut

Description

ALT+;

Select visible cells only - use when copying collapsed outline levels

 

Group/Ungroup

Shortcut

Description

SHIFT+ALT+ARROW LEFT

Open Group Selection Dialog Box

SHIFT+ALT+ARROW RIGHT

Open Ungroup Selection Dialog Box

 

Views

Shortcut

Description

ALT+W+P

Switches the worksheet to Page Layout View

ALT+W+L

Switches the worksheet to Normal view

ALT+W+I

Switches the worksheet to Page Break preview

 

Objects

Shortcut

Description

SHIFT+F7

View an object

 

 

Copyright © 2013-2017 Jiri Pik

Document Version: Sunday, May 7, 2017