View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
HISNA HISNA is offline
external usenet poster
 
Posts: 8
Default 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.