How can I set up a shortcut key for Autosum?
 

I used the Autosum button (on the top toolbar) all of the time and would like
to set up a shortcut key. Since this button is not in a Menu, I cannot add
it in the "normal" fashion. I also cannot figure out how to set up a macro
to act as an autosum.

How can I set up a shortcut key for Autosum?
 

Try this:

Hold down the [Alt] key and press the equal key [=]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"dsapan" wrote:

I used the Autosum button (on the top toolbar) all of the time and would like
to set up a shortcut key. Since this button is not in a Menu, I cannot add
it in the "normal" fashion. I also cannot figure out how to set up a macro
to act as an autosum.

How can I set up a shortcut key for Autosum?
 

Brilliant! Thank you!

"Ron Coderre" wrote:

Try this:

Hold down the [Alt] key and press the equal key [=]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"dsapan" wrote:

I used the Autosum button (on the top toolbar) all of the time and would like
to set up a shortcut key. Since this button is not in a Menu, I cannot add
it in the "normal" fashion. I also cannot figure out how to set up a macro
to act as an autosum.

How can I set up a shortcut key for Autosum?
 

On 2007, works perfect... you the man!

"Ron Coderre" wrote:

Try this:

Hold down the [Alt] key and press the equal key [=]

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"dsapan" wrote:

I used the Autosum button (on the top toolbar) all of the time and would like
to set up a shortcut key. Since this button is not in a Menu, I cannot add
it in the "normal" fashion. I also cannot figure out how to set up a macro
to act as an autosum.