Formulas & functions
How a function works, with worked examples you can paste.
- How to Subtract in Microsoft Excel: Formulas and TipsTo subtract in Microsoft Excel, enter a formula using the minus sign: with the starting value in A2 and the amount to…
- How to Subtract in Excel Using the SUM FunctionTo subtract with Excel’s SUM function, add the amount you are starting with and include each amount to deduct as a negative…
- How to Subtract in Excel Using a Formula Step by StepTo subtract in Excel, enter a formula with a minus sign in the cell where you want the answer. With the starting…
- How to Split in Excel Using Formulas: Practical ExamplesTo split text in Excel with a formula, use =TEXTSPLIT(A2,"|") when the full text is in A2 and each part is separated…
- Split Cells in Excel With Formulas: A Step-by-Step GuideTo split text from one Excel cell into separate columns, enter =TEXTSPLIT(A2," ") in B2 when A2 contains text separated by spaces.…
- How to Sort Rows in Excel Without Mixing Data SafelyTo sort rows in Excel without mixing data, select a cell in the complete dataset, open Data > Sort, choose the column…
- How to Sort in Microsoft Excel: A Clear, Practical GuideTo sort in Microsoft Excel for Microsoft 365 on Windows, click a cell in your data, then choose Data > Sort A…
- How to Sort Names in Excel AlphabeticallyTo sort names alphabetically in Excel for Microsoft 365 on Windows, select the name list and any related columns, then choose Data…
- How to Sort Numbers in Excel from Low to High QuicklyTo sort numbers in Excel from low to high, click a cell in the number column, open the Data tab, and choose…
- How to Sort Data in Excel Without Moving the HeaderTo sort Excel data without moving its header, select a cell in the list, choose Data > Sort, and make sure My…
- Sort in Excel Smallest to Largest: Step-by-Step GuideTo sort values in Excel from smallest to largest, click a cell in the number column, then select Data > Sort Smallest…
- How to Sort in Excel Without Mixing Up Your DataTo sort in Excel without mixing up your data, select the entire table or a cell inside a complete data range, then…
- How to Sort in Excel by Number Order Step by Step GuideTo sort numbers in Excel, select a cell in the number column, then choose Data > Sort Smallest to Largest for ascending…
- How to Sort in Alphabetical Order in ExcelTo sort a list alphabetically in Excel for Microsoft 365 on Windows, click a cell in the text column, go to Data,…
- How to Sort Numbers in Excel in Numerical OrderTo sort numbers in Excel, click a cell in the number column, then choose Data > Sort Smallest to Largest for ascending…
- How to Sort Dates in Excel PivotTables (Oldest to Newest)To sort dates in an Excel PivotTable, click a date item in the PivotTable, right-click it, and choose Sort > Sort Oldest…
- How to Sort Dates in Excel Without Splitting RowsTo sort dates in Excel, select a cell in your data, open Data > Sort, choose the date column, and select Oldest…
- Sort Dates in Excel by Month and DayTo sort Excel dates by month and day while ignoring the year, add a helper column that converts each date to the…
- Sort Dates in Excel in Ascending Order the Right WayTo sort dates in Excel from oldest to newest, select a date cell, then choose Data > Sort Oldest to Newest. If…
- Select Multiple Names in Excel Filter: A Practical GuideTo show rows for several names in an Excel filter, open the filter arrow in the names column, clear the current selections…
- How to Select a Filter in Excel Using the KeyboardTo select a filter in Excel with the keyboard, turn on AutoFilter with Ctrl+Shift+L, move to the column header, press Alt+Down Arrow,…
- Search Multiple Values in Excel Filter: A Step-by-Step GuideTo filter a column for several values in Excel for Microsoft 365 on Windows, open its filter dropdown, search for one value…
- Round in Excel to a Whole Number: Formula and ExamplesTo round a number to the nearest whole number in Excel, use ROUND with 0 as the number of digits. For example,…
- How to Round in Microsoft Excel: Formulas and TipsTo round a number in Excel, use ROUND in a formula: if the value is in A2 and you want two decimal…
- How to Round Down in Excel: Formulas, Steps, and ExamplesTo round a value down in Excel, use the ROUNDDOWN function. If A2 contains 12.987 and you want two decimal places, enter…
- Reverse Names in Excel With a Comma: Formula and StepsTo turn names stored as Last, First into First Last, enter this formula in B2 when the original name is in A2:…
- Replace in Excel With a Formula: REPLACE and SUBSTITUTETo replace matching text in Excel, use SUBSTITUTE; to replace characters at a known position, use REPLACE. With the original text in…
- Remove Formula in Excel: Shortcut Key and StepsTo remove a formula but keep its current result in Excel for Microsoft 365 on Windows, select the formula cells, press Ctrl+C,…
- Remove Formula in Excel but Keep Data as Values SafelyTo remove formulas in Excel but keep the data they currently display, select the formula cells, copy them, then paste values over…
- Rank Numbers in Excel: Formulas for Ties and OrderWith scores in A2:A6 and the first rank in B2, enter =RANK.EQ(A2,$A$2:$A$6,0) to rank the largest number first, then fill the formula…