Free Excel Tips & Tricks

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

Thursday, July 26, 2018

EXCEL AUTOFILL SHORTCUT KEYS

EXCEL AUTOFILL SHORTCUT KEYS

ALT +ARROW DOWN
Purpose:Use this excel shortcut key to On the field with column head, display the AutoFilter list for the current column .

ARROW DOWN /ARROW UP
Purpose:Use this excel shortcut key to Select the next item / previous item in the AutoFilter list.

ALT +ARROW UP
Purpose:Use this excel shortcut key to Close the AutoFilter list for the current column.

HOME /END
Purpose:Use this excel shortcut key to Select the first item / last item in the AutoFilter list.

ENTER
Purpose:Use this excel shortcut key to Filter the list by using the selected item in the AutoFilter list.

CTRL +SHIFT +L
Purpose:Use this excel shortcut key to Apply filter on selected column headings.

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