Excel General Ledger Part 2: Filters

1

Select your table

Then click on Home > Sort & Filter >Filter

Alternatively, the shortcut is: Ctrl + A + A , then Alt, then A, then T


2

Triangle buttons will now appear on the first row of your table.

Click on any triangle and you'll see a list of check boxes to filter.

eg. If you want to filter by food, just uncheck "(Select All)" and check "Food".