How can I set up a shortcut key for Autosum?

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

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.

's Computer Specifications

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.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How 2 sort an autosum total list after adding items 2 autosum item	akm	Microsoft Excel Misc	0	30th May 2010 11:44 PM
Shortcut for Autosum	=?Utf-8?B?SElTTkE=?=	Microsoft Excel Misc	1	31st Aug 2006 09:34 PM
Shortcut Keystroke for the AutoSum button or Sum function?	=?Utf-8?B?TCBMaWdodG5lcg==?=	Microsoft Excel Misc	2	19th Jul 2006 12:56 AM
I know Autosum. Is there an "automultiply" shortcut?	James C	Microsoft Excel Misc	2	9th Oct 2005 02:27 PM
Assingning a shortcut key to an autosum function	Dennis Denisov	Microsoft Excel New Users	3	30th Mar 2004 10:26 PM