• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Excel

          • Excel Functions
          • Excel Tools
          • Excel Tips
        • Excel
        • Financial Functions Excel

          • NPV in Excel
          • IRR in excel
          • PV in Excel
        • Financial-Functions-Excel
        • Lookup Functions Excel

          • VLOOKUP
          • HLOOKUP
          • Index Function
        • Lookup-Functions-in-Excel
        • Excel Charts

          • Pareto Chart in Excel
          • Gannt Chart in Excel
          • Waterfall Chart in Excel
        • Excel-Charts
        • VBA

          • VBA Left Function
          • VBA Paste Special
          • VBA Worksheet Function
        • VBA
        • Others

          • Resources (A to Z)
          • Financial Modeling
          • Equity Research
          • Private Equity
          • Corporate Finance
          • Financial Statement Analysis
  • Free Courses
  • All Courses
        • Certification Courses

          Excel Course certificate
        • Excel VBA All in One Bundle

          Excel-VBA-Certification-Course
        • Excel Data Analysis Course

          Excel-Data-Analysis-Course
        • VBA Macros Course

          VBA-Training-Course
        • Others

          • Basic Excel Training
          • Advanced Excel Course
          • Tableau Certification Course
          • Excel for Finance Course

          • Excel for Marketers Course
          • Excel for HR Managers
          • Excel for Power Users
          • View All
  • Excel VBA All in One Bundle
  • Login

Excel SUM Shortcut

Home » Excel » Maths Function in Excel » Excel SUM Shortcut

By Jyoti Singh Leave a Comment

SUM Shortcut in Excel

Sum is an inbuilt function in excel but we also do have an excel shortcut for this which is to press ALT + = in the cell where we want the sum for the corresponding cells, to use this shortcut just press the keys and Sum function will automatically appear in the cell, note the data to be sum is should be in continuous range.

SUM Shortcut in Excel

In excel more often we work with numerical data than non-numerical data sets. When we work with the number we do a lot of arithmetic calculations. In those calculations, we spend so much of time and one of such calculation is “SUM”. Believe me or not to increase your productivity your shortcut skills should be at the highest level in excel. You will be amazed by the fact that your productivity can be improved by 50% if you can master SUM shortcut keys in excel.

Ok, in this article we will show you how to use autosum “Sum Shortcut” key in excel and we will also show you the limitations of the shortcut.

You can download this SUM Shortcut Excel Template here – SUM Shortcut Excel Template

How to Apply the SUM Function in Excel?

For an example look at the below data.

excel sum shortcut example 1

We have some numbers from cell A1 to A5 and in the cell we need the total of these numbers in cell A6.

Let’s open the SUM excel function in cell A6.

excel sum shortcut example 1-1

Select the range of cells from A1 to A5.

excel sum shortcut example 1-2

Press enter key to get the result in cell C6.

excel sum shortcut example 1-3

This looks a lengthy process, isn’t it??

Using Auto Sum in Excel to Reduce Cycle Time?

Here we have simple shortcut key i.e. ALT + =.

simple shortcut key

This is the shortcut key to auto sum the above cell numbers. Ok, let’s try this out now.

Place a cursor on the where we need to apply the excel formula, in this case, formula cell is A6.

excel sum shortcut example 2

Now hold the ALT key and press equal sign.

excel sum shortcut example 2-1

As you can see as soon as you press the excel shortcut key it has applied the SUM formula by selecting the above cells as the reference.

Press enter key to get the result in cell C6.

excel sum shortcut example 2-2

Like this using sum shortcut key ALT + = we can automatically apply the SUM function to get the total of above cell numbers.

Popular Course in this category
Cyber Monday Sale
All in One Excel VBA Bundle (35 Courses with Projects) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,353 ratings)
Course Price

View Course

Related Courses
VBA Macros CourseAdvanced Excel CourseTableau Certification Course

Top Ways of SUM Shortcut Key in Excel

We can apply the excel auto sum shortcut key in many ways. Let’s look at some ways.

Method #1 – Get Total to Below Cell

Let’s consider the same data as we have seen in the previous example. First, select the range of cells from A1 to A5.

excel sum shortcut example 3

Since I need the result in A6 cell I have selected until that cell.

Now press the shortcut key ALT + =.

excel sum shortcut example 3-1

As you notice it has not displayed any kind of SUM function syntax, rather just given us the total of the numbers we have selected.

Method #2 – Click on Auto Sum under Home Tab

Let’s consider the same data for this example as well.

Place a cursor on the cell C6.

 3-2

Now go to Home Tab and Press excel shortcut key AUTO SUM.

sum shortcut example 3-3

Now as soon as you click on “Auto Sum”, we can see the pop-up SUM function in cell C6.

3-4

Like this, we can apply the excel SUM shortcut key to arrive the results.

Auto Sum More than One Column Data in Excel

Assume we have numbers in more than one column, so how do we add these numbers.

Example 4

We have numbers in more than one column. So, select all the result columns once.

Example 4-1

Now after selecting the result cells press ALt + =.

4-2

It has applied the formula to the last cell of the selection, now don’t simply press Enter, rather hit Ctrl + Enter key to apply the same formula to all the selected cells.

Example 4-3

So, upon pressing this shortcut key, we got the auto sum formula in all the selected cells.

Horizontal Auto Sum in Excel

Now we have seen how to apply excel auto sum shortcut to vertical data i.e. Column Data. For this consider the below data.

5

Now select the cells from A1 to E1.

Example 5-1

Now press Alt + = to arrive auto sum.

5-2

As we can see it has applied the sum formula to the beside cell of the selected cells.

Limitations

One of the limitations of the sum shortcut key excel is it will consider all the above cells until it finds the blank cell only. For an example look at the below image.

I have data from A1 to A6 cell but in this range, there is a blank cell i.e. A3 cell.

6

I have pressed the shortcut key ALT + = to apply AUTO SUM shortcut key. Since there is a blank cell auto sum has ignored all the above cells which have data and returned only the sum of selected cells only.

6-1

In this example data is small and identification is easy but in large data, it is a dangerous ploy, so be careful with this.

Recommended Articles

This has been a guide to SUM Shortcut in Excel. Here we learn how to use Auto Sum Shortcut Key in Excel along with examples and downloadable excel template. You may learn more about excel from the following articles –

  • How to Match Excel Data?
  • Perform Running Total in Excel
  • Bullet Points in Excel
  • PI Function in Excel
  • Filter Excel Shortcut
  • Insert Row Excel Shortcut
  • “Save As” Excel Shortcut
  • Merge Cells in Excel Shortcut
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel, Maths Function in Excel

Reader Interactions
Leave a Reply Cancel reply

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

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download SUM Shortcut Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

CYBER WEEK OFFER - All in One Excel VBA Bundle (35 Courses with Projects) View More