Excel Average Keyboard Shortcut and Fastest Methods

How-to basics · Updated November 19, 2026

Excel does not have a single, dedicated keyboard shortcut that inserts an average formula in every situation. In Microsoft Excel for Microsoft 365 on Windows, try Alt, H, U, A in sequence to choose Average from AutoSum; for a dependable, explicit calculation, enter =AVERAGE(B2:B13) and replace the range with your data.

What the Average shortcut does

The AutoSum menu can insert common calculations, including Sum, Average, Count Numbers, Max, and Min. The Windows keytip sequence Alt, H, U, A means press and release each key in turn, rather than holding all four down. It opens the Home tab’s AutoSum options and selects Average in the English-language desktop ribbon. Excel then proposes a range; check that selection before pressing Enter.

Keytips are the letters Excel displays on the ribbon after you press Alt. Their presentation can differ with language, version, or ribbon layout, so follow the letters shown on your screen if that sequence does not match. You can reach the same command with the mouse through Home > Editing > AutoSum ▼ > Average. The name and location of a group can vary slightly with window width or ribbon customization.

This is different from the well-known AutoSum shortcut, Alt+=, which normally inserts a SUM formula. It does not automatically mean Average. Choose Average from the AutoSum dropdown, or write an AVERAGE formula yourself, when the intended calculation is the mean.

How to use AutoSum for an average

AutoSum is convenient when the result belongs beside or below a simple block of numbers. For example, if monthly sales occupy cells B2 through B13, select the cell where you want the mean, choose Average from AutoSum, inspect the suggested range, and confirm it. Excel will generally propose the nearby numeric block, but that guess is not a guarantee that it has selected exactly the cells you intend.

  1. Select the result cell immediately below a vertical list or to the right of a horizontal list, if practical.
  2. Use Alt, H, U, A, or open Home > Editing > AutoSum ▼ and choose Average.
  3. Review the outlined cell range and edit it if needed. You can select the intended cells with the mouse or adjust the reference in the formula bar.
  4. Press Enter to calculate the result.

If you start with the result cell selected, Excel typically writes a formula such as =AVERAGE(B2:B13). If you instead select the data cells first, the exact insertion behavior can depend on the selection and adjacent cells. In either case, check the formula rather than assuming that the application inferred the right boundaries. A blank cell, a heading, or a nearby total can lead to a proposed range that is broader or narrower than intended.

Entering the AVERAGE formula directly

Typing the function is often the clearest method, especially when you want a particular set of cells or want the calculation to remain easy for another person to audit. In the cell for the result, type an equals sign, the function name, and the reference or references inside parentheses. For sales values in B2:B13, use =AVERAGE(B2:B13). Press Enter to calculate.

For a small example, suppose B2:B6 contain 10, 12, 14, 16, and 18. With those values in that range, =AVERAGE(B2:B6) returns 14: their total is 70 and 70 divided by 5 is 14. The cell reference makes the calculation update when the underlying numbers change. You can also select the cells with the mouse while editing the formula instead of typing the reference.

AVERAGE can accept more than one range, separated by commas in standard English-language Excel syntax. For example, if scores are in B2:B5 and D2:D5, =AVERAGE(B2:B5,D2:D5) calculates the mean of the numeric values in both ranges. This is useful when the relevant observations are separated by an unrelated column. Be deliberate about which cells you include: an average across multiple ranges weights each numeric observation equally, not each range equally.

What Excel includes in an average

For a range reference, AVERAGE uses numeric cells and ignores empty cells and text. A zero is a number, however, and it is included in the calculation. That distinction can materially affect a result. If five intended observations are 10, 12, 14, 16, and 18, the average is 14. If a sixth cell contains a numeric zero, the average becomes 70 divided by 6, or about 11.67. A blank cell is not treated as a zero.

Text labels such as Not recorded in a referenced range are ignored by AVERAGE, but an error value in the range can make the formula return an error. Logical values in referenced cells are also not treated like numeric entries by AVERAGE. If a cell looks like a number but is stored as text, it may be ignored, which can make a result unexpectedly high or low. Check the source data and cell formats when a calculation does not reflect what you expect.

  • Blank: ignored by AVERAGE in a referenced range.
  • Zero: included as a numeric observation.
  • Text in a referenced cell: ignored.
  • Error in a referenced cell: can cause the formula to return an error.
  • Number stored as text: may not be counted as a number.

Choosing the right kind of average

In ordinary conversation, average often means the arithmetic mean: add the observations and divide by how many numeric observations there are. Excel’s AVERAGE function calculates that mean. It does not find the middle value in a sorted list, nor does it identify the most frequent value. Those are different statistics and have different Excel functions: MEDIAN returns the middle value, while MODE.SNGL returns the most frequently occurring value when one exists.

The mean can be sensitive to unusually large or small observations. For example, the average of five weekly values can rise sharply if one week contains an exceptional one-time sale. That does not mean Excel has made a mistake; the mean answers a specific question about the total divided by the number of observations. When a typical middle observation is more useful, consider whether the median better fits the purpose.

For values that should contribute different weights, a plain AVERAGE may also answer the wrong question. If each value represents a different number of people, hours, or units, an average of the values gives each row equal weight. A weighted mean requires weights to be incorporated into the calculation. Confirm the definition you need before choosing a function, particularly when a report or policy defines what counts as an average.

Windows, Mac, and Excel for the web

The keytip sequence described above is for the Windows desktop ribbon in Microsoft 365. Excel for Mac has different keyboard conventions and does not use the same Windows Alt-based ribbon sequence. On a Mac, the straightforward cross-version approach is to type =AVERAGE(B2:B13) in the result cell, or use the AutoSum dropdown on the Home ribbon and choose Average. The Mac AutoSum shortcut is not a dedicated Average shortcut; AutoSum is associated with summing, so do not assume it will insert an average.

Excel for the web also supports the AVERAGE function. Type the formula into a cell or use the ribbon’s AutoSum options, then inspect the selected range. Keyboard behavior in a browser can be affected by browser shortcuts and the web interface, so the Windows desktop keytip sequence may not behave identically in every browser or configuration. The formula is the most portable option across Windows, Mac, and the web.

Common shortcut and result problems

If Excel inserts SUM instead of AVERAGE, the likely cause is that Alt+= was used or the Sum option was chosen. Undo if appropriate, then select Average from the AutoSum dropdown or replace the formula with AVERAGE. If the keytip sequence does not work, press Alt and follow the on-screen letters rather than repeatedly entering a sequence from another language or version.

If the displayed result seems wrong, click the result cell and inspect its formula in the formula bar. Confirm that the start and end references include the intended observations and do not include a total that should not be part of the average. Also check whether zero values are meaningful data, whether apparent blanks contain formulas returning an empty string, and whether numeric-looking entries are stored as text. AVERAGE ignores actual empty cells, but a formula returning an empty text value is not the same thing as a truly empty cell.

Another common misunderstanding is that changing the number format changes the average. Formatting controls how the result is displayed, not the underlying calculation. For example, a result may appear rounded to one decimal place while Excel retains additional precision internally. Increase the displayed decimal places if you need to inspect more digits; do not alter the input data just to change how the result looks.

Frequently Asked Questions

What is the keyboard shortcut for Average in Excel?
There is no universal standalone Average key. On the English Windows desktop ribbon, Alt, H, U, A opens the AutoSum Average choice; follow the displayed keytips if they differ. You can always enter an AVERAGE formula directly.

Does Alt+= calculate an average?
No. Alt+= is the AutoSum shortcut and normally inserts SUM. To calculate a mean, choose Average in AutoSum or use a formula such as =AVERAGE(B2:B13).

How do I average a column without including its total?
Use a reference that covers only the observation cells. If the data is in B2:B13 and the total is in B14, =AVERAGE(B2:B13) excludes the total. Always review the range proposed by AutoSum before confirming.

Does AVERAGE count blank cells as zero?
No. Empty cells in a referenced range are ignored, while numeric zeroes are included. A zero therefore lowers the result if other values are positive.

What is the difference between AVERAGE and MEDIAN?
AVERAGE calculates the sum of numeric values divided by their count. MEDIAN returns the middle value after the observations are ordered, or the midpoint of the two central values when the count is even. They can differ substantially when data contains outliers.

Quick recommendation

For a one-off average beside a clean block of data, AutoSum’s Average option can save a few keystrokes, provided you verify the proposed range. For a formula you want to control, reuse, or share across platforms, type =AVERAGE(range) and replace range with the exact cells. Remember that the choice of cells and the meaning of zero matter more to the answer than the shortcut used to enter it.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.