Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?

In this lesson, I’m going to be showing you how to:

  1. Use the AUTOSUM button to quickly ADD up cells in Excel
  2. Understand everything about the Autosum button in Excel

Go ahead, open the video below and watch the tutorial at your own pace:

If I have not covered anything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our YouTube channel and Subscribe

Thanks for watching!

Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then CLICK HERE to join a learning platform for FREE and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

CLICK HERE to read our review about this amazing learning platform, if you want to know more.

When you’re ready move onto:

Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel

Or go back to:

Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?

Lesson 24 – How to SORT data in ASCENDING order in Excel

Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel

Lesson 22 – How to RENAME a worksheet in Excel

Lesson 21 – How to COPY cells from one spreadsheet to another spreadsheet in Excel

Lesson 20 – How to select multiple NON-ADJACENT cells in Excel | What are the benefits?

Lesson 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?

Lesson 18 – What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?

Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel

Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel

Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel

Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?

Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?

Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?

Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?

Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?

Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?

Lesson 8 – What is the IF function, and how to insert it in Excel?

Lesson 7 – What is the ROUND function, and how to insert it in Excel?

Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?

Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?

Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?

Lesson 3 – Simple Subtraction Formula using Excel

Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel

Lesson 1 – Simple multiplication Formula using Excel

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

28 thoughts on “Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?”

  1. Thanks for this great tutorial .

    I’ve always found Excel difficult, and other tutorials have left me struggling. Your site has really helped me get on top of my excel issues.

    This is something that I have avoided dealing with for some time so having access to everything I need to learn here on your site is a fantastic resource for me.

    Thanks again for setting out this useful information.

    Reply
    • You’re very welcome Judy – our site will give you all the excel knowledge you need in a sequential form with the lessons. There will be other lesson too on Microsoft word, powerpoint, publisher, access, etc soon. Take care

      Habib (ICT Tutor)

      Reply
  2. Hi Habib

    Wow-what a great tutorial and educational site. I’m impressed with your layout and it’s very user friendly.
    I’ve always struggled a little with Excel so your site is going to come in handy for sure. The formulas are what rattles me up lol. I love that I can access everything I need to know about excel in lessons that are easily laid out. I find that working in an office environment, not being comfortable with excel has held me back so I’m grateful I stumbled across your site.
    Thanks again for this very useful information.

    All the best

    Tracy

    Reply
    • Thank you so much for your lovely feedback about our site. You will love our YouTube channel too 🙂
      Excel can rattle people lol. This is why I have made the lessons very easy to understand and have designed the site so anyone can navigate to any lessons very easily. Take care and thank you for taking your time to give your feedback 🙂

      Habib (ICT Tutor)

      Reply
  3. Hey, Habib. I enjoyed watching your excel lessons on Youtube. I just found out some functions from Excel and I could not expect that Excel had many extraordinary functions, which could use formulas so that it was easy to calculate data in tables. Thanks for sharing this post.

    Luiz. C.

    Reply
  4. Thanks for this excellent post on excel – I use excel every single day for so many things from tracking my personal finances to creating my shopping lists and all my personal and business planning. I make use of the autosum button all the time, it is so useful and one of the things I love the most about excel.

    Reply
    • That’s great to hear Lynne. Now lets get everybody else to use excel too because it has so many amazing features such as this Autosum to make peoples lives so much more easier. Thanks for the encouraging words – my visitors will benefit from it surely 🙂

      Habib (ICT Tutor)

      Reply
  5. Hi Habibrani,
    I have worked with excel for the years time. When I watched your video tutorial your teaching is excellent and clear. It is very useful not only to the beginners but also to the others. When need to add some numbers amounts together I too have to try with several clicks (trial & error) but furthermore I don’t need waste time because your methods with AUTOSUM stay in my mind. Thank you for valuable tutorial. Keep it up.
    Regards
    Jayantha

    Reply
    • Thank you so much Jayantha for the lovely compliments about my teaching. I am an ICT by profession, and I must say I do get a lot of compliments on my teaching style 🙂
      The Autosum is a great feature and saves you a lot of time. I have many other video lessons here and on our YouTube channel, so please check them out too.

      Habib (ICT Tutor)

      Reply
  6. Hi Habib. Thank you for the step by step guide of how to use the AUTOSUM. Learn something new today again! Looking forward for the next lesson.

    Reply
  7. Thank you for this useful and easy-to-follow tutorial on these topics. As almost everyone uses Excel, knowledge and proficiency on many of its functions such as AutoSum would come very handy. More power to you.

    Reply
    • You’re welcome. Excel is such a powerful software and it is not commonly used. I am trying to break down the technical barriers so everyone will start using it with ease. The Autosum button does an amazing adding up, but people are not using it! Take care

      Habib (ICT Tutor)

      Reply
  8. Hey Habib,

    Keep up the great work, with each one of these lessons you make my day at work easier and definitely much more efficient. This is another bookmarked one for later reference.

    Thanks,
    Tyler

    Reply
    • You’re very welcome Tyler and thank you. Great idea to bookmark it and come back to learn when you have time. You will be a whiz kid at work soon and your colleagues will be asking you for help 🙂

      Habib (ICT Tutor)

      Reply
  9. Thanks for showing a quick way of adding up our numbers in the excel spreadsheet. I’ll use this on the next project I have requiring a long addition.

    Reply
  10. I have been teaching computer studies for over 10 years and I think you have a very good way of teaching excel, piece by piece and very clear. It’s very easy to understand, keep up the good work.

    Reply
    • Thank you very much James. A compliment from a tutor is the best one. If you do have any advice or tips for me, please do let me know 🙂

      Habib (ICT Tutor)

      Reply
  11. Another great lesson! Sometimes I forget to use this so I thank you for the reminder. If you take requests I would love to learn about the VLookup function. I can never get that to work.

    Thanks for the guidance!

    Reply
    • Thank you Kevin. Yes I do take requests, and I have made a list for that 🙂
      I will be doing a lesson on Vlookups soon, so watch out for that. I promise I will make it very easy for you. Take care

      Habib (ICT Tutor)

      Reply
  12. A great explanation on how to use the auto-sum button to quickly add cells in excel.

    We all use Excel but I’d like to bet many don’t know these functions which makes life so much easier.

    I only use a few functions myself but used to use more and it’s great to be able to have a refresher so thank you for that.

    Great article.

    Reply

Leave a comment

Share via
Copy link
Powered by Social Snap