Excel filters (AutoFilter) let you show only the rows that match criteria you choose, without deleting anything. Turn filters on from the Data tab or with Ctrl + Shift + L (Windows) / Command + Shift + L (Mac), then use the dropdown arrows on the header row.

Why finance teams use filters

On a P&L, trial balance, or transaction dump, filters help you isolate one entity, department, month, or account class before you write variance commentary. Sorting A to Z or by color from the same dropdown is handy for review. Filters change what you see; they do not replace clean source data. For live QuickBooks actuals in Excel, use LiveFlow FP&A.

Benefits of adding filters in Excel

• Focus: hide rows you do not need while you analyze a subset.

• Sort from the same UI: A to Z, Z to A, or by color without a separate pass.

• Safer than deleting: filtered-out rows remain in the sheet when you clear the filter.

How to enable and apply filters

1. Click any cell inside the table or header row you want to filter.

2. Go to the Data tab and click Filter in the Sort & Filter group, or press Ctrl + Shift + L (Windows) / Command + Shift + L (Mac).

3. Dropdown arrows appear on the header row.

4. Open a column’s filter arrow.

5. Uncheck Select All, check the values you want (for example, only December), then click OK.

You can filter several columns at once. Each additional filter narrows the visible rows further. The same menu also supports text, number, and date filters when your column types support them.

How to clear or turn filters off

1. Open the column’s filter arrow and choose Clear Filter From…, or

2. On the Data tab, click Clear to remove criteria while leaving filter arrows in place, or

3. Click Filter again on the Data tab (or press the shortcut again) to remove filter arrows entirely.

Before you send a board pack, confirm whether filters are still on. Reviewers sometimes miss rows that are only hidden.

Quick finance checklist

• Put headers in one row with unique names.

• Avoid merged header cells; they break AutoFilter.

• Convert a messy block to a Table (Ctrl + T) when you want structured filters that expand with new rows.

• Do not assume a filtered SUM on-screen equals a full-column total unless your formulas use SUBTOTAL or you intentionally sum the visible range.

Why finance teams use LiveFlow

Filters help you interrogate a table. LiveFlow helps you stop rebuilding that table from exports every close. LiveFlow FP&A pulls live accounting data into Excel so the range you filter is already current. Less paste work means fewer broken filter ranges after someone inserts a new CSV dump.

CTA: Book a demo of LiveFlow FP&A for Excel.