keyboard shortcut for sum

[Guest]

Is there a keyboard shortcut to do a quicksum of the adjacent numbers above
the cell I am in? I would rather not mouse to the quicksum, as it takes my
hands off the keyboard.

 

[Gord Dibben]

Sarah

ALT + = then ENTER will do same as the Autosum button.

Only on contiguous data above the insertion point.


Gord Dibben Excel MVP

 

[Guest]

Super, Thanks! Is there a listing of all the ALT shortcuts? I have found
for CTRL, but not ALT

 

[Gord Dibben]

Sarah

Help>Answer wizard>shortcut keys to get a good listing of shortcut keys for
Excel.

Visit David McRitchie's site for a listing of all.

http://www.mvps.org/dmcritchie/excel/shortx2k.htm

For a list of all plus just the ALT + keys Chip Pearson has downloadable
*.ZIPped workbook files on his site.

http://www.cpearson.com/excel/ShortCuts.htm


Gord

 

[Guest]

By some reason, "ALT + = then ENTER will do same as the Autosum button." does
not work. I have tries many times, but it does not work.
Do I miss something?
Thanks.

 

[Dave Peterson]

You have another reply at your other thread.

By some reason, "ALT + = then ENTER will do same as the Autosum button." does
not work. I have tries many times, but it does not work.
Do I miss something?
Thanks.

 

[Guest]

Dear Dave;

It seems like my thread is gone. Could you me a solution?

 

[Gord Dibben]

What I want to know is................

how did a couple of my posts from October 8, 2005 get mixed up in this thread?


Gord Dibben MS Excel MVP

 

[Dave Peterson]

This is one of the bad things about multiposting to different newsgroups. It
becomes a pain to check all the other newsgroups for responses.

You can use google to search the *excel* newsgroups and you can limit the seach
to where you're the author:

http://groups.google.co.uk/advanced_group_search?q=group:*excel*

 

[Dave Peterson]

Same subject???

What I want to know is................

how did a couple of my posts from October 8, 2005 get mixed up in this thread?

Gord Dibben MS Excel MVP

 

[Gord Dibben]

Yes

Looks like HISNA found a thread that Sarah and I had going in October and tagged
onto the same thread.


Gord