Formulas & functions
How a function works, with worked examples you can paste.
- Excel Named Range vs Table: How to Choose the Right ToolAn Excel named range gives a cell or formula a memorable name; an Excel table organizes related records into a structured, expandable…
- Do Excel Merged Cells Need to Be the Same Size to Sort?Yes. When you sort a range in Excel, any merged cells included in that range must have the same dimensions; otherwise, Excel…
- Excel Keep Duplicates: Remove Unique RowsTo keep every row whose value appears more than once, add a helper formula such as =COUNTIF($A$2:$A$8,A2)>1, fill it down, and filter…
- Excel Insert Row and Copy Formulas From Above EasilyTo insert a row and copy formulas from above in Excel for Microsoft 365 on Windows, right-click the row number where the…
- Excel Insert a New Row and Keep FormulasTo insert a row in Excel and keep formulas, select the row number where the new row should go, then choose Home…
- Excel Goal Seek Formula Alternatives That WorkExcel does not have a worksheet function called GOALSEEK; Goal Seek is a What-If Analysis command. The formula alternative is to rearrange…
- Excel Freeze Panes: Keep Top Row and Left Column VisibleTo freeze the top row and left column together in Excel for Microsoft 365 on Windows, select cell B2, then choose View…
- Excel Formula to Split Cell Data After a Comma: ExamplesTo return everything after the first comma in cell A2 in Microsoft 365, use =TEXTAFTER(A2,","). To remove the space often left after…
- Excel Page Break Formula: What Works and What Doesn’tNo Excel worksheet formula can insert a print page break or tell Excel exactly where a printed page will end. To set…
- Excel Formula to Find and Replace Text in Cells: ExamplesTo replace text inside a cell with an Excel formula, use SUBSTITUTE. If the original text is in A2, this formula changes…
- Excel Flash Fill: Fill a Column Without a FormulaExcel Flash Fill is not a formula: it recognizes a pattern in examples you type and fills the remaining cells with fixed…
- Excel Find and Replace: Values, Formulas, and OptionsTo find and replace values in Excel, press Ctrl+H on Windows, enter the text or value under Find what and its replacement…
- Excel Find and Replace Within a Formula: Steps and TipsYes. In Excel for Microsoft 365 on Windows, press Ctrl+H, open Options if needed, set Look in to Formulas, enter the text…
- Excel Find and Replace Paragraph Mark: The Right MethodIn Excel for Microsoft 365 on Windows, press Ctrl+H, click the Find what box, and press Ctrl+J to search for a line…
- Excel Find and Replace Exact Match: What to KnowTo find or replace a cell only when its entire contents match, press Ctrl+H in Excel for Microsoft 365 on Windows, select…
- Excel Filter Remove Shortcut Keys: Clear or Toggle?In Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn AutoFilter arrows on or off; to clear filter criteria but keep…
- Excel Filter by Named Range: What Works and HowYes—but Excel’s standard Filter dropdown does not accept a named range as a direct filter condition. You can use a named range…
- Excel Dependent Dropdown List Using INDIRECT in 365To make an Excel dependent dropdown list using INDIRECT, create a named range for each set of choices, then use =INDIRECT(SUBSTITUTE($A2," ","_"))…
- Excel Delete Table but Keep Data: The Right StepsTo delete an Excel table but keep its data, convert the table to a normal range: click a cell in the table,…
- Excel Data Validation: Allow Unique List Values?No: an Excel data-validation dropdown does not, by itself, require unique choices or stop the same choice being entered in multiple cells.…
- Excel Data Validation List Formula: Examples and FixesFor an Excel drop-down list, select the cells, choose Data > Data Validation, set Allow to List, and enter a source such…
- Excel Data Validation If-Then Lists: How They WorkYes. In Excel for Microsoft 365 on Windows, an if-then list is usually a dependent dropdown: the choice in one cell determines…
- Excel Data Validation Custom Formula Examples That WorkExcel custom data validation lets you accept an entry only when a formula returns TRUE. In Microsoft 365 for Windows, select the…
- Excel Data Table Tutorial: One- and Two-Variable What-IfsTo create an Excel Data Table, place a formula and test values in a small grid, select the entire grid, then choose…
- Excel Data Table Setup: What-If Analysis and TablesTo set up an Excel what-if data table, create a formula that refers to your model, arrange possible input values beside or…
- Excel Copy Data Validation to Other Cells the Right WayTo copy only a cell’s data validation in Excel for Microsoft 365 on Windows, copy the cell, select the destination cells, then…
- Excel Compare Two Sheets for Matching Names: FormulasTo compare names in two worksheets, enter a formula beside the names on the first sheet and check whether each one appears…
- Excel Compare Two Sheets: Methods and FormulasTo compare matching cells on two sheets in the same workbook, enter ='Sheet1'!A1='Sheet2'!A1 in a blank cell; Excel returns TRUE when the…
- Excel Autofill vs Flash Fill: How to Choose the Right ToolExcel AutoFill extends a series or copies cell contents, while Flash Fill recognizes a pattern in your examples and fills in matching…
- Excel A to Z Formula: How to Sort DataWith the values to sort in A2:A20 and an empty output area beginning at C2, enter =SORT(A2:A20) in C2 to return them…