Free Excel Tips & Tricks

Subscribe to Get Daily Excel Tips & Tricks to your Inbox for Free!

Sunday, July 1, 2018

HIDE AND SHOW ELEMENTS USING SHORTCUT KEYS IN EXCEL

HIDE AND SHOW ELEMENTS USING SHORTCUT KEYS IN EXCEL

CTRL +9
Purpose:Use this excel shortcut key to Hide the selected rows.

CTRL +SHIFT +9
Purpose:Use this excel shortcut key to Unhide any hidden rows within the selection.

CTRL +0 (ZERO)
Purpose:Use this excel shortcut key to Hide the selected columns.

CTRL +SHIFT +0 (ZERO)
Purpose:Use this excel shortcut key to Unhide any hidden columns within the selection*.

CTRL +` (GRAVE ACCENT)
Purpose:Use this excel shortcut key to Alternate between displaying cell values and displaying cell formulas. Accent grave /not a quotation mark.

CTRL +6
Purpose:Use this excel shortcut key to Alternate between hiding and displaying objects.

CTRL +8
Purpose:Use this excel shortcut key to Display or hides the outline symbols.

No comments:

Post a Comment

EDITING CELLS USING EXCEL SHORTCUT KEYS

F2 Purpose: Use this excel shortcut key to Edit the active cell with cursor at end of the line. ALT +ENTER Purpose: Use this exc...