Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Shortcut to AutoSum (XP)

    Can anyone tell me please whether there is a way to assign a shortcut key combination to the AutoSum button in the Toolbar?

    whilst working with data entry it is easier to continue using the keyboard rather than switching to the mouse to confirm the sum of the column of figures.

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shortcut to AutoSum (XP)

    There is an existing shortcut key for AutoSum: Alt+=

    Note: in Excel 2002, the AutoSum button has become a split popup button; clicking the arrow will display a list of functions (Count, Average, ... that can be used). The keyboard shortcut will always create a SUM formula.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shortcut to AutoSum (XP)

    nice one Hans, thanks. I figured there should be one already but didnt guess that combinations!

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shortcut to AutoSum (XP)

    You can look up a list of all built-in shortcuts in the "keyboard shortcuts" help subject. AutoSum is in the Entering Formulas section (or something like that)

  5. #5
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Shortcut to AutoSum (XP)

    Also, if you select an entire table (CTRL + SHIFT + 8), plus one row below and one column to the right and then hit ALT + =, it will put totals for each row and each column in one stroke.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •