Summarize a whole table in Excel without writing a formula

Instead of typing a SUM formula, an easier way to go is to use the shortcut Alt + Equal sign (=)

But did you know that you can use this shortcut for a whole table?

If you have a table like the one below, select all the values plus one extra row and one extra column:

And use the shortcut:

Alt + Equal sign (=)

Instantly, Excel inserts all the formulas and calculates the sums:

More easy tricks in Excel:

The easiest way to reduce file size in Excel: Excel Binary Workbook
How to find cells that contain a formula in Excel
How to Copy Format in Excel
Hide Future Dates in Excel with Conditional Formatting

Are you using a non-English version of Excel? Click here for translations of the 140 most common functions in 17 different languages:

Catalan
Czech
Danish
Dutch
Finnish
French
Galician
German
Hungarian
Italian
Norwegian
Polish
Portuguese (Brazilian)
Portuguese (European)
Russian
Spanish
Swedish
Turkish

Leave a Reply

Your email address will not be published. Required fields are marked *


+ 2 = three