Formulas & functions
How a function works, with worked examples you can paste.
- How to Filter Subtotals in Excel by Group or TotalTo show subtotal rows without their detail rows, use the outline buttons Excel creates with Data > Subtotal, then click outline level…
- How to Filter Specific Dates in ExcelTo filter specific dates in Excel, select a cell in your data, choose Data > Filter, open the arrow in the date…
- How to Filter Out Weekend Dates in Excel: Step-by-StepTo filter weekend dates out of an Excel list, add a helper column and enter =WEEKDAY(A2,2)>5 beside the first date, where the…
- Filter Strikethrough in Excel with a Helper ColumnTo filter rows by strikethrough in Excel, add a helper column that checks the formatting of the cell beside it, then use…
- How to Filter Dates in Excel by Month, Year, or RangeTo filter dates in Excel, select a cell in your data, choose Data > Filter, open the arrow in the date column,…
- How to Filter Dates in Excel by Month, Year, or RangeTo filter dates in Excel, select a cell in your data, choose Data > Filter, open the arrow in the date column,…
- Filter Only Bold Text in Excel with a Helper ColumnTo filter for bold cells in Excel, add a helper column that labels each cell as Bold or Not bold, then use…
- How to Filter Out Bold Text in ExcelTo filter rows according to whether a cell is bold, add a helper column that labels each row “Bold” or “Not bold,”…
- How to Filter Not In Excel: Exclude Specific ValuesTo filter out one value in Excel, select a cell in your data, choose Data > Filter, open the column’s dropdown, and…
- How to Filter Odd Numbers in Excel with a FormulaTo filter odd numbers in Excel, add a helper column with =IFERROR(AND(ISNUMBER(A2),MOD(A2,2)=1),FALSE), fill it down, then use Data > Filter to show…
- How to Filter Multiple Values in Excel: A Practical GuideTo filter for several values in one Excel column, open its filter dropdown, clear (Select All), check each value you want to…
- How to Filter Negative Values in Excel: Filters & FormulasTo show only negative numbers in Excel, select your data range, choose Data > Filter, open the dropdown on the number column,…
- Filter Multiple Numbers in Excel: Exact and Range OptionsTo filter several exact numbers in Excel, open the column’s filter menu and select the numbers you want to keep. For a…
- Excel Filter Just for Me: Create a Personal Sheet ViewTo filter a shared Excel worksheet just for yourself, create a Sheet View first, then apply the filter while that view is…
- How to Filter by Month in Excel Using Dates or TextTo filter month-wise in Excel, select a cell in your data, choose Data > Filter, open the date column’s filter arrow, and…
- How to Filter Multiple Dates in Excel by Range or ListTo filter multiple dates in Excel, turn on the column filters, open the arrow on your date column, and either select the…
- How to Filter in Excel to Find the Exact Data You NeedTo filter in Excel, click a cell in your data, then choose Data > Filter; use the arrow in a column heading…
- How to Filter Information in Excel: A Practical GuideTo filter information in Excel, select a cell in your data, choose Data > Filter, then use the arrow in a column…
- How to Filter in Microsoft Excel: A Practical GuideTo filter in Microsoft Excel, select a cell in your data, then choose Data > Filter or press Ctrl+Shift+L on Windows. Use…
- Filter in Excel With Blank Rows: Keep Records TogetherTo filter data that contains blank rows, select the entire data range—including the blank rows—and choose Data > Filter in Excel for…
- How to Filter in Excel With Multiple CriteriaTo filter data by more than one condition in Excel, turn on filters for the full data range, then choose a condition…
- How to Filter in Excel Only for Yourself with Sheet ViewsTo filter a shared Excel workbook without changing what coworkers see, open the View tab, choose Sheet View > New, and then…
- How to Filter in Excel Using Keyboard Shortcuts and MenusTo filter a list in Excel for Microsoft 365 on Windows, select a cell in the data, press Ctrl+Shift+L to show filter…
- How to Filter Multiple Items in Excel: A Clear GuideTo filter for several items in Excel, open the filter arrow in the column heading, clear Select All, check each item you…
- How to Filter in Excel Without a Mouse: Keyboard GuideTo filter a list in Excel for Microsoft 365 on Windows without a mouse, select a cell in the data and press…
- Filter in Excel by Cell Color: A Step-by-Step GuideTo show only rows with a particular fill color in Excel for Microsoft 365 on Windows, select a cell in your data,…
- How to Filter Highlighted Rows in Excel by Cell ColorTo filter highlighted rows in Excel, turn on AutoFilter, open the dropdown for a column whose cells have the highlight color, and…
- How to Filter in Excel and Delete the Rows You Don’t NeedTo keep certain records and delete the rest in Excel, filter for the records you want to remove, select only the visible…
- How to Filter Highest to Lowest in Excel: A Quick GuideTo show the largest values first in Excel, open the filter arrow on the column you want to rank and choose Sort…
- How to Filter Highlighted Cells in Excel by Cell ColorTo filter highlighted cells in Excel, turn on filtering, open the drop-down arrow in the column that contains the colored cells, choose…