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.

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.

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.

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.

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.

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