How can I set up a shortcut key for Autosum?

[dsapan]

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.

[Ron Coderre]

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.

[dsapan]

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.