How to Filter Greater Than in Excel: Step-by-Step Guide

Formulas & functions · Updated November 20, 2026

To show only values above a threshold in Excel, open the column’s filter menu and choose Number Filters > Greater Than, then enter the cutoff value. Excel hides rows that do not meet the condition; it does not delete them. This guide covers the steps in Excel for Microsoft 365 on Windows, plus practical notes for dates, tables, and common problems.

What You’ll Need

  • A worksheet with a header row and one column of values you want to filter, such as prices, quantities, scores, or dates.
  • Values that Excel recognizes as numbers or dates. If the column contains numbers stored as text, you may need to convert them first.
  • A clear threshold to compare against, such as 80 to display scores strictly above 80.

Filtering works best when each row is one record, each column has a single descriptive header, and there are no completely blank rows inside the data. If the range is already formatted as an Excel table, its headers normally have filter arrows already.

Step-by-Step

  1. Check the data and choose the column. Find the column containing the values you want to compare. For example, a list might have headers for Employee, Region, and Sales, with sales figures in the Sales column. Confirm that the first row contains headers and that the data beneath the selected header is consistently numeric. Mixed entries such as “pending” among amounts can affect which filter options Excel offers.
  2. Turn on the filter arrows if they are not visible. Click a cell inside the data range. On the Windows ribbon, select Data > Filter. Excel adds a drop-down arrow to each header in the detected range. If the range is an Excel table, look for the arrows in the table headers instead; there is no need to add another filter. On Mac, use the Data tab and select Filter; the command is also available in Excel for the web on the Data tab.
  3. Open the menu for the value column. Select the arrow beside the relevant header—not the arrow for a different field. In the example, choose the arrow beside Sales. Excel displays a menu with sorting options, a search box, and filtering choices. If Excel recognizes the column as numeric, the menu includes Number Filters. If it is a date column, look for Date Filters instead.
  4. Choose the greater-than condition. Point to or select Number Filters, then choose Greater Than. A Custom AutoFilter dialog opens. In Excel for the web, the menu layout can look a little different, but choose the numeric filter option and the greater-than condition. Do not choose “Greater Than Or Equal To” if the cutoff value itself must be excluded.
  5. Enter the cutoff. In the dialog’s value field, type the number that marks the lower boundary. For example, enter 80 to keep scores above 80. The condition is exclusive: a row containing exactly 80 will not remain visible. You can enter decimals, such as 80.5, or negative values when they make sense for the data. Use the number format expected by your regional settings; Excel may use a comma or a period as the decimal separator.
  6. Apply the filter. Select OK. Excel displays the rows whose values are greater than the cutoff and hides the others. The row numbers may skip—for example, 2, 5, and 9—because the intervening rows are filtered out. The filter arrow usually shows a filter indicator, so you can tell that the column has an active condition. The underlying records remain in the worksheet.
  7. Check the results and remove or change the condition when needed. Scan a few visible values to confirm that each is above the cutoff and that a value equal to the cutoff is excluded. To change the threshold, reopen that column’s arrow, choose Number Filters > Greater Than, enter the new value, and select OK. To show all values in that column again, open its arrow and select Clear Filter From [column name]. You can also use Data > Clear to clear filters from the range while leaving the filter controls available.

For instance, with a Sales column containing 75, 80, 92, and 115, a filter greater than 80 leaves 92 and 115 visible. It excludes both 75 and 80. If you actually mean “80 or higher,” choose Greater Than Or Equal To and enter 80. Being precise about that boundary prevents a common reporting error.

Common Mistakes

  • Choosing the wrong comparison. “Greater Than” excludes values equal to the cutoff. Use “Greater Than Or Equal To” when the boundary should count.
  • Filtering the wrong column. The filter condition applies to the column whose header arrow you opened. Check the header name in the menu or dialog before applying the rule.
  • Assuming hidden rows were deleted. AutoFilter temporarily hides nonmatching rows. They remain in the workbook and reappear when you clear or change the filter.
  • Using a number filter on text. If amounts or scores are stored as text, Excel may show Text Filters instead of Number Filters, or results may be unexpected. A currency symbol or other characters typed into cells can also make values inconsistent.
  • Ignoring other active filters. Filters in separate columns work together. A greater-than condition may be correct but still show fewer rows than expected because another column is also filtered.
  • Selecting only part of the list. Applying a filter to a partial range can leave related rows outside the filtered area. Keep the dataset contiguous and click within it before turning on Filter.

Tips

  • Convert a clean range to a table. Select a cell in the data and choose Insert > Table, then confirm whether the table has headers. Tables include filter arrows and generally expand to include new rows, which helps keep a growing list together. Check that the table range includes all the records you intend to analyze.
  • Use a second condition when necessary. The Custom AutoFilter dialog can let you combine two conditions for the same column. For example, greater than 80 and less than 100 returns values in that interval, excluding both endpoints. Choose And when both rules must be true. Choose Or when either rule can be true; for example, values below 10 or above 90.
  • Combine filters across columns deliberately. You can filter Sales to show amounts above 1,000 and then filter Region to show West. Excel keeps rows that meet both column filters. If the result seems too narrow, check every header for an active filter indicator.
  • Use the date-specific menu for dates. Dates are stored as serial numbers by Excel, but the menu typically presents date options. For dates after a particular day, open the date column’s arrow and choose Date Filters > After, then enter the date. “After” excludes the date entered. If the column includes times as well as dates, confirm whether the time component changes which records qualify.
  • Keep the original values intact. A filter changes what is shown, not the values. If you need a separate list of matching records, copy the visible rows carefully or use a reporting method appropriate to your Excel version; do not mistake the filtered view for a new, permanent dataset.

Troubleshooting

Number Filters is missing. Excel may interpret the selected column as text because some cells contain text, leading apostrophes, spaces, or inconsistent entries. Check a few cells and use a blank cell to test whether a value behaves like a number. Remove unintended characters and convert the entries to numeric values, then reopen the filter menu. Avoid converting labels such as “not available” into zero unless zero is genuinely the correct value.

The results include too few or too many rows. Confirm the cutoff and comparison operator, then inspect other columns for active filters. Also check whether the intended rule is strict greater-than or greater-than-or-equal-to. If the numbers contain decimals, a displayed value may be rounded: a cell shown as 80 could actually contain 80.4 and therefore pass a greater-than-80 filter. Increase the displayed decimal places or inspect the value in the formula bar.

The filter arrow is missing or some records do not respond. Click inside the data and check that the filter range covers every row and column. A blank row or column can cause Excel to detect only part of a list. Remove unintended gaps or select the full range before choosing Data > Filter. For a table, check Table Design and confirm the missing records are inside the table.

Dates are sorted or filtered unexpectedly. Some entries may be text that looks like a date, or the cells may use different regional date conventions. Make the date values consistent and confirm that Excel recognizes them as dates. If a timestamp includes a time, a comparison at midnight can produce a different result than a comparison against a date-only value.

Rows do not reappear after changing the filter. Clear the filter from each relevant column, since clearing only one column does not remove conditions in others. If rows are still hidden, check for manually hidden rows or another filter in the workbook. Choosing Data > Clear removes active filter criteria from the current range but does not erase data.

Frequently Asked Questions

Does “greater than” include the number I enter?
No. Greater Than is a strict comparison: a value of 81 passes a filter greater than 80, while 80 does not. Choose Greater Than Or Equal To if 80 should also appear.

Can I filter for values greater than a date?
Yes. Open the date column’s filter menu and use Date Filters > After, then enter the comparison date. Dates after that day are shown; the date entered itself is excluded. Check for times or text-formatted dates if the results do not match expectations.

Can I filter two columns at the same time?
Yes. Apply a filter to the first column, then apply another to the second. Excel shows rows that satisfy both active column filters. Clear each column’s condition separately if you want to return to the full list.

Will filtering change or delete my data?
No. AutoFilter hides rows that fail the criteria and leaves their contents in place. Clear the filter to display them again. Be cautious when copying or deleting rows from a filtered range, because the visible view can differ from the full dataset.

Why can’t I see Number Filters?
Excel usually offers Number Filters when it recognizes the column entries as numbers. If it shows Text Filters instead, inspect for numbers stored as text, extra spaces, or mixed text and numeric values. Convert consistent numeric entries and reopen the menu.

Can I use a greater-than filter in Excel for Mac or the web?
Yes. The filter menus work in current Excel for Mac and Excel for the web, though the ribbon or menu layout can differ slightly from Windows. On Mac, use the Data tab to enable Filter if needed, then open the relevant column menu and select the greater-than option.

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.