To calculate the average using the keyboard shortcut Alt + H + U + A in Excel, follow these steps:
Table of Contents
Steps:
- Open your Excel worksheet.
- Select the range of cells for which you want to calculate the average.
- Press Alt + H (Opens the Home tab).
- Press U (Opens the AutoSum drop-down).
- Press A (Selects the Average function).
What Happens?
- Excel will automatically insert the AVERAGE formula for the selected range.
- Press Enter to confirm and calculate the average.
This shortcut quickly applies the AVERAGE function without manually typing the formula. 🚀
