In Excel for Microsoft 365 on Windows, click the blank cell where you want the result, press Alt, H, U, A, then press Enter to insert an average. The shortcut opens the AutoSum Average command; Excel suggests a range, which you can check or edit before confirming.
What the Average Shortcut Does
The key sequence uses Excel’s ribbon Key Tips to run the Average option in AutoSum. It is not a separate calculation method: Excel enters an AVERAGE formula into the active cell. The shortcut is useful when your numbers sit in a straightforward row or column and you want Excel to suggest which cells to include.
To use it, first click an empty result cell, commonly just below a column of numbers or just to the right of a row. Then press the keys in order, rather than all at once: hold Alt briefly to show the Key Tips, press H for Home, U for AutoSum, and A for Average. Inspect the formula or highlighted range Excel proposes. Press Enter to accept it, or adjust the range before pressing Enter.
The letters are ribbon Key Tips, so they may be less convenient if you use a customized ribbon or a different Excel version. If the sequence does not work, use the ribbon route instead: Home > Editing > AutoSum arrow > Average. The command may be shown as a Greek sigma (Σ) button with a dropdown arrow.
Where to Put the Result
Excel’s suggested range depends on the active cell and nearby data. If you click immediately under a continuous list of numbers, it will generally propose the cells above. If you click to the right of a row, it may propose the values to the left. That guess is convenient, but it is not a guarantee that Excel has identified the data you intended.
For example, a blank cell beneath a column may appear to be the natural place for the result, but a blank row within the data can interrupt the suggested range. Data in a nearby column can also affect what Excel selects. Before accepting, check the outlined cells on the sheet or read the reference in the formula bar. If the range is wrong, select the reference inside the formula and replace it with the correct cells.
- Put the result outside the data being averaged so the formula does not include itself.
- Check that the proposed first and last cells match the data you want.
- If the data is separated into several blocks, use a formula with an explicit range instead of relying on AutoSum’s guess.
Use the AVERAGE Formula Directly
The function behind the shortcut is AVERAGE. Typing it directly is often faster when you know the exact range or need to average cells that are not next to the result cell. Click the result cell, type the formula, and press Enter. You can also begin typing =AVERAGE(, select the cells, type the closing parenthesis, and confirm.
With test scores in cells B2 through B6, enter =AVERAGE(B2:B6) in another cell. If the scores are 72, 84, 90, 76, and 88, the result is 82: their sum is 410, divided by five values.
AVERAGE accepts a range or individual numeric arguments, separated by commas. For example, if the values you want are in B2, B5, and B9, enter =AVERAGE(B2,B5,B9). A colon denotes a continuous range, while commas separate distinct arguments. In some regional settings, Excel uses semicolons rather than commas as formula separators; follow the separator Excel accepts on your computer.
What Excel Includes in an Average
Knowing how AVERAGE treats different cell contents helps explain results that seem unexpected. In a referenced range, Excel averages numeric values, ignores empty cells and text, and includes zeros. Thus, a blank cell is not treated as a zero, but a cell containing the number 0 is part of the calculation and can lower the result. A cell that looks blank because its formula returns an empty text string is also not a numeric value for AVERAGE.
Suppose B2:B5 contains 10, 20, a blank cell, and 0. The average is 10, because Excel calculates (10 + 20 + 0) divided by three numeric values. If the zero represents missing information rather than a real measurement, it should not be left in the range as a numeric zero if you intend to exclude it. Decide what missing values mean in your data before choosing a calculation.
Text accidentally entered as a number can also be skipped when it is inside a referenced range. For example, a number stored as text may look like a number but fail to affect the average. If you suspect this, check for warning indicators or use Excel’s number-format and conversion tools, then verify the result. Error values in the referenced range generally cause AVERAGE to return an error rather than silently skip the problem.
Average Filtered or Visible Rows
A regular AVERAGE calculation includes values in rows hidden by a filter, even if those rows are not currently visible. That distinction matters when you filter a sales table and want the mean for only the displayed records. The AutoSum Average shortcut does not automatically change the behavior of AVERAGE to account for a filter.
For visible rows in a filtered list, SUBTOTAL can calculate an average while ignoring rows removed by the filter. With the values to average in B2:B20, enter =SUBTOTAL(1,B2:B20) in a result cell. The function number 1 means average. SUBTOTAL ignores rows excluded by a filter; with function number 1, manually hidden rows are included. If manually hidden rows should also be excluded, use =SUBTOTAL(101,B2:B20) instead. In either case, the range should cover the relevant numeric data, not the result cell.
This is a different task from getting an average of every record in a range. Before replacing the shortcut’s AVERAGE result, decide whether hidden or filtered-out records are meant to count. A quick check is to clear the filter and compare the displayed-row result with the whole-range result.
Windows, Mac, and Excel for the Web
The Alt, H, U, A sequence is for Excel on Windows. Excel for Mac has different keyboard conventions, and ribbon Key Tips may not match the Windows sequence. On Mac, use the ribbon’s AutoSum menu and choose Average, or enter AVERAGE directly; do not assume a Windows Alt sequence will work on a Mac keyboard.
Excel for the web also supports formulas such as AVERAGE, and its ribbon layout or available keyboard navigation can differ from the Windows desktop application. If a keyboard sequence is unavailable in your browser or version, typing the formula is the most consistent option. The formula syntax remains the same in standard English-language installations, though regional formula separators can vary.
Common Problems and Quick Checks
If the shortcut inserts a formula but the answer is wrong, first look at the range, then inspect the cell contents. A correct-looking result can still be based on a wrong selection or on numbers stored as text. Use these checks to diagnose the usual issues:
- The selected range is incomplete: edit the cell references so they cover all intended values.
- The average is lower than expected: look for genuine zeros that should not count, or filtered-out values included by AVERAGE.
- The answer is unexpectedly high or low: check for an outlier, a duplicate, or values from an adjacent column included by mistake.
- The result is an error: inspect the referenced cells for error values and confirm that the formula references valid cells.
- Excel does not recognize a number: check whether the entry is stored as text, and convert it if it should be numeric.
It is also easy to confuse average with sum. AutoSum’s default command is commonly associated with adding values, but the dropdown includes Average as a separate choice. If the formula bar shows SUM, you have inserted a total, not a mean. Replace the function with AVERAGE or run the Average option from the AutoSum menu.
When to Use the Shortcut, a Formula, or the Status Bar
Use the shortcut when the answer belongs in a worksheet cell and the data forms a simple adjacent block. Use a typed AVERAGE formula when you want precise control over nonadjacent ranges, need to make the calculation easy to read later, or want the result to update as the referenced values change. For a one-time glance, select numeric cells and look at Excel’s status bar, which can display Average without adding a formula to the sheet.
If Average is not visible on the status bar, right-click the status bar at the bottom of the Excel window and enable Average in its list of calculations. This display is convenient for quick checks, but it is not a worksheet result that you can reference in another formula or print as part of the table. A formula is preferable when the calculation needs to be documented, reused, or included in a report.
Frequently Asked Questions
What is the keyboard shortcut for Average in Excel?
In Excel for Microsoft 365 on Windows, click the result cell and press Alt, H, U, A, then Enter. Check the proposed range before accepting. On Mac, use the AutoSum menu or type an AVERAGE formula because the Windows Key Tip sequence differs.
What formula calculates an average in Excel?
Use AVERAGE with the range you want to calculate, such as =AVERAGE(B2:B10). It averages numeric values in that range, ignores blanks and text, and includes numeric zeros.
Does Excel’s Average shortcut ignore zeros?
No. The shortcut inserts an AVERAGE calculation, and AVERAGE includes zero values. It ignores empty cells, but a cell containing 0 is a number and counts in both the sum and the number of values.
Why is the average from AutoSum wrong?
Excel may have guessed the wrong range, included values you meant to exclude, or skipped entries stored as text. Inspect the highlighted range and the formula bar, then verify zeros, filters, and the underlying cell values.
Can I average only the rows shown after filtering?
Use SUBTOTAL rather than the AutoSum Average shortcut for a filtered list. For example, =SUBTOTAL(1,B2:B20) averages visible filtered rows while including manually hidden rows; function number 101 also excludes manually hidden rows.
Related
- Access vs Excel: Pros, Cons, and Best Uses Compared
- Accidentally Didn’t Save an Excel File? Recover It
- Access Database vs Excel Spreadsheet: Which to Use?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Clean Excel Duplicates: Find, Review, and Remove ThemTo clean duplicates in Excel for Microsoft 365 on Windows, select your data, choose Data > Remove Duplicates,…
- Create an Email Distribution List in Outlook 365To create an email distribution list in Outlook 365, open People and choose New contact list in new…
- Search Excel for Duplicate Entries: Methods That WorkTo search Excel for duplicate entries, select the cells you want to check, then choose Home > Conditional…
- Filtering in Google Sheets: How to Narrow and Sort DataTo filter data in Google Sheets, select a cell in your table and choose Data > Create a…
- Excel Data Table Relationships and How to Create ThemIn Excel, table relationships link separate tables through matching key columns, letting PivotTables and the Data Model analyze…
- Google Sheets IF Function: Syntax and ExamplesIn Google Sheets, the IF function checks whether a condition is true and returns one value if it…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.