I was actually looking for a keyboard shortcut, as it takes longer to
pull-down & select like I've been doing. Thanks anyway.

"Ken Puls" wrote:

Highlight the cells you want to average

On the very bottom of the Excel window, you'll see probably see (on the
right), something that says SUM=xxx.xx where the xxx is your total.
Right click that, and choose average from the list.

HTH,

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

robin wrote:
Is there a way, beyond using the pull-down, to calculate an average of cells?
I'm looking for either a function key or shortcut key method. Please advise
ASAP.