Home |
Search |
Today's Posts |
#1
|
|||
|
|||
keyboard shortcut for sum
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. |
#2
|
|||
|
|||
Sarah
ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. |
#3
|
|||
|
|||
Super, Thanks! Is there a listing of all the ALT shortcuts? I have found
for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. |
#4
|
|||
|
|||
Sarah
HelpAnswer wizardshortcut 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 On Sat, 8 Oct 2005 15:49:01 -0700, "Sarah" wrote: Super, Thanks! Is there a listing of all the ALT shortcuts? I have found for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
keyboard shortcut for sum
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. "Gord Dibben" wrote: Sarah HelpAnswer wizardshortcut 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 On Sat, 8 Oct 2005 15:49:01 -0700, "Sarah" wrote: Super, Thanks! Is there a listing of all the ALT shortcuts? I have found for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
keyboard shortcut for sum
You have another reply at your other thread.
HISNA wrote: 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. "Gord Dibben" wrote: Sarah HelpAnswer wizardshortcut 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 On Sat, 8 Oct 2005 15:49:01 -0700, "Sarah" wrote: Super, Thanks! Is there a listing of all the ALT shortcuts? I have found for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
keyboard shortcut for sum
Dear Dave;
It seems like my thread is gone. Could you me a solution? "Dave Peterson" wrote: You have another reply at your other thread. HISNA wrote: 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. "Gord Dibben" wrote: Sarah HelpAnswer wizardshortcut 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 On Sat, 8 Oct 2005 15:49:01 -0700, "Sarah" wrote: Super, Thanks! Is there a listing of all the ALT shortcuts? I have found for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
keyboard shortcut for sum
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 On Thu, 31 Aug 2006 13:27:01 -0700, HISNA wrote: Dear Dave; It seems like my thread is gone. Could you me a solution? "Dave Peterson" wrote: You have another reply at your other thread. HISNA wrote: 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. "Gord Dibben" wrote: Sarah HelpAnswer wizardshortcut 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 On Sat, 8 Oct 2005 15:49:01 -0700, "Sarah" wrote: Super, Thanks! Is there a listing of all the ALT shortcuts? I have found for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. -- Dave Peterson |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
keyboard shortcut for sum
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:*excel* HISNA wrote: Dear Dave; It seems like my thread is gone. Could you me a solution? "Dave Peterson" wrote: You have another reply at your other thread. HISNA wrote: 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. "Gord Dibben" wrote: Sarah HelpAnswer wizardshortcut 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 On Sat, 8 Oct 2005 15:49:01 -0700, "Sarah" wrote: Super, Thanks! Is there a listing of all the ALT shortcuts? I have found for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. -- Dave Peterson -- Dave Peterson |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
keyboard shortcut for sum
Same subject???
Gord Dibben wrote: 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 On Thu, 31 Aug 2006 13:27:01 -0700, HISNA wrote: Dear Dave; It seems like my thread is gone. Could you me a solution? "Dave Peterson" wrote: You have another reply at your other thread. HISNA wrote: 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. "Gord Dibben" wrote: Sarah HelpAnswer wizardshortcut 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 On Sat, 8 Oct 2005 15:49:01 -0700, "Sarah" wrote: Super, Thanks! Is there a listing of all the ALT shortcuts? I have found for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. -- Dave Peterson -- Dave Peterson |
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
keyboard shortcut for sum
Yes
Looks like HISNA found a thread that Sarah and I had going in October and tagged onto the same thread. Gord On Thu, 31 Aug 2006 16:28:56 -0500, Dave Peterson wrote: Same subject??? Gord Dibben wrote: 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 On Thu, 31 Aug 2006 13:27:01 -0700, HISNA wrote: Dear Dave; It seems like my thread is gone. Could you me a solution? "Dave Peterson" wrote: You have another reply at your other thread. HISNA wrote: 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. "Gord Dibben" wrote: Sarah HelpAnswer wizardshortcut 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 On Sat, 8 Oct 2005 15:49:01 -0700, "Sarah" wrote: Super, Thanks! Is there a listing of all the ALT shortcuts? I have found for CTRL, but not ALT "Gord Dibben" wrote: Sarah ALT + = then ENTER will do same as the Autosum button. Only on contiguous data above the insertion point. Gord Dibben Excel MVP On Sat, 8 Oct 2005 15:11:06 -0700, "Sarah" wrote: 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. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keyboard Shortcut to move to top of column in worksheet? | Excel Discussion (Misc queries) | |||
Keyboard Shortcut for "Paste Values"? | Excel Discussion (Misc queries) | |||
Keyboard Shortcut for moving between Worksheets | Excel Discussion (Misc queries) | |||
Keyboard shortcut to open links | Excel Discussion (Misc queries) | |||
keyboard shortcut | Excel Worksheet Functions |