Formulas & functions
How a function works, with worked examples you can paste.
- Excel Fill Shortcut: Fill Down, Right, and Series in CellsIn Excel for Microsoft 365 on Windows, select the cells to fill, including the source cell at the top, then press Ctrl+D…
- Excel Filter Shortcut: How to Add or Remove FiltersIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to add filter drop-downs to the current data range; press it again to…
- Excel Filter Shortcut: Apply, Remove, and Use AutoFilterIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to apply AutoFilter to a data range—or press the same shortcut again to…
- Excel Shortcut for Clearing a Filter in a WorksheetIn Excel for Microsoft 365 on Windows, press Alt, then A, then C to clear the active filter criteria. The rows reappear…
- Excel Filter Shortcut: How to Filter Data Quickly in ExcelIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn filters on or off for a selected data range. Excel adds…
- Excel Filter by Cell Value: Shortcut, Steps, and TipsIn Excel for Microsoft 365 on Windows, there is no single dedicated shortcut that immediately filters a list to the value in…
- Excel Sheet Number Sequence: How to Create OneTo create a number sequence in an Excel worksheet, put =SEQUENCE(10) in a blank cell with room below it; in Microsoft 365,…
- Excel Sheet Comparison Formula: Find DifferencesTo compare the same cell on two Excel sheets, enter =IF(Sheet1!A1=Sheet2!A1,"Match","Different") on a third sheet, then fill the formula across or down.…
- Excel Sheet Filter Shortcut: Turn Filters On and OffIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+L to turn sheet filters on or off. With the active cell inside a…
- Excel Sheet Formula List: Essential Functions and ExamplesAn Excel sheet formula list is a reference to formulas and functions you can use to calculate, summarize, look up, and transform…
- Excel Shared Workbook: Filter Just for Yourself SafelyYes. In Excel for Microsoft 365, use a Sheet View before filtering: open the View tab, choose Sheet View > New, then…
- Excel Sequence Month Dates: Formula ExamplesTo create a sequence of monthly dates in Excel for Microsoft 365, enter a starting date in A1, then use =EDATE(A1,SEQUENCE(12,1,0,1)) in…
- Excel SEQUENCE Function for Dates: Examples and TipsIn Excel for Microsoft 365, use =SEQUENCE(7,1,DATE(2026,4,1),1) to generate seven consecutive date values starting April 1, 2026. Format the spilled results as…
- Excel SEQUENCE Function Examples for Dates and NumbersExcel’s SEQUENCE function creates a spill range of consecutive numbers, dates, or other values from one formula. For example, enter =SEQUENCE(5) in…
- Excel Rule for Dates Before Today: Formula and SetupTo highlight dates before today in Excel for Microsoft 365 on Windows, select the date cells and create a conditional-formatting rule with…
- Excel Round Up to Whole Number: Formulas and ExamplesTo round a value in Excel up to a whole number, use ROUNDUP with zero decimal places. If the number is in…
- Excel: Round a Percentage to a Whole Number in CellsIf A2 contains a percentage such as 12.5%, use =ROUND(A2*100,0)/100 to round it to 13% as a numeric value; format the result…
- Excel Rank Using COUNTIFS: Formula, Ties, and GroupsTo rank numbers in Excel with COUNTIFS, count the values greater than the current value and add 1. With scores in B2:B10,…
- Excel Rank by Number: Formulas and Tie HandlingTo rank numbers in Excel, use RANK.EQ. With the value to rank in B2 and comparison values in B2:B20, enter =RANK.EQ(B2,$B$2:$B$20,0) in…
- Excel Proper Case for Names: Formula and LimitsTo put names in proper case in Excel, use the PROPER function: with the original name in A2, enter =PROPER(A2) in another…
- Excel Power Query Table Filter: How to Apply and RefreshTo filter an Excel table with Power Query in Microsoft 365 for Windows, select a cell in the table, choose Data >…
- Excel OR in SUMIFS: Add Multiple Criteria CorrectlyExcel’s SUMIFS function does not have a dedicated OR operator between criteria. To total rows matching one condition or another, add separate…
- Excel Online Filter: See Just Your Rows in a Sheet ViewYes. In Excel for the web, use a Sheet View to filter a shared worksheet so you see only the rows you…
- Excel OFFSET Formula Explained: Syntax and ExamplesExcel’s OFFSET function returns a reference to a cell or range located a specified number of rows and columns from a starting…
- Excel Number Range Formula: Calculate, Count, and ListTo calculate the numerical range—the difference between the largest and smallest values—in cells A2:A10, use =MAX(A2:A10)-MIN(A2:A10). If by “number range” you mean…
- Excel Number of Days Between Dates Today: FormulasTo find how many days have passed between a date in Excel and today, enter =TODAY()-A2, assuming the earlier date is in…
- Excel Number of Days Before Today: Formula and ExamplesTo find how many days have passed since a date in Excel, subtract the date from TODAY(). If the date is in…
- Excel Number Format to Round Values to Millions EasilyTo display Excel values in millions without changing the stored numbers, apply the custom number format #,##0.0,,"M". The two commas scale the…
- Excel Next Number in Sequence: Formulas and TipsWith the first number in A2, enter =A2+1 in A3 to calculate the next number in a sequence that increases by one.…
- Excel Name List Template: Create, Sort, and ShareAn Excel name list template is a worksheet with clear column headings, one person per row, and filters for finding or sorting…