Formulas & functions
How a function works, with worked examples you can paste.
- Copy Formulas in Excel Without Changing ReferencesTo copy a formula without letting Excel adjust its cell references, lock the references with dollar signs before copying. For example, change…
- How to Copy Formulas in Excel to Other Rows: Step by StepTo copy a formula into rows below it in Excel, select the cell that contains the formula and drag its fill handle…
- How to Copy Formulas in Excel to a New Workbook SafelyTo copy formulas into a new Excel workbook, open both workbooks, copy the formula cells in the source, then paste them into…
- How to Copy Formulas in Excel on a MacBook Without ErrorsTo copy a formula in Excel on a MacBook, select the cell containing it, press Command+C, select the destination cell or range,…
- Copy Formulas in Excel to a New Sheet Without ErrorsTo copy formulas to a new sheet in Excel, select the formula cells, press Ctrl+C, open the destination sheet, select the first…
- Copy Formulas in Excel Exactly: Keep References FixedTo copy a formula in Excel, select its cell, press Ctrl+C, select the destination, and press Ctrl+V. Excel normally adjusts relative cell…
- Copy Formulas in Excel Across Rows: A Simple GuideTo copy a formula horizontally, select its cell and drag the small fill handle at the lower-right corner across the destination cells;…
- How to Copy Formulas in Excel by Dragging the Fill HandleTo copy a formula in Excel by dragging, select the cell with the formula, point to the small square at its lower-right…
- How to Set an Absolute Cell Reference in Excel FormulasTo set an absolute cell reference in Excel, add a dollar sign before both the column letter and row number, as in…
- How to Put an Absolute Cell Reference in Excel FormulasTo make a cell reference absolute in Excel, add a dollar sign before both its column letter and row number, such as…
- Excel Autofill Keyboard Shortcuts for Fill Down and RightTo autofill a selected range in Excel, include the source cell and the cells you want to fill, then press Ctrl+D to…
- Excel Autofill Based on Cell Input: Formulas That WorkTo autofill related information when someone enters a value in Excel, put a lookup formula in the result cell and fill it…
- Remove Spaces in Excel: The Shortcut and Right MethodTo remove every ordinary space from selected cells in Excel for Microsoft 365 on Windows, select the cells, press Ctrl+H, enter one…
- Extract Text in an Excel Cell: Formulas and Steps That WorkTo extract part of a cell’s text, use a formula such as TEXTBEFORE for text before a separator, TEXTAFTER for text after…
- Remove Spaces in One Excel Cell: Formula and StepsTo remove every ordinary space from one Excel cell, enter =SUBSTITUTE(A1," ","") in a nearby blank cell, replacing A1 with the cell…
- Insert a Horizontal Page Break in Excel the Right WayTo insert a horizontal page break in Excel for Microsoft 365 on Windows, select the row directly below where you want the…
- Calculate Age in Weeks in Excel with a Simple FormulaTo calculate completed age in weeks in Excel, put a birth date in A2 and enter =INT((TODAY()-A2)/7) in another cell. Excel subtracts…
- Calculate Age in Excel Using Date of Birth with DATEDIFTo calculate age in Excel from a date of birth, put the birth date in A2 and enter =DATEDIF(A2,TODAY(),"Y") in another cell.…
- Calculate Age in Excel in Years with Simple FormulasTo calculate completed age in years in Excel, put each birth date in column A and, with the birth date in A2,…
- Calculate Age in Months in Excel: Formulas and TipsTo calculate completed age in months in Excel, put a birth date in A2 and enter =DATEDIF(A2,TODAY(),"m") in another cell. Excel returns…
- Calculate Age in Excel from DOB with a Simple FormulaIf the date of birth (DOB) is in A2, enter =DATEDIF(A2,TODAY(),"Y") in another cell to return age in completed years as of…
- How to Calculate Age in Excel for a Future Date with DATEDIFIf the date of birth is in A2 and the future date you want to measure age on is in B2, enter…
- Calculate Age in Excel From DD/MM/YYYY With a FormulaTo calculate someone’s age in Excel from a DD/MM/YYYY birth date, enter the birth date as a real Excel date, then use…
- Calculate Age in Excel With a Birthday Date FormulaTo calculate someone’s age in completed years in Excel, enter their birthday as a real date in A2, then use =DATEDIF(A2,TODAY(),"Y"). The…
- Conditional Formatting in Excel: If-Then Color RulesYes. In Excel, select the cells you want to format, then choose Home > Conditional Formatting and create a rule that applies…
- Excel If Blank, Delete Row: Safe Methods That WorkExcel cannot delete a worksheet row with an IF formula alone: formulas return values, they do not remove rows. To delete rows…
- How to Filter Rows by Color in Excel: A Practical GuideTo filter rows by color in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter,…
- Excel Color Filter: How to Filter Rows by Cell ColorTo filter rows by color in Excel for Microsoft 365 on Windows, select a cell in your data, choose Data > Filter,…
- Filter Cells by Color in Excel: Steps and TipsTo filter cells by color in Excel for Microsoft 365 on Windows, select your data, choose Data > Filter, open the arrow…
- How to Filter by Color in ExcelTo filter by color in Excel for Microsoft 365 on Windows, turn on filters for your data, open the filter arrow in…