Excel Operation Guide

Filtering and Organization

Learn filtering, sorting, and organizing operations for worksheet data.

filtersortorganizeextractuniquefreeze panesautofitcolumn width

Related shortcuts

Toggle AutoFilter

Ctrl + Shift + L

Open Filter Menu

Alt + Down

Select to Edge of Data

Ctrl + Shift + Up

Move to Edge of Data

Ctrl + Up

Select Entire Column

Ctrl + Space

Start shortcut practice for this operation

Related formulas

FILTER

Filters rows using include condition.

SORT

Sorts an array by specified index/order.

SORTBY

Sorts array by another array.

UNIQUE

Returns unique values from a range.

Start formula practice for this operation