Lesson 49 – How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel

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

  1. Add up cells from multiple different worksheets in Excel
  2. Link data and cells across multiple different worksheets in Excel

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

If I have not covered everything 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 50: How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel

Or go back to:

Lesson 48: How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!

Lesson 47: How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel

Lesson 46: Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel

Lesson 45: How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel

Lesson 44: Use the IF function to work out if you are over BUDGET or not in Excel

Lesson 43: How to change a DATE to different FORMATS in Excel

Lesson 42: How to set and print rows & titles automatically at the top of each page in Excel

Lesson 41: How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel

Lesson 40: How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel

Lesson 39: How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel

Lesson 38: How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel

Lesson 37: How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel

Lesson 36: Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!

Lesson 35: How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel

Lesson 34: What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel

Lesson 33: How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?

Lesson 32: What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Lesson 31: Relative OR Absolute references in Excel | Everything explained | Confusion solved!

Lesson 30: Best method to format numbers to display as PERCENTAGES in Excel

Lesson 29: Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel

Lesson 28: A simple DIVISION formula in Excel | How to DIVIDE in Excel

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

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

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, Date, Percentages and apply Decimal Places to numbers in Excel

Lesson 12: Wrap Text in Excel | Break Text to Multiple Lines | Shrink to Fit

Lesson 11: Merge & Center in Excel | Merge Across | Merge Cells

Lesson 10: How to use the INSERT FUNCTION command in Excel

Lesson 9: Simple Subtraction Formula in Excel

Lesson 8: Using the COUNT and COUNTIF function to count ONLY the cells, which contains TEXTUAL data

Lesson 7: Count & CountA function in Excel | Difference between Count and CountA function in Excel

Lesson 6: MIN & MAX function in Excel | Find the Minimum and Maximum value within a range in Excel

Lesson 5: Average Function in Excel | What does Average mean

Lesson 4: Multiplication Formula in Excel | Replicate or Copy Formulas in Excel

Lesson 3: Formatting Cells in Excel | Make a Spreadsheet look visually attractive

Lesson 2: SUM function in Excel | Entering Text & Numbers | FREE Series of Microsoft Excel Lessons

Lesson 1: Introduction to Microsoft Excel | Excel Interface | FREE Series of Microsoft Excel Lessons (pdf guide included)

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

26 thoughts on “Lesson 49 – How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel”

  1. I didn’t even know this was possible. How can we add up cells from MULTIPLE different worksheets in Excel? I have yet to try it, but it does sound a bit complicated. Let me try this Habib, and I shall get back to you soon.

    • Yes off course, follow my video. You will find it very easy. But I do understand as initially it sounds complicated. This is an amazing feature and technique to use. You will love it.

      All the best

      Habib (ICT Tutor)

  2. Hello Habib.
    As always I enjoy watching ( and reading ) your tutorials. All the info you give is very useful and even a great reminder for those that don’t use excel often.
    Thank you

    • Hi Felicity,

      I highly appreciate you stopping by and giving your valuable feedback. Please keep visiting our site and YouTube channel for many more upcoming contents.

      Best wishes

      Habib (ICT Tutor)

  3. I learn something new every time I watch your tutorials. Ever since I found your website, I’ve been able to understand Excel much better which is great because my school is starting up soon, and I know that were definetly goung to be using Excel, so this is extremely helpful! Your tutorials are detailed yet short and very easy to understand!

    • Hi Aminah,
      Thank you so much for your generous feedback! Hopefully you will be a step ahead than your class peers in Excel, when you start learning this topic in school. Please share it with your class mates and friends so they can benefit from it too.

      Best wishes

      Habib (ICT Tutor)

  4. Excellent post / video Habib. Excel can be very tricky. Especially for someone like me who is very inexperienced. Your video was easy to watch and has great editing qualities in it. I can’t wait for the next one! Keep up the good work.

    • Thank you very much for the feedback and compliments. Keep visiting our site and YouTube channel for many more upcoming video tutorials.

      All the best

      Habib (ICT Tutor)

  5. Hello Habib, lucky me that I found your website. Thanks for your post and sharing with us. I’m looking for some methods like formulas how to add multiple worksheet into one, so that we do things much quicker and easier. But I messed it up at the end, I tried to search in Google, but the result are mess and some of them are complicated when they showed me how to do, and I didn’t want to read or watch it. It’s useful and I found your lessons are in progress and step by step, so make us easy to understand how it works. Perhaps you can share some formulas with us how to deduct and calculate in Excel? I have this issues for long time.

    Have a nice day, stay safe

    • Hi Ling,

      I can completely understand. Finding information online from various sources can be complicated and daunting. I would advice to stick to what is easier for you to understand and follow.
      I’m glad to hear you found my video lessons easy to understand and follow. I have already made a video on subtraction. You can check it out here: https://lifestyletipsandhacks.com/lesson-3-simple-subtraction-formula-using-excel

      I have many more videos coming up in the near future such on Microsoft Word, PowerPoint, Publisher etc, so look out for them if you are interested in these.

      Best wishes

      Habib (ICT Tutor)

  6. Another great tutorial Habib on how to link data and add up cells. I like the second option to do this where you can hold down the shift key to select all in the worksheets.
    Your tutorials are really great and you explain everything in detail yet in terms which are easy to comprehend.
    Thank you

  7. Hi Habib, this is a very detailed lesson. I’m always confused when doing spreadsheets. Seems like you are very passionate about what you are doing. Good content, keep it up!

    • Hey Sarina,

      Thank you for your amazing feedback. Yes I.T is my passion hence I’m creating these video tutorials to spread my knowledge for FREE.

      Best Wishes

      Habib (ICT Tutor)

  8. Here I am again, finding exactly what I need about Excel right here on your site. You are my Go-To Excel Expert!

    This tutorial was very useful. Many times I find myself using multiple worksheets and I struggle to find a way to add data across all sheets without messing things up. You explained the whole process of consolidating data and replicating them accurately into the spreadsheet. I prefer the “SUM” function as it is easier and quicker than the other one.

    Thank you once again for a great tutorial!

    • Thank you Sasha for such a complimenting comment. I am always here for you, when you need any Microsoft Office skills or knowledge 🙂
      Yes, the SUM function is a lot quicker, I agree. Take care 🙂
      Habib (ICT tutor)

  9. This is incredibly valuable information you are providing here for free. I work in the education sector and I should really brush up on my Excel knowledge as I am often making my administration tasks a lot more difficult than it has to be, simply due to me not having the knowledge on Excel I really ought to have.

    I am for this reason certainly bookmarking this page as it seems that I will be able to learn everything I need to know about Excel free of charge from here.

    • Hi Schalk, thanks for a detailed feedback into how my post will help you out on a practical level with your admin tasks as part of your job.
      If you complete all my free lessons here, then surely you will become quite a pro in Excel and your job will be much more productive.
      All the best 🙂
      Habib (ICT tutor)

  10. Okay, so in my family practice office, I’m one of the people who “knows” excel, and I literally know next to nothing. I had no idea this site existed, so I will definitely be back. I’ve had to try to figure things out on my own, and it’s taking forever. I love that all of the lessons are easily accessible, and you’ve outlined things in a really easy to follow fashion. I wasn’t expecting this – but thank you!! 😀

    • HI Hilary,

      Thank you so much for your lovely feedback and about the overall website. I am humbled to know you are finding my tutorials helpful and easy to find.
      Please keep visiting our site for more amazing contents in the near future.

      Best Regards
      Habib (ICT Tutor)

  11. All this information you make available freely. That is so great, Habib. Good that you have one subject at a time and through your list we can choose which information we need.
    Thank you so much 🙂

    • Hi Hannie,

      Thank you for the compliment and feedback. It’s highly appreciated.

      Looking forward to more feedback as you go through the lessons.

      Habib (ICT Tutor)

  12. I found this so amazing. I am not very good with excel worksheets, and this has helped me get a better understanding. I believe I am going to have to watch some of your other videos as well.

  13. Im not the best with excel but every time you do a tutorial I have a better understanding of how it works. Linking data and adding up cells Has been a massive issue for me in the past. Now I feel more confident trying myself.

    Thanks again and look forward to the next tutorial.


Leave a comment

Share via
Copy link
Powered by Social Snap