"Average" shortcut

**alphaequity** · 03-04-2010, 01:32 PM

I know that the sum function shortcut key is Alt + =, but is there a similar shortcut for the average function? If not, is there an easy way to create one? Thank you.

**6StringJazzer** · 03-04-2010, 03:18 PM

Well, the ALT+= shortcut is not exactly for the function, it's for the autosum button, which happens to populate the cell with the function SUM. There is a subtle difference. There are not shortcuts for functions as such.

I thought it would be straightforward to write a macro that would do what you want, then assign a shortcut key to it, but when I run the macro the line

Please Login or Register  to view this content.

generates an error (1004, application-defined or object-defined error). I suspect that VBA might not be allowed to insert a function that a user would not be able to legally insert (i.e., AVERAGE without its arguments).

So I don't know of any way to do this.

**Paul** · 03-04-2010, 03:28 PM

It's "reasonably" straight forward to do this..

In your ThisWorkbook's Workbook_Open event, paste the following code:

Please Login or Register  to view this content.

Then insert a standard module and paste this code:

Please Login or Register  to view this content.

Finally, in the Workbook_BeforeClose event, add this to reset the key combo to nothing:

Please Login or Register  to view this content.

Save and close, then re-open the workbook. (Or, just run the workbook_open event manually from the vb editor to set that key combination.)

Now when you press ALT+- (ALT and minus) it will insert the AVERAGE function the same way that the autosum button works. It stops at any blank cell it encounters, just like the autosum function.

**DonW** · 02-14-2014, 05:59 PM

Just like the ALT+= inserts =sum(), ALT+MUA (ALT+M opens the formula ribbon, U opens the dropdown for autosum, A selects Average) inserts =average().

**FDibbins** · 02-14-2014, 07:08 PM

Don, that is a really great tip to remember :")

(however, this thread is almosr 4 years old, I doubt they are still monitoring it)

**DonW** · 02-15-2014, 01:20 AM

Thanks and you are probably quite right. Have a great weekend FDibbins.

**stinkycat** · 04-24-2023, 06:52 PM

Trying to do this in 2013...

**6StringJazzer** · 04-24-2023, 07:35 PM

Welcome to the Forum stinkycat!

Administrative Note:

We are happy to help, however while you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original. Also, this thread was started 13 years ago.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread

As a new member, please take the time to review our rules. There aren't many, and they are all important.