Auto Sum Shortcuts for Beginners


Here are some common shortcuts for quickly summing data in Excel:

  1. Alt + = - Auto sum selected cells.
  2. Ctrl + Shift + T - Sum the selected cells and insert the result in the next cell.
  3. Ctrl + Shift + : - Sum the selected cells and insert the result in the current cell.
  4. Ctrl + Shift + L - Apply or remove a filter.
  5. Ctrl + Shift + T - Sum the selected cells and insert the result in the next cell.
  6. Ctrl + Shift + : - Sum the selected cells and insert the result in the current cell.
  7. Ctrl + Shift + { - Group the selected cells.
  8. Ctrl + Shift + } - Ungroup the selected cells.
  9. Ctrl + Shift + ( - Show the outline symbol in the selected cells.
  10. Ctrl + Shift + ) - Hide the outline symbol in the selected cells.
Please note that these shortcuts may vary depending on the version of Excel you are using.

Also, keep in mind that these shortcuts work for the selected cells, and for the auto sum shortcut (Alt + =) specifically it will only work if the cursor is placed in the cell where the sum should be inserted.

    Comments

    Post a Comment