The most useful Excel formula shortcuts on Windows are Alt+= to insert AutoSum, F2 to edit a cell, F4 to cycle a reference through relative and absolute forms, and Ctrl+D to fill a formula down. On Mac, common equivalents include Option+Command+= for AutoSum, Control+U to edit a cell, and Command+D to fill down.
Essential Excel formula shortcuts
Shortcuts save time by handling common formula tasks without opening a menu. These are for Excel for Microsoft 365 on Windows; the Mac equivalents below apply to Excel for Mac, though function keys can depend on your keyboard settings.
- Alt+= — AutoSum: Inserts a SUM formula and suggests a nearby range. Check the highlighted cells before accepting it.
- F2 — edit the active cell: Moves the insertion point into the cell’s contents so you can change a formula without replacing it.
- F4 — cycle reference types: While editing a formula, changes the selected reference among relative, absolute, and mixed forms. For example, A1 can become $A$1, A$1, or $A1.
- Ctrl+D — Fill Down: Copies the top cell of a selected range into the cells below, adjusting relative references as it fills.
- Ctrl+R — Fill Right: Copies the leftmost cell across the selected cells to its right.
- Ctrl+` — Show Formulas: Toggles between displaying formulas in cells and displaying their calculated results. The grave accent is usually the key beside 1.
- Ctrl+Shift+Enter — enter a legacy array formula: Used for older array formulas in versions and cases that require the traditional array-entry method. Most ordinary formulas and modern dynamic-array formulas use Enter.
- Shift+F3 — Insert Function: Opens the function selection dialog, which can help when you know what you want to calculate but need help with a function’s arguments.
These shortcuts have different jobs: AutoSum creates a formula, Fill Down copies one, and F2 edits one. Knowing which task you need prevents a common mistake—using a copying shortcut when you meant to change a formula’s logic.
Entering a formula with AutoSum
AutoSum is the fastest shortcut for a basic total. Select the blank cell below a column of numbers, press Alt+=, inspect the proposed range, and press Enter to accept it. Excel inserts a SUM formula rather than a fixed number, so the total recalculates if the included values change.
For example, with values 12, 18, 20, 25, and 30 in B2:B6 and the total cell in B7, press Alt+= in B7. Excel will commonly propose =SUM(B2:B6), which returns 105. This result assumes those five cells contain the stated numbers. If Excel highlights the wrong cells—for instance, because a blank row separates the data—select the correct range before pressing Enter.
AutoSum can also work across a row or with more than one selected total cell, but its range detection is a convenience, not a guarantee. Review the colored range outline and the formula shown in the cell or formula bar. A total that looks plausible can still omit a row or include an unrelated number.
Editing formulas and changing references
Press F2 with a formula cell selected to edit its contents. You can move the cursor through the formula, correct a function name, or select a reference and replace it. Press Enter to commit the change, or Esc to cancel the edit. This is often safer than typing directly over a selected cell, which would replace its entire contents.
Reference type matters when copying formulas. A relative reference such as A1 shifts when a formula is copied; an absolute reference such as $A$1 stays fixed. Mixed references lock only the row or column. While editing a formula, place the cursor on a reference (or select it in the formula bar) and press F4 to cycle through the forms. On a Mac, Command+T is the usual shortcut for cycling a reference while editing.
Suppose a worksheet calculates line totals by multiplying a quantity by a unit price. With quantities in B2:B10 and prices in C2:C10, a formula in D2 could be =B2*C2. If B2 contains 3 and C2 contains 8, the result is 24. Filling the formula down should change the references to B3 and C3, then B4 and C4, and so on. If the formula also uses a tax rate stored in F1, lock that reference as $F$1 before copying so it does not shift to F2, F3, and later rows.
Copying a formula without dragging
To fill a formula through several adjacent rows, select the formula cell and the destination cells, then press Ctrl+D. Excel takes the contents of the top cell in the selection and fills downward. For a horizontal range, select the leftmost formula cell and the cells to its right, then press Ctrl+R. These shortcuts copy cell contents and formatting, not just the formula text, so check whether the resulting formatting is appropriate.
Filling is especially useful for repeated calculations, such as a commission or a row-by-row difference. It also follows reference rules: relative references adjust, while dollar-sign references remain locked. After filling, click a cell partway down the range and inspect the formula bar. This quick check can reveal an incorrect starting selection or a reference that was not anchored as intended.
On Mac, Command+D and Command+R are common equivalents for Fill Down and Fill Right. If a shortcut triggers a macOS function instead, check the keyboard’s function-key setting and Excel’s shortcut help for your version.
Viewing, checking, and troubleshooting formulas
When a worksheet shows an unexpected number, toggle Ctrl+` to display formulas instead of results. This makes it easier to compare neighboring formulas and spot a missing row, an accidental constant, or an inconsistent reference. Press the same shortcut again to return to calculated values. On many Mac keyboards, Control+` provides the same view toggle; the physical key layout can affect how the grave accent is entered.
If a formula appears as text rather than calculating, check whether the cell is formatted as Text or whether an apostrophe was typed before the equals sign. Change the cell format to General, then re-enter the formula; changing the format alone may not convert a formula already stored as text. If the displayed answer does not update after an input changes, check whether calculation is set to Manual under Formulas > Calculation Options and, if appropriate, switch it to Automatic.
Also distinguish a formula error from an incorrect result. Errors such as #NAME? or #VALUE! usually point to a misspelled function, invalid text or number input, or a reference problem. A total that is too low may simply exclude a row. Show Formulas, inspect the range, and compare the formula with a neighboring cell before rewriting it.
Keyboard shortcuts versus typing formulas
Shortcuts do not replace formula knowledge. Alt+= is convenient for adding a SUM, but it does not choose the right calculation for every task. F2 helps edit a formula but cannot decide whether a reference should be absolute. Fill Down copies a pattern, so a flawed formula can be propagated just as quickly as a correct one.
Use a shortcut when the action is repetitive and the intended result is clear. Type or revise the formula directly when you need a different function, a nonadjacent range, or a special reference. For a more guided start, Shift+F3 opens Insert Function. Excel also offers function suggestions as you type an equals sign and part of a function name; these can help identify available functions and argument prompts without memorizing every name.
Some online lists mix Excel shortcuts with commands from other spreadsheet apps or rely on old versions of Excel. Check the key and its effect in your own Excel edition, especially for array formulas and Mac function keys. In Microsoft 365, dynamic-array formulas generally need Enter; Ctrl+Shift+Enter is mainly relevant to legacy array entry, not a universal way to submit formulas.
Windows and Mac differences
Windows and Mac versions share many formula concepts but do not use identical keys. A practical starting reference is:
- AutoSum: Windows Alt+=; Mac Option+Command+=.
- Edit the active cell: Windows F2; Mac Control+U.
- Fill Down: Windows Ctrl+D; Mac Command+D.
- Fill Right: Windows Ctrl+R; Mac Command+R.
- Cycle reference types: Windows F4; Mac Command+T while editing a reference.
On some laptops, F2 or F4 may require holding Fn, or changing the keyboard’s function-key behavior. Mac shortcuts can also conflict with macOS or differ with a non-US keyboard layout. If a listed key does not work, use Excel’s Help search for the command name, such as “Fill Down,” and check the shortcuts for the installed version rather than assuming a Windows combination will transfer unchanged.
Frequently Asked Questions
What is the shortcut for inserting a formula in Excel?
There is no single shortcut that inserts every kind of formula. Press Alt+= on Windows (Option+Command+= on Mac) for a suggested SUM formula, or type an equals sign and the formula you need.
How do I edit a formula without replacing the cell?
Select the cell and press F2 on Windows or Control+U on Mac, then edit the formula and press Enter. Press Esc to cancel the edit.
How do I make a cell reference stay fixed when copying a formula?
While editing the formula, select the reference and press F4 on Windows or Command+T on Mac to cycle through relative, absolute, and mixed references. Dollar signs mark the locked row or column.
What shortcut copies a formula to the cells below?
Select the formula cell and the destination cells, then press Ctrl+D on Windows or Command+D on Mac. Check the adjusted references in the filled cells.
Why does Ctrl+Shift+Enter not work for my formula?
Most standard formulas and dynamic-array formulas in current Microsoft 365 Excel are entered with Enter. Ctrl+Shift+Enter is for legacy array formulas that require traditional array entry, not for every formula.
How can I see the formulas instead of their results?
Press Ctrl+` on Windows to toggle Show Formulas. On Mac, Control+` commonly performs the same action, although the key combination can depend on the keyboard layout.
Related
- Excel DOS Keyboard Shortcuts: What Actually Works
- Excel Direct Access vs Link: What’s the Difference?
- Excel Desktop Keyboard Shortcuts: A Practical Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Filter Returns Numbers as Dates? Here’s WhyExcel’s filter feature does not turn numbers into dates; it either shows existing cell values or returns values…
- Excel IFS for Blank Cells: Formulas and Common FixesTo make Excel’s IFS function return a result when a cell is blank, test for a blank first:…
- Extract Middle Text in Excel: Formulas and ExamplesTo extract text from the middle of a cell in Excel, use MID: with the source text in…
- How to Calculate a Unique Count in Excel with FormulasTo count distinct, nonblank values in Excel for Microsoft 365, use =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0), replacing A2:A100 with your data range.…
- Excel SUM Formula That Changes With FiltersUse =SUBTOTAL(109,B2:B100) to sum only the currently visible values in B2:B100. When you filter the rows, Excel recalculates…
- IsNumber Function in Java: Methods to Check Numeric TextJava does not have a built-in, general-purpose isNumber() function. To check numeric text, choose a method that matches…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.