To filter an inventory spreadsheet in Excel, click a cell in the data and choose Data > Filter; use the arrows in the header row to show only the items you need. For a reusable inventory list, format the data as a table first, then filter by stock quantity, category, supplier, location, or reorder status without deleting any records.
What filtering does in an inventory list
A filter temporarily hides rows that do not match the conditions you select. The information remains in the worksheet, and clearing the filter brings those rows back. This makes filtering useful for tasks such as checking which products are below their reorder points, viewing stock in one warehouse, or finding all items from a particular supplier.
Filtering is different from sorting. Sorting changes the order of visible records, for example putting the lowest stock quantities first. Filtering limits which records are displayed. You can apply both: filter to show a product category, then sort its remaining rows by quantity. Neither action is a substitute for a backup or for updating inventory records accurately.
A typical inventory sheet has one item per row and consistent column headings, such as SKU, Product, Category, Quantity on Hand, Reorder Point, Supplier, and Location. A filter works best when each column contains one kind of information. If a cell combines several unrelated values, such as a supplier and a location, filtering it becomes less precise.
Prepare the spreadsheet before filtering
Before applying a filter, check that the data forms one uninterrupted block with a single header row. Avoid blank rows or blank columns inside the list: Excel may treat them as boundaries and filter only part of the inventory. Keep explanatory notes, subtotals, and report titles outside the block rather than inserting them between inventory records.
Use a distinct heading for every column. Headings such as Quantity on Hand and Reorder Point are clearer than repeated labels like Quantity. Enter each SKU once per item record, and keep values consistent: a quantity column should contain numbers, not a mixture of numbers and text such as “five” or “about 5.” If the same product is stored in two locations, decide whether to record it as two location-specific rows or as one row with a total; the choice affects what a filtered result means.
For a list that will grow, turn the range into an Excel table. Click inside the data, choose Insert > Table, confirm the selected range, and make sure My table has headers is selected. Tables add filter arrows to the headings and generally extend their range when new rows are entered directly below them. They also make it easier to apply consistent formatting and refer to fields by their column names.
- Use one row for each inventory record and one column for each field.
- Keep units consistent, such as recording all quantities as individual units rather than mixing units and cases.
- Store dates as dates and numbers as numbers, not as text that merely looks similar.
- Check that the table range includes every record before relying on a filtered report.
Apply and clear Excel’s built-in filters
For a normal range, click within the data and select Data > Filter. Excel adds a drop-down arrow to each heading in the detected range. In a table, those arrows are normally present already. Open a heading’s arrow, select or clear the values you want included, and confirm the selection. The exact options vary with the contents of the column: a text field offers text filters, while a numeric field offers number filters.
For example, open the Category filter and select HVAC to show only heating, ventilation, and air-conditioning items. To inspect low stock, open the Quantity on Hand filter and choose Number Filters, then Less Than or Equal To, and enter a threshold. This is useful for a quick review, but a fixed threshold is not necessarily the same as each product’s individual reorder point. Comparing each row’s quantity with its own reorder point requires a more tailored method, such as the formula approach below.
Filters can be applied to more than one column at once. Choosing a location and a category narrows the display to records matching both selections. When reviewing results, look at the filter icons in the headings to identify which columns are filtered. To remove a filter from one field, open that field’s arrow and choose Clear Filter From. To clear filters across the list, use Data > Clear. Clearing filters shows the records again; it does not remove the filter controls.
Useful ways to filter inventory
The most useful filters depend on the decision being made. A purchasing review often focuses on items at or below their reorder point. A warehouse count may focus on one bin or location. A product manager may want a category or supplier view. Filtering is also helpful for finding blank fields, discontinued items, or records with an unexpectedly large quantity, provided the sheet uses consistent labels and values.
- Low stock: filter quantity values below a chosen threshold for a quick exception list. If reorder points differ by item, compare the two columns row by row rather than assuming one threshold fits all.
- Location: select a warehouse, room, aisle, or bin to prepare a local count or transfer review.
- Category or supplier: isolate a product group or vendor when checking assortments or preparing a purchasing discussion.
- Dates: filter a last-counted or received-date column to find records within a date period. Confirm that the cells contain real Excel dates so date filters behave as expected.
- Missing data: select the blank entry in a field such as Supplier or SKU to locate records that need attention.
Filtering can also expose a data-quality issue rather than a stock problem. For example, if an item does not appear under the expected category, its category may be misspelled or contain an extra space. A careful review of the underlying record is better than assuming the filter itself has changed the data.
Show items below their own reorder points with FILTER
Excel for Microsoft 365 includes the FILTER function, which can return matching rows in a separate area of the worksheet. Unlike a normal header filter, it can compare each row’s quantity with that same row’s reorder point. The result updates when the source values change, as long as the formula’s source range includes the updated records and there is room for the returned rows to spill.
Assume the inventory headers are in A1:F1 and rows 2:5 contain this layout: A is SKU, B is Product, C is Category, D is Quantity on Hand, E is Reorder Point, and F is Location. The rows are 1001, Filter cartridge, HVAC, 12, 10, A1; 1002, Belt, HVAC, 4, 6, A2; 1003, Oil filter, Auto, 18, 8, B1; and 1004, Air filter, Auto, 3, 5, B2. Put the following formula in an empty area outside the source table:
=FILTER(A2:F5,D2:D5<=E2:E5,"No items need reorder")
It returns the full records for SKU 1002 and SKU 1004: 4 is less than or equal to 6, and 3 is less than or equal to 5. The other two rows do not meet the condition because 12 is greater than 10 and 18 is greater than 8. This formula assumes the ranges are the same size and that quantities and reorder points are numeric. FILTER is available in Microsoft 365 and Excel 2021 or later; older Excel versions may not support it. On the web, the function is available in supported Excel versions, though the ribbon layout can differ.
Leave the cells below and to the right of the formula clear enough for the returned results; otherwise Excel may report a spill error. Do not put the formula inside the same table range it reads from, because the output needs its own space. A formula-generated view is convenient for monitoring exceptions, but it is not a separate stock ledger: changes to the displayed results should be made in the original records, not in the spilled output.
Keep filtered reports reliable
A filtered view is only as dependable as the source data. Decide how to handle negative stock, backorders, reserved quantities, and items that are not currently available. For instance, if Quantity on Hand means physical stock but some units are reserved, a low-stock filter may not reflect what is actually free to sell. Document the meaning of important fields in a note or a separate instructions sheet so different staff members apply the same interpretation.
When adding records, enter them directly below a table or resize the source range so the new rows are included. If a filtered list appears to be missing recently added products, check the table boundaries and any active filters before assuming records were deleted. Save and share the workbook with an appropriate filename and date when producing a snapshot for a count or purchasing review. A live workbook and a dated report answer different questions: the first reflects current entries, while the second helps explain what was visible at a particular time.
If people sort or filter the same shared workbook, make sure they understand whether they are changing their own view or the shared worksheet view. Excel’s collaboration and view options depend on the workbook and version. When a stable handoff matters, it can be safer to create a copy or export a clearly labeled report rather than expecting every recipient to see the same active filter state.
Common filter problems and fixes
If filter arrows are missing, click within the data and select Data > Filter. Check that the header row is part of the selected range and that blank rows have not divided the list. If only some rows respond to a filter, inspect the range or table boundaries; records outside the active range cannot appear in its results.
If a numeric filter treats quantities unexpectedly, look for numbers stored as text, leading or trailing spaces, or mixed units. Re-enter or convert the values consistently, then try the filter again. Similarly, a category that looks identical may contain a spelling variation or invisible space, causing Excel to treat it as a separate value.
If rows seem to have disappeared, first check which columns show active filter indicators and use Data > Clear. Filtering hides rows, but it does not delete them. If the visible result is still incomplete, verify that the source range includes all records and that no rows are hidden for another reason. These checks help distinguish an ordinary filter from missing or incorrectly entered data.
Frequently Asked Questions
How do I filter an inventory spreadsheet by low stock?
For a quick threshold, open the Quantity on Hand arrow, choose Number Filters, then Less Than or Equal To and enter the threshold. If every product has a different reorder point, use a row-by-row comparison such as the FILTER example above.
Does filtering delete inventory rows?
No. A filter hides records that do not match the selected conditions. Use Data > Clear to show the full list again, and avoid deleting records unless you intend to remove them from the source data.
Can I filter by more than one column?
Yes. Apply a selection in each relevant column. Excel displays rows that meet all the active column filters, such as a particular category at a particular location.
Why is my new inventory item not included in the filter?
The item may have been entered outside the filtered range or table, or an active filter may hide it. Check the table boundaries, enter new records directly below the table where possible, and clear filters to inspect the full list.
Can Excel automatically list products below their reorder points?
Yes. In Microsoft 365 or Excel 2021 and later, FILTER can return rows where Quantity on Hand is less than or equal to Reorder Point. The source ranges must line up, and the output area must have room for the results.