How to Filter by Number in Excel: A Step-by-Step Guide

Formulas & functions · Updated November 20, 2026

To filter by number in Excel, select a cell in your data, choose Data > Filter, open the arrow in the numeric column’s header, and select Number Filters. Choose a condition such as Greater Than or Between, enter the value or values, and apply it. Excel hides rows that do not match; it does not delete them. You’ll need a range of data with a clear header row, and the values you want to filter must be recognized as numbers.

What You’ll Need

  • An Excel workbook containing a list or table with a header above each column.
  • A column that contains numeric values, such as prices, quantities, scores, or percentages.
  • Excel for Microsoft 365 on Windows for the steps below. The commands are similar in Excel for Mac and Excel for the web, although the ribbon layout can vary slightly.

You do not need a formula or an add-in. If your data is a simple range, make sure there are no completely blank rows or columns splitting the list. If it is already an Excel table, its header row normally has filter arrows built in.

Step-by-Step

  1. Prepare the data. Check that every column has a distinct header, such as Item, Units, or Cost, and that each row represents one record. Avoid merged cells in the data area. In the column you plan to filter, check that the entries are actual numbers rather than numbers stored as text. A quick clue is alignment: numbers commonly align to the right by default, while text commonly aligns left, although custom formatting can change this. If a value has a warning icon, Excel may offer a Convert to Number option.
  2. Select a cell in the data range. Click any cell inside the list, rather than selecting just the numeric column. Excel usually detects the connected range and includes its header row. If the range has blank rows or columns within it, select the complete range manually, including the headers, so Excel does not miss records beyond a gap. For an Excel table, click a cell in the table.
  3. Turn on the filter arrows. On the Windows ribbon, select Data > Filter. Excel adds a drop-down arrow to each header in the selected range. If the arrows are already visible, filtering is enabled and you can continue. You can also toggle AutoFilter with Ctrl+Shift+L on Windows. On a Mac, use Command+Shift+F; ribbon labels and shortcut behavior can vary by Excel release and keyboard settings.
  4. Open the numeric column’s menu. Click the arrow in the header of the column you want to filter, such as Sales or Score. In the menu, point to or select Number Filters. The checklist of individual values lets you select particular entries, but Number Filters is the better choice when you want a rule such as greater than a value or within a range. If Number Filters is missing, Excel may not recognize the column as numeric; see Troubleshooting.
  5. Choose a condition and enter its value. Select the rule that fits your question. For example, choose Greater Than to keep values above a threshold, Less Than or Equal To to include values up to a limit, or Between to specify a lower and upper bound. In the Custom AutoFilter dialog, enter the comparison value or values. For example, to show scores from 70 through 89, choose Between, enter 70 in the first box and 89 in the second, then confirm. Between includes both endpoints.
  6. Set how two conditions work, if needed. Some rules open a Custom AutoFilter dialog with two condition lines. Select And when a value must satisfy both rules, such as greater than or equal to 70 and less than 90. Select Or when either rule can match, such as less than 10 or greater than 100. Check the operators and values carefully: using Or for a bounded range can include values outside the range, while using And for two unrelated alternatives may return no rows.
  7. Apply the filter and review the result. Confirm the dialog, usually by selecting OK. Excel hides records that do not meet the rule and leaves the matching rows visible. Look at the column’s filter icon or arrow to confirm a filter is active. If the result is not what you expected, reopen the menu and verify the operator, value, and And/Or choice. Filtering changes which rows are displayed, not the contents of the workbook.
  8. Clear or change the rule when finished. Open the filtered column’s arrow and choose Clear Filter From followed by the column name, or use Data > Clear to clear filters across the range. The exact wording in the drop-down can vary slightly by Excel version. To remove all filter arrows, select Data > Filter again. Clearing a filter shows hidden records; it does not erase or reset the data.

Number Filters also includes useful ready-made choices such as Top 10, Above Average, and Below Average. Top 10 opens a dialog where you can change the number and choose items or percent, so it can show, for example, the top five values rather than the default ten. Above Average and Below Average compare values in that column with its average; they are not fixed numeric cutoffs. These choices can be useful for quick checks, but use a specific numeric condition when you need an exact threshold.

You can filter more than one column at a time. For example, filter Region to show North and then filter Revenue to show values greater than 500. Excel applies both filters together, so a row must satisfy the active rules to remain visible. To see the effect of only one column’s rule, clear the other column’s filter rather than turning off filtering for the entire range.

Common Mistakes

  • Filtering only the numeric cells. Selecting a single column without its header or the rest of the records can lead to an incomplete or misaligned filter range. Start by clicking inside the connected list, or select the full data range including headers.
  • Choosing a value checklist instead of Number Filters. Checking individual values is appropriate when you want specific entries, but it is awkward for a condition such as more than 100. Use Number Filters for comparisons and ranges.
  • Using the wrong comparison boundary. Greater Than 50 excludes 50; Greater Than or Equal To 50 includes it. For a range, confirm whether the endpoints should count and choose operators that express that precisely.
  • Mixing And and Or. A bounded range normally needs And, because a number must meet both the lower and upper limit. Or is for alternatives. Choosing the wrong one can produce too many rows or none at all.
  • Assuming hidden rows were deleted. A filter only hides nonmatching rows. Copying or exporting visible results may behave differently depending on how you select and paste, so check the selection before sharing a filtered extract.
  • Including totals or notes in the range. A summary row inside the list can be treated as ordinary data and may distort the results. Keep totals outside the filtered data range or use a table with a separate Total Row.

Tips

  • Format the column for readability. Currency, percentage, and decimal formatting changes how numbers appear, not the underlying comparison. For example, a cell displayed as 25% is stored as 0.25; enter criteria that correspond to the stored value and check the displayed format.
  • Use a table for a growing list. Select the range and choose Insert > Table, making sure My table has headers is selected if Excel prompts you. Tables include filter arrows and generally extend to new rows as you add records, reducing the chance that later entries fall outside the filter range.
  • Use the checklist for a short list of exact values. In the header menu, clear Select All and tick the specific values you want. This is often faster than creating several comparison rules when the desired values are known.
  • Keep the source data intact. Add a new column or duplicate the worksheet before making major edits to a filtered result. A filter itself is reversible, but deleting or pasting over selected rows can change the data.
  • Remember that number formatting is not the same as numeric data. A value that looks like 100 may be text, especially if it was imported with spaces, an apostrophe, or an unusual separator. Convert or clean the underlying values before expecting numerical comparisons.

Troubleshooting

Number Filters does not appear. Excel may see the entries as text, or the column may contain a mixture of numbers, text, and blanks. Select a few cells and inspect the formula bar and cell alignment. For a small set, use the warning icon’s Convert to Number command where available. For a larger imported list, use Data > Text to Columns and complete the wizard, or clean the source values first. Confirm that symbols, spaces, decimal marks, and thousands separators match your regional settings. Reopen the filter menu after conversion.

The filter returns no rows or too many rows. Open the rule again and check the threshold, the comparison operator, and whether the dialog uses And or Or. Verify that the values in the column are on the scale you intended: a percentage may be stored as a decimal, and a currency symbol may only be formatting. Clear other active column filters temporarily to see whether they are excluding otherwise matching records.

Some records are missing from the filter range. Turn off the filter and inspect for blank rows or columns that may have split the original list. Select the full range, including its header row, and choose Data > Filter again. Converting a clean range to a table can help the filter include new records later. If a new row was added outside an existing table or range, expand the table or redefine the filtered range.

Dates do not behave like ordinary numbers. Excel stores dates as serial numbers, but date columns normally offer Date Filters, which are easier to use for calendar periods. Choose Date Filters for options such as before, after, or between dates. Make sure the cells contain real Excel dates rather than text that only looks like a date.

The arrow or rows seem to disappear. If filter arrows are gone, select a cell in the data and choose Data > Filter to turn them back on. If rows are still hidden, choose Data > Clear or clear each active column filter. Also check whether rows were hidden manually or grouped; clearing a filter does not necessarily undo manual hiding or outline grouping.

Frequently Asked Questions

Can I filter numbers between two values?

Yes. Open the numeric column’s arrow, choose Number Filters > Between, enter the lower and upper limits, and confirm. The endpoints are included. If you need to exclude an endpoint, use a custom filter with the appropriate greater-than or less-than operator.

Can I filter for values greater than or equal to a number?

Yes. Choose Number Filters > Greater Than Or Equal To, enter the threshold, and apply the rule. Use Greater Than instead if the threshold itself should not appear in the results.

Can I apply two numeric filters at the same time?

Yes. You can use two conditions in a Custom AutoFilter dialog and select And or Or, or apply filters to separate columns. Excel combines filters across columns, so rows must meet each active column’s filter to stay visible.

Does filtering change or delete my numbers?

No. Filtering temporarily hides rows that do not match. Clear the filter to display them again. Deleting visible rows or editing cells is a separate action and can change the workbook.

Why does Excel treat my numbers as text?

Imported data, leading apostrophes, extra spaces, or regional number separators can cause this. Convert the cells to numbers, remove unwanted characters, and check that decimal and thousands separators match your settings. Then reopen the filter menu.

Can I filter by number in Excel for Mac or the web?

Yes. In both versions, use the Data tab’s Filter command and open the column arrow to find the numeric filter choices. The interface may look slightly different from Windows, but the basic conditions and the idea of clearing a filter are the same.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.