Formulas & functions
How a function works, with worked examples you can paste.
- How to Filter by Strikethrough in Excel (Step by Step)Excel does not have a built-in filter that detects strikethrough formatting. The most reliable workaround is to create a helper column that…
- Filter by Month in Excel: Step-by-StepTo filter Excel dates to one particular month and year, open the date column’s filter menu and choose Date Filters > Between,…
- How to Filter by Name in Excel: A Step-by-Step GuideTo filter by name in Excel, select a cell in your data, choose Data > Filter, then use the dropdown in the…
- How to Filter by Column in ExcelTo filter by a column in Excel, select a cell in your data, choose Data > Filter, then open the arrow in…
- How to Filter Purchases by Date in Excel, Step by StepTo filter purchases by date in Excel, select your purchase list, choose Data > Filter, open the arrow in the purchase-date column,…
- How to Filter and Sort Data in Excel: A Practical GuideTo filter and sort data in Excel, select a cell in your list, choose Data > Filter to show dropdowns, and use…
- How to Filter Blank Cells in Excel and Find Empty RowsTo filter blank cells in Excel, turn on filtering for your data, open the dropdown in the column you want to check,…
- How to Filter A-Z in Excel: Sort a List the Right WayTo put Excel entries in alphabetical order, select a cell in the column and choose Home > Sort & Filter > Sort…
- How to Filter an Excel Sheet by DateTo filter an Excel sheet by date in Microsoft Excel for Microsoft 365 on Windows, select a cell in your data, choose…
- How to Filter a Column in Excel by Dates or Date RangeTo filter dates in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter, open the…
- Extract Words in Excel Using Formulas: Step-by-StepTo return the first word from text in A2, use =IFERROR(TEXTBEFORE(TRIM(A2)," "),TRIM(A2)). For the last word, a particular word, or every word…
- How to Extract Text in Excel With Formulas and ExamplesTo extract text in Excel, use functions such as LEFT, RIGHT, MID, and FIND to return the characters you need from a…
- Extract Text From a Cell in Excel With Simple FormulasTo extract part of a cell’s text in Excel, use a formula that matches what you need: for example, with a hyphen-separated…
- How to Extract One Word From a Cell in Excel With FormulasTo extract a particular word from text in Excel for Microsoft 365, put the text in A2 and the word number in…
- Extract Initials from Names in Excel with FormulasTo extract the first letter of every word in a name, enter a formula in the next column and fill it down.…
- Extract the First Word from a Cell in Excel with a FormulaTo extract the first word from a cell in Excel, enter =LEFT(TRIM(A2),FIND(" ",TRIM(A2)&" ")-1) in an empty cell, replacing A2 with the…
- Extract the First Word in Excel With a FormulaTo extract the first word from text in Excel, put the source text in A2 and enter =LEFT(TRIM(A2),FIND(" ",TRIM(A2)&" ")-1) in another…
- Extract Day from Date in Excel: Formula and StepsTo extract the day of the month from an Excel date, put the date in A2 and enter =DAY(A2) in another cell.…
- Extract Data After a Word in Excel: Formulas and StepsTo extract everything after a word in Excel for Microsoft 365, put the source text in A2 and enter =TRIM(TEXTAFTER(A2,"Status")) in another…
- Extract a Word From a Cell in Excel With a FormulaTo return a particular word from a cell, put the text in A2 and the word’s position in B2 (1 for the…
- Export a Filter List in Excel: Steps and OptionsTo export filtered rows in Excel, apply your filters, select the results, copy the visible cells to a new workbook, and save…
- How to Expand Filter Range in ExcelTo expand an Excel filter, include the added rows or columns in the filter’s source range, then apply the filter again. For…
- How to Enable Sort and Filter in Excel: Step by StepTo enable sorting and filtering in Excel for Microsoft 365 on Windows, click a cell in your data range, then select Data…
- How to Enable Filter in Excel: A Step-by-Step GuideTo enable filters in Excel for Microsoft 365 on Windows, click a cell in your data range, then select Data > Filter.…
- How to Edit Filter Options in Excel for Better ResultsTo edit filter options in Excel, select a cell in your data, choose Data > Filter, then open the arrow in a…
- How to Edit a Filter in Excel: Change Criteria and RangesTo edit a filter in Excel, open the drop-down arrow in a filtered column and change its selected values or filter conditions,…
- Edit a Custom Sort List in ExcelTo edit a custom sort list in Excel for Microsoft 365 on Windows, open File > Options > Advanced, scroll to General,…
- EDATE in Excel: Move Dates Forward by One Month EasilyTo move a date forward one calendar month in Excel, put the original date in A2 and enter =EDATE(A2,1) in another cell.…
- How to Duplicate an Excel Page With Formulas IntactTo duplicate an Excel worksheet with its formulas, right-click the sheet tab, choose Move or Copy, select Create a copy, and click…
- How to Drag a Number Sequence in Excel Without GapsTo drag a number sequence in Excel, enter the first two numbers in adjacent cells, select both cells, then drag the small…