Free Excel Tips & Tricks

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

Monday, July 16, 2018

EXCEL SHORTCUT KEYS FOR DISPLAY

EXCEL SHORTCUT KEYS FOR DISPLAY

ALT
Purpose:Use this excel shortcut key to Turn key tips (Ribbon keyboard shortcuts) On or Off. Alt is also under the Navigation and Selection category.

ALT + W + F + F
Purpose:Use this excel shortcut key to Freeze Panes at active cell

ALT + W + I
Purpose:Use this excel shortcut key to Page Break Preview of worksheet.

ALT + W + L
Purpose:Use this excel shortcut key to Normal View of the sheet.

ALT + W + Q
Purpose:Use this excel shortcut key to Display the Zoom dialog box

ALT + W + VG
Purpose:Use this excel shortcut key to View/hide gridlines.

CTRL + `
Purpose:Use this excel shortcut key to Toggle between (A) displaying cell values and (B) displaying formulas in worksheet

CTRL + 6
Purpose:Use this excel shortcut key to Alternate between hiding and showing object(s)

CTRL + F1
Purpose:Use this excel shortcut key to Expand or collapse the Ribbon

CTRL + F10
Purpose:Use this excel shortcut key to Maximize/restore current selected workbook window

CTRL + SCROLL MOUSE WHEEL
Purpose:Use this excel shortcut key to Zoom in/out of the sheet.

CTRL + SHIFT + U
Purpose:Use this excel shortcut key to Toggle between expanding and collapsing the Formula Bar

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...