How to SUM a row in Excel shortcut?

To quickly SUM a row in Excel using a shortcut, select the cell to the right of the row you want to sum, then press Alt + = (equals). Finally, press Enter to display the sum.

Here's a breakdown of the process:

1. Select the Target Cell: Click on the cell immediately to the right of the row of numbers you want to add together. This is where the SUM result will appear.

2. Execute the Shortcut: Press and hold the Alt key, and then press the = (equals) key. Release both keys. Excel will automatically enter the SUM function and guess the range of cells you want to add in that row.

3. Confirm or Adjust the Range: Excel will display the SUM function with the guessed range selected (e.g., =SUM(A1:C1)).

   • If the range is correct, press Enter to accept it and display the sum.
   • If the range is incorrect, use your mouse or arrow keys to manually select the correct range of cells you want to include in the sum. Then, press Enter.

Example:

Let's say you have numbers in cells A1, B1, and C1, and you want to sum them in cell D1:

1. Click on cell D1.
2. Press Alt + =. Excel will likely enter =SUM(A1:C1) into cell D1.
3. Press Enter. Cell D1 will now display the sum of A1, B1, and C1.

This shortcut is a very efficient way to quickly sum rows (or columns) in Excel.