close

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 quot;normalquot; fashion. I also cannot figure out how to set up a macro
to act as an autosum.

Try this:

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

Does that help?

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

XL2002, WinXP-Proquot;dsapanquot; wrote:

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

Brilliant! Thank you!

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Hold down the [Alt] key and press the equal key [=]
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;dsapanquot; wrote:
gt;
gt; gt; I used the Autosum button (on the top toolbar) all of the time and would like
gt; gt; to set up a shortcut key. Since this button is not in a Menu, I cannot add
gt; gt; it in the quot;normalquot; fashion. I also cannot figure out how to set up a macro
gt; gt; to act as an autosum.

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

quot;Ron Coderrequot; wrote:

gt; Try this:
gt;
gt; Hold down the [Alt] key and press the equal key [=]
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;dsapanquot; wrote:
gt;
gt; gt; I used the Autosum button (on the top toolbar) all of the time and would like
gt; gt; to set up a shortcut key. Since this button is not in a Menu, I cannot add
gt; gt; it in the quot;normalquot; fashion. I also cannot figure out how to set up a macro
gt; gt; to act as an autosum.

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()