Free Excel Tips & Tricks

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

Thursday, July 12, 2018

EXCEL SHORTCUT KEYS FOR SORT AND FILTER

EXCEL SHORTCUT KEYS FOR SORT AND FILTER

ALT + A + Q
Purpose:Use this excel shortcut key to set Advanced Filter in a sheet.

ALT + A + SA
Purpose:Use this excel shortcut key to Sort smallest to largest

ALT + A + SD
Purpose:Use this excel shortcut key to Sort largest to smallest

ALT + A + SS
Purpose:Use this excel shortcut key to Displays the Sort dialog box

ALT + A + V + V
Purpose:Use this excel shortcut key to Display the Data Validation dialog box

ALT + H + S + C
Purpose:Use this excel shortcut key to Clear filter from the sheet.

CTRL + ALT + L
Purpose:Use this excel shortcut key to Reapply filter and sort on current range

CTRL + SHIFT + L
Purpose:Use this excel shortcut key to Turn filter on or off

RIGHT MOUSE BUTTON + E + V
Purpose:Use this excel shortcut key to Filter by the selected cell's value

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