Excel Hack

Excel average shortcut

An average is a calculation to find the middle value of several numbers or quantities. There are many situations in Excel where the average of a number must be calculated. When compiling a large amount of numerical data, many people will try to find the average using the mouse. In Excel, you can use shortcuts to quickly find averages, which you will learn about in this article.

Shortcut to calculate average

Windows
Access Key: Alt + M + U + A

Mac
None

Calculating average using shortcut

For information on how to use shortcuts to calculate average, see below.

Total Time: 1 minute

Select a cell

Select a cell

Select the cell for which you want to calculate the average value.

AVERAGE function is entered

AVERAGE function is entered

Press Alt + M + U + A brings up the AVERAGE function, which automatically selects data in cells in the same column. This is the same for rows; the AVERAGE function will appear and data in the same row will be automatically selected. The data range can also be changed manually.

Completion of the calculation of the average

Completion of the calculation of the average

Press Enter reflects the average value of the selected data.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments