Use Excel Filter to Prepare a Clean Dataset for Sharing

To share only approved projects from one region, use Data > Filter to select the matching rows, then copy that subset into a separate release file. For a result that updates when source values change, use the FILTER function instead.

The important distinction: Excel’s dropdown filters hide nonmatching rows; they do not delete them. A filtered working workbook is not a sanitized publication file. Microsoft’s filtering guide explains this behavior.

Start with a clear selection rule

Enter this fictional dataset in A1:E6, with the headers in row 1:

Project_ID	Region	Status	Amount_USD	Year
P01	East	Approved	12000	2026
P02	West	Approved	18000	2026
P03	East	Pending	15000	2026
P04	East	Approved	8000	2026
P05	East	Approved	22000	2026

The selection rule is Region = East AND Status = Approved AND Amount_USD ≥ 10000. The expected result is two records—P01 and P05—with a combined amount of $34,000.

Use one header row and one record per row. Keep amounts as numbers rather than text such as USD 12,000. Microsoft recommends avoiding mixed data types within a column because they affect which filter commands appear. See its data-type guidance.

Filter rows with the dropdown controls

These menu steps use Excel for Windows:

1. Select A1:E6, then choose Data > Filter.
2. Open the Region header dropdown. Uncheck (Select All), select East, and choose OK.
3. Open Status, select only Approved, and choose OK.
4. Open Amount_USD, choose Number Filters > Greater Than Or Equal To, enter 10000, and choose OK.

You should now see P01 and P05. Filters on different columns are additive: each additional filter narrows the current result. Selecting several values within one column, such as East and West, allows either selected value. Microsoft documents the dropdown controls and additive filtering.

To reset one column, open its filter icon and choose Clear Filter from “Column Name”. If an expected record is missing, check the other columns for active filters before changing the source data.

Use the FILTER function for a reusable result

The formula approach returns matching records in a separate range rather than hiding source rows. Microsoft lists FILTER for Excel for Microsoft 365, Excel 2024 and Excel 2021, including their Mac versions. See FILTER availability and syntax.

Treat this as an alternative to the dropdown method: start with an unfiltered copy of the sample in A1:E6 so hidden worksheet rows do not obscure the formula output. Copy its headers to G1:K1 and enter this formula in G2:

=FILTER(A2:E6,(B2:B6="East")*(C2:C6="Approved")*(D2:D6>=10000),"No matching rows")

The arguments are:

• A2:E6: the records to return, excluding the headers.
• The three tests multiplied together: all conditions must be true—an AND rule.
• "No matching rows": the message to return when nothing qualifies.

Leave room below and to the right of G2. The result “spills,” meaning Excel fills neighboring cells with the returned records—in this sample, G2:K3. Microsoft documents both spill behavior and multiplication for AND conditions; addition can combine OR conditions. FILTER function reference.

If you see #SPILL!, check for cells blocking the output range. Put the formula outside any Excel table; spilled formulas are not supported inside tables. Microsoft’s spill guidance explains these restrictions.

This example uses a fixed range. If you add records below row 6, extend every range in the formula. For a growing dataset, structured references to an Excel source table let the source ranges resize automatically.

Create a separate publication file

Do not rely on hidden rows or columns to keep information private. Build a new workbook containing only the approved records and fields.

For the dropdown-filter method in Excel for Windows:

1. Select the filtered range, including its headers.
2. Choose Home > Find & Select > Go To Special.
3. Select Visible cells only > OK, then copy.
4. In a new workbook, select A1 and paste using Home > Paste > Values.

Microsoft’s visible-cells copying instructions distinguish this from ordinary copying. In Excel for the web, copying a filtered ordinary range includes hidden cells; Microsoft recommends a filtered Excel table or using the desktop application.

For the formula method, copy the headers and actual returned records—G1:K3 in this sample—then paste them as values into a new workbook. Do not include the “No matching rows” message as a data record. Paste Values retains formula results rather than the formulas themselves, but does not retain formatting. Reapply any necessary date or number formats in the release file. Microsoft’s paste options describe the distinction.

Before sharing, check the release file:

• It contains two records, P01 and P05, totaling $34,000.
• Its columns contain only information suitable for public release.
• Dates, identifiers and units remain clear after export.
• Accompanying documentation states the source, extraction date and selection rule.

Choose CSV or XLSX for the release file, then reopen the saved file and check its contents. As of October 2026, TablePage accepts CSV, TSV, XLSX and XLS and creates a public, filterable dataset page. Upload only the reviewed release file—not the working workbook—and compare the published records with your expected result.