excel shortcut..

Ungroups rows or columns.

CTRL+8

Displays or hides the outline symbols.

CTRL+9

Hides the selected rows.

CTRL+SHIFT+( (opening parenthesis)

Unhides any hidden rows within the selection.

CTRL+0 (zero)

Hides the selected columns.

CTRL+SHIFT+) (closing parenthesis)

Unhides any hidden columns within the selection.

Keys used with MACROS

ALT+F8

Displays the Macro dialog box.

ALT+F11

Displays the Visual Basic Editor.

F5

Runs a macro in VBA window from the active row (start at the top to run the whole

F9

Toggles Stops on or off (in the VBA window)

F8

Run the macro in step mode (in the VBA window)

Function Arguments dialog box.