Formulas & functions
How a function works, with worked examples you can paste.
- Flash Fill to the Right in Excel: What Actually WorksYes—Excel Flash Fill can put transformed results in a column to the right of your source data: enter a couple of examples…
- Excel XLOOKUP and Power Query: How They Work TogetherExcel XLOOKUP and Power Query work together, but they do different jobs: Power Query imports, cleans, and combines data, while XLOOKUP retrieves…
- Excel Scenario Manager: How to Compare What-If CasesExcel Scenario Manager is a What-If Analysis tool that saves different sets of input values and shows how each set affects formula…
- Excel VLOOKUP With a Named Range: Formula and SetupTo use a named range with VLOOKUP in Excel for Microsoft 365 on Windows, give the lookup table a name, then use…
- Excel Named Ranges in Formulas: How to Use ThemYes. In Excel for Microsoft 365, type a defined name into a formula anywhere you would otherwise use its cell reference or…
- Excel Text to Columns Formula: Split Text in CellsExcel does not have a worksheet function called Text to Columns: the command is a data-splitting tool, not a formula. If the…
- Excel Split Text in a Cell: Methods and FormulasYes. In Excel for Microsoft 365 on Windows, use Data > Text to Columns to split a cell’s contents into separate columns,…
- Excel Compare Two Sheets: Formulas and ToolsTo compare corresponding cells on two Excel sheets, enter =IF(Sheet1!A1=Sheet2!A1,"Same","Different") in a comparison cell, then fill the formula across and down. For…
- Excel Split Cells With Regex: Formulas and MethodsYes—Excel for Microsoft 365 can split text using a regular expression by replacing regex-matched separators with a marker and passing that result…
- Excel Split Cell String: Formulas, Tools, and FixesTo split a cell string in Excel for Microsoft 365, enter =TEXTSPLIT(A2," ") in an empty cell to divide the text in…
- Excel Split Cell String by Delimiter: Formulas and ToolsIn Excel for Microsoft 365, split a cell’s text at a delimiter with TEXTSPLIT: if A2 contains red,blue,green, enter =TEXTSPLIT(A2,",") in an…
- Excel Split Cell Function: Formulas, Tools, and TipsExcel does not have one universal “Split Cell” function, but you can separate a cell’s contents with Data > Text to Columns,…
- Excel Split Cell by Line Break: Formulas and Steps ExplainedTo split a cell at each line break in Excel for Microsoft 365 on Windows, enter =TEXTSPLIT(A2,CHAR(10)) in an empty cell, replacing…
- Excel Split Cell by Character: Methods and FormulasTo split a cell at a repeated separator such as a comma, hyphen, or space, select the cells and use Data >…
- Excel Split Cell at Comma: Methods, Formulas, and TipsTo split comma-separated text in Excel, select the cells and choose Data > Text to Columns > Delimited, then select Comma and…
- Excel Split Cell at a Space: Methods and Formulas ExplainedTo split text at a space in Excel for Microsoft 365 on Windows, select the cells and choose Data > Text to…
- Excel Sort by Name Not Responding? Fixes to TryIf Excel’s sort by name appears not to respond, first select a cell in the full data range and choose Data >…
- Excel Slicers: Use Custom Lists to Sort Items?Yes. In Excel for Microsoft 365 on Windows, a slicer can use Excel’s custom lists to order its items: select the slicer,…
- Excel Slicer Custom Sort: Control the Order of ItemsTo custom-sort an Excel slicer, create or use an Excel custom list for the item labels, then open the slicer’s settings and…
- Excel Showing Formulas but Not Calculating? FixesIf Excel shows a formula instead of its answer, turn off Formulas > Show Formulas or press Ctrl+` on Windows. If the…
- Excel Remove Duplicate Data With a FormulaIn Excel for Microsoft 365, use =UNIQUE(A2:A100) to create a separate list containing each value once; the original data remains unchanged. To…
- Excel Question Solver: Formulas, Solver, and Help GuideYes—Excel can help answer many spreadsheet questions, but the right tool depends on what you mean by “solve.” Use a formula to…
- Excel Protected Sheet Won’t Let You Sort? FixesExcel usually blocks sorting on a protected sheet because sorting is not allowed in the sheet’s protection settings, or because the cells…
- Excel Protected Sheet Sort: Settings, Limits, and FixesTo sort a protected Excel worksheet, choose Review > Protect Sheet, allow users to sort, and protect the sheet. There is an…
- Excel Protect Sheet: What to Do If You Forgot the PasswordIf you forgot an Excel worksheet password, Microsoft Excel has no built-in way to reveal or reset it: ask the person who…
- Excel Protect Sheet: Let a Table Expand SafelyIn Excel for Microsoft 365 on Windows, there is no built-in Protect Sheet setting that reliably lets people add rows to an…
- Excel Print Area Formula: Set a Dynamic Print RangeExcel has no worksheet formula that sets a print area: print areas are page settings, not cell calculations. To make one expand…
- Excel Power Query VLOOKUP: Match Tables and RefreshExcel Power Query does not run the VLOOKUP function inside a query; instead, use Merge Queries to match rows in two tables…
- Excel Power Query IF Statements: Examples and RulesIn Excel Power Query, an IF expression uses M language syntax: if condition then value_if_true else value_if_false. Add it as a custom…
- Wedding Budget Spreadsheet for 50 Guests: Costs & FormulasA practical wedding budget spreadsheet for 50 guests should list each cost, its planned amount, the latest expected total, and what has…