Saturday, October 31, 2015

Excel General Ledger Part 2: Filters


Select your table

Then click on Home > Sort & Filter >Filter

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


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

No comments: