The AutoSum shortcut, ALT+= in Excel

The AutoSum shortcut, ALT+= (ALT and = at the same time), allows you to automatically sum rows and/or columns.

Select Region Before AutoSum

If the current cell is in the column you want to sum i.e. B5, press CTRL+A to select all of the numbers in the columns, then press ALT =

OR

Use your mouse to select the columns and rows – A5:E18 – you want to sum, making sure the last column and row are empty as this is where the autosum will go.

#excel_tips_softexperia #softexperia #excel_functions.