Filter a Spreadsheet by Multiple Drop-Down Selections

To show records from East or West that are also Published, select East and West in the Region column’s filter menu, then Published in the Status menu. To build a separate result that changes when you choose options in cells, connect those drop-down cells to a FILTER formula instead.

These are different controls:

• Column-header filter menus select which existing rows to display.
• In-cell drop-down lists store choices. They need a formula or another filtering mechanism to produce a matching table.

Start with a small, checkable table

Enter this fictional grant dataset in A1:D7. Each row represents one grant; amounts are numeric USD values. The steps below use desktop interfaces.

Grant_ID	Region	Status	Amount_USD
G01	East	Published	12000
G02	East	Draft	8000
G03	West	Published	15000
G04	North	Published	6000
G05	East	Published	9000
G06	West	Draft	11000

The rule (East OR West) AND Published should return G01, G03 and G05. Selecting East alone with Published should return G01 and G05.

Option 1: Select multiple values in column filters

This is the shortest route when you only need to inspect matching rows.

Excel

1. Select A1:D7, then choose Data → Filter.
2. Open the Region header menu. Clear (Select All), check East and West, then select OK.
3. Open the Status menu, leave only Published checked, and select OK.

Excel’s filter menus let you check multiple list values. Filters across columns are additive: each additional column filter further narrows the current result. Thus the region selections act as OR, while the status restriction acts as AND. Microsoft’s filtering guide

Google Sheets

Select A1:D7, choose Data → Create a filter, then use each header’s Filter by values controls to keep the same region and status values. Click OK after each selection. In a shared spreadsheet, use Data → Create filter view if you want the filtering to apply only to your view rather than change everyone’s displayed table. Google’s filter and filter-view instructions

Filtering hides rows; it does not remove them. Do not treat a filtered source workbook as a publication-ready extract.

Option 2: Use two drop-down cells to generate a result

Use this when you want clearly labeled selectors above a reusable output table. Each selector will hold one choice.

Set up the Excel selectors

Use Excel for Microsoft 365, Excel 2024 or Excel 2021 for this formula workflow; Microsoft lists these versions as supporting FILTER. FILTER documentation

1. Type Region in G1 and Status in H1.
2. Enter All, East, West, North vertically in J2:J5, one option per cell.
3. Enter All, Published, Draft vertically in K2:K4, one option per cell.
4. Select G2. Open Data → Data Validation. On the Settings tab, set Allow to List and Source to =$J$2:$J$5. Ensure In-cell dropdown is checked, then select OK.
5. Repeat for H2, using =$K$2:$K$4.
6. Choose East in G2 and Published in H2.

These are standard data-validation lists populated from worksheet ranges. Microsoft’s drop-down setup instructions

Here, All is a control option meaning “do not restrict this field,” not a category in the source data. Use a different label if your dataset already has a category named All.

Add the Excel result formula

Copy the four source headers into A10:D10. In A11, enter:

=FILTER(A2:D7,
  (((G2="All")+(B2:B7=G2))>0)*
  (((H2="All")+(C2:C7=H2))>0),
  "No matching rows")

For each source row:

• The region test passes if G2 is All or the row’s Region equals G2.
• The status test passes if H2 is All or the row’s Status equals H2.
• Multiplication requires both tests to pass.

Excel uses + for OR and * for AND in these array tests; the final argument supplies the message when nothing matches. Microsoft’s multiple-criteria examples

Enter the formula once. The result expands into neighboring cells, a behavior called spilling. Keep the output area empty and place the formula outside any Excel Table; blocked output cells can cause #SPILL!. Microsoft’s spill guidance

Adapt the selectors for Google Sheets

Use the same labels in G1:H1 and option lists in J2:J5 and K2:K4. Select G2, choose Data → Data validation → Add rule, and use Dropdown from a range with J2:J5. Click Done, then repeat for H2 with K2:K4. Keep these selectors single-choice and choose East and Published. Google’s drop-down instructions

Copy the source headers into A10:D10, then use this formula in A11 instead:

=FILTER(A2:D7,
  ((G2="All")+(B2:B7=G2))>0,
  ((H2="All")+(C2:C7=H2))>0)

Sheets accepts separate condition arguments. Every condition must match the source range’s length; when no rows match, Sheets returns #N/A rather than accepting Excel’s third-argument fallback message. Google’s FILTER reference

Google Sheets also supports Allow multiple selections for chip-format drop-downs, but the formulas above are designed for one choice per selector—not several selected chips in one cell. For multiple regions, use Option 1. As documented in October 2026, multiple chip selections are not available on mobile. Google’s multi-selection restrictions

Check the result before publishing

With either formula, verify these cases against the sample:

Region choice	Status choice	Expected result
East	Published	G01, G05
All	Published	G01, G03, G04, G05
North	Draft	Excel: “No matching rows”; Sheets: #N/A
All	All	All six grants

The example formulas stop at row 7. For a larger file, place the output below the final source row, leaving room for it to expand, then extend every source and condition range to the same final row. Do not let the source range overlap the output. For more complex selection rules, see Excel FILTER with AND and OR criteria.

For a public extract from the formula output, copy only the result headers and matching records, then paste them as values into a new workbook. Exclude selector cells, option lists and any no-match message or error.

If you used column filters in Excel on Windows, select the filtered source range, then choose Home → Find & Select → Go To Special → Visible cells only → OK before copying. Paste as values into a new workbook. Excel for the web does not offer this visible-cell selection for an ordinary range; use the formula-output route instead. Microsoft’s visible-cell copying instructions

Reopen the finished export and check its row count, IDs, fields and amounts. Document the selection rule, source and extract date alongside the dataset. Remove sensitive information before uploading—not merely by hiding rows or columns.

TablePage accepts CSV, TSV, XLSX and XLS files and creates a public dataset page with a filterable table. Upload the reviewed extract if readers should see only that subset, or a reviewed full dataset if they should explore all approved records.