Add Numbers In Excel

Steps to add numbers in Excel

• Option 1: Use the SUM function manually
  • Step 1: Select the cell where you want the total to appear.
  • Step 2: Type the formula =SUM(range) and press Enter.
    (Example: =SUM(A1:A5))

Result: Excel will return the sum of all values in the specified range.

• Option 2: Use a shortcut to insert the SUM function automatically

  • Step 1: Select the range of cells you want to add.

  • Step 2: Press Alt + = to insert the SUM formula instantly.

Result: The total will be calculated and shown in the cell just below or to the right of the selected range.

Tip: This shortcut works best when the numbers are arranged in a continuous block without empty rows or columns.