Number Filters in Excel: Complete Guide (2026)

Most Excel tutorials will tell you that number filters are a quick, painless way to slice your data. They're mostly right — until your column shows Text Filters instead of Number Filters, and nothing in the tutorial explains why. That single issue is responsible for more wasted time than any filter option itself, and almost no one writing about this topic addresses it up front. By the end of this guide, you'll know how to apply every meaningful number filter in Excel, what to do when the filter menu doesn't cooperate, and how AutoFilter relates to the FILTER function — two tools that confuse people constantly because they share a name and almost nothing else.

I've been building and maintaining Excel dashboards professionally since 2019, and I still check data types before touching a filter. Not out of habit: out of hard-won reflex. If you're working with data pulled from an ERP, a web export, or anyone else's spreadsheet, assume nothing about what's actually stored in those cells.

The Number Filters submenu inside Excel's AutoFilter dropdown — what it should look like when your column contains true numbers.

Why Excel Sometimes Shows Text Filters Instead of Number Filters

Excel decides which filter menu to show you based on the majority data type in a column. If even a handful of cells contain text — or numbers stored as text — Excel may classify the whole column as text and show you Text Filters instead of Number Filters. The same thing happens when a column has too many blank cells mixed in.

The filter itself isn't the problem. The data coming into the filter is. I spent three hours once debugging a VLOOKUP that was returning nothing, convinced the formula was wrong. It was trailing spaces — invisible characters. The formula was fine. The data was not. Number filters fail the same way: silently, and in a way that makes you question yourself instead of the source data.

If you're seeing Text Filters on a numeric column, select the column, look for Excel's green-triangle warning or the Convert to Number prompt, and apply it before doing anything else. Better yet: enforce data types at the Power Query source so the problem never reaches your sheet. That's my standing rule for any production file.

If you're new to filtering generally, the Excel for Beginners starter guide covers how AutoFilter works before any of this becomes relevant.

Step 1: Apply a Basic Number Filter Using Greater Than, Less Than, or Between

Once you've confirmed your column holds actual numbers (not text dressed up as numbers), enabling AutoFilter takes about three seconds.

1. Click any cell inside your data range.
2. Go to the Data tab on the ribbon and click Filter. Dropdown arrows appear on each column header.
3. Click the dropdown arrow on your numeric column.
4. Hover over Number Filters. A submenu appears with options including Greater Than, Less Than, Between, and several others.
5. Select the condition you want. A Custom AutoFilter dialog opens where you enter your value.

For most day-to-day work — isolating invoices over $5,000, pulling orders below a minimum threshold — Greater Than and Less Than cover it. Between is where people trip up slightly.

How to Filter Between Two Numbers in Excel

Selecting Between opens the Custom AutoFilter dialog with two fields: one for the lower bound, one for the upper. It returns every row in that range, inclusive of the boundary values you enter (assuming your values are actual numbers, not text strings formatted to look like numbers).

You can also build this manually in the Custom AutoFilter dialog using the And radio button: "is greater than or equal to [X]" and "is less than or equal to [Y]." Same result, slightly more control over whether the endpoints are included.

AutoFilter handles large datasets without noticeable lag. Performance isn't a concern for standard filtering operations at typical spreadsheet scale.

Step 2: Use the Top 10 Filter and Above Average Filter for Instant Insights

With your basic filter working, the Top 10 AutoFilter and Above Average options become genuinely useful for quick analysis — and they're underused.

The Top 10 filter doesn't actually mean ten. Click Number Filters → Top 10 and you'll see a dialog with three fields: Top or Bottom, the count (which you can change to 5, 25, or any number), and Items or Percent. "Top 5 Items" gives you the five highest values. "Bottom 10 Percent" gives you the lowest-performing tenth. For spotting outlier invoices or flagging the weakest rows in a sales file, this is faster than sorting.

The Above Average filter is even simpler: one click, no dialog. Excel calculates the column average and shows only rows above it. Below Average works the same way in reverse.

Both options disappear from the Number Filters submenu if Excel has misclassified your column as text. That's not a bug you can filter your way out of — it's the data-type problem from Step 1 showing up again.

Step 3: Clear a Number Filter and Avoid the Mistake That Hides Your Data

After applying the filter you need, clearing it correctly matters more than most guides let on.

Two ways to do it: click the dropdown arrow on the filtered column and select Clear Filter From [Column Name], or go to Data → Clear on the ribbon to remove all active filters across the sheet at once.

The most common mistake — including in my own early work — is closing a workbook while a filter is still active. The file saves with rows hidden. Someone else opens it, sees incomplete data, and either panics or makes decisions based on a partial dataset. Excel does give you visual cues: row numbers turn blue and the dropdown arrow on a filtered column shows a small funnel icon. If you see either of those and weren't expecting them, a filter is active somewhere.

Get into the habit of checking Data → Clear before you save and share any file. It takes one second and prevents a lot of awkward conversations.

Common Number Filter Mistakes in Excel — and How to Fix Them

You set the filter. You expect twelve rows. Excel returns zero. The data is fine. The data is always fine, apparently.

Three problems cause almost every number filter failure I've encountered.

Numbers stored as text. Covered above, but worth repeating because it's that common. SUMIFS returns zero on these. AutoFilter excludes them. The cells look identical to real numbers. Fix it at the Power Query level, or use Convert to Number when Excel flags it.

Blank cells. A column that's 80% numbers and 20% blank can still get classified as a text column by AutoFilter, especially when the blanks are scattered throughout rather than at the bottom. Clean up or fill those blanks before filtering.

Confusing AutoFilter with the FILTER function. This is subtle but leads to real problems, so it's worth addressing directly.

When to Use the FILTER Function Instead of AutoFilter

AutoFilter is UI-based and temporary. It hides rows that don't match your condition — it doesn't move or copy data, and it doesn't update automatically when values change. It's the right tool for ad-hoc analysis: you're exploring a file, you want to see rows above a threshold, you clear the filter and move on.

The FILTER function (available in Microsoft 365) is formula-based and dynamic. It returns a new array of results that updates whenever the source data changes, making it the right tool for dashboards and reports that need to stay current. For filtering numbers greater than a specific value in a live report:

=FILTER(A2:C500, B2:B500>5000)

One argument that isn't optional in production: the third argument. Adding "" as a fallback tells Excel what to display if no rows match. Skip it and you get a #CALC! error instead of a blank. I learned this when an operational dashboard ran for eleven months before breaking in December, the first time a region had zero qualifying orders. The formula had no fallback. The dashboard showed an error.

You can also combine numeric criteria inside FILTER using the multiplication operator as AND logic:

=FILTER(A2:C500, (B2:B500>1000)*(B2:B500<5000))

This returns rows where the value is both above $1,000 and below $5,000 — no separate dialog, no Custom AutoFilter, just array logic that works cleanly once you understand the pattern.

For a broader look at how filtering fits into your data workflow, the guide on sorting and filtering in Excel covers how these tools interact. If you're on a Mac, some ribbon steps look slightly different — the Excel sorting and filtering guide for Mac walks through those differences.