ALL BUSINESS ENGLISH ARTICLES MICROSOFT EXCEL TIPS

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.

Views: 0

Comments are closed.

Pin It

By continuing to use the site, you agree to the use of cookies. / Συνεχίζοντας να χρησιμοποιείτε την ιστοσελίδα, συμφωνείτε με τη χρήση των cookies. more information / περισσότερες πληροφορίες

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close