what is the shortcut key for filter and sort.



0
how can we use filter and sort data option on keyboard directly.

3 Answer(s)


0

Ctrl+shift+L

0

The shortcut key for Sort and filter is Ctrl+shift+L

0

Sorting is arranging your data in a specific order.

Filtering is a way to extract only certain data form your spreadsheet.

CTRL+SHIFT+L is the shortcut to apply a filter on selected column headings.

To use the shortcuts from the Excel Ribbon, press ALT + H.