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

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

  1. Understand what is a Relative cell reference in excel
  2. Understand what is an absolute cell reference in excel
  3. The differences between relative & absolute cell references
  4. Know when to use relative & absolute references in a formula before replicating it

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 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel

Or go back to:

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 (£) 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

20 thoughts on “Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!”

  1. Hi, and thanks for the post on relative and absolute references within Excel. I’ve used Excel for many applications over the years and at times it has been totally confusing. That is partly due to the fact that I would busing it for one thing and then another with totally different applications needed. But all in all, the formulas you are showing in the lesson have made simple the very formula set I’ve always had to go back and read the tutorials to understand. But you’ve made it so clear that I just simply get it now! Very simple.

    Great info! I appreciate your help!
    Darri

    Reply
    • Thank you for sharing your experience Darri. I’m happy to be of help to you. Carry on learning, as many more lessons are coming your way. I will try to publish at least 5 lessons a week 🙂

      Habib (ICT tutor)

      Reply
  2. Hi Habib,

    Thanks for this amazing lesson. I managed to follow all your instructions for relative and absolute references.

    I even managed to understand it all the first time, which is quite something, as I find excel really difficult.

    By following all your lessons, I’m really finally managing get a lot better .

    I love the way you’ve kept to one issue in each lesson, that certainly makes everything much clearer.

    Thanks again.

    Reply
    • Thank you and you’re very welcome Judy. You are doing the right thing by going through all the lessons from lesson 1, as the lessons are sequential and everything makes more sense. I have kept all lessons simple and related to one set of skill, which can be learnt easily 🙂

      Habib (ICT tutor)

      Reply
  3. Thanks so much for another very helpful article. It’s amazing how much you can do when you know how something works. Been working my way through the lessons are am definitely able to do loads more with Excel now than when I started. Thanks again.

    Reply
  4. I really enjoyed this article about relative and absolute cell references. I used to do a lot of excel in my last job and I learned this part of excel by watching youtube videos before but I think yours is much easier to understand.

    You will help a lot of people learning excel, so please continue what you are doing. Thank you so much!

    Reply
    • That’s so nice to hear Lemuel, that I explained it better than other videos you’ve watched about relative and absolute cell references – Thanks
      Individuals like yourself always give me the extra motivation to carry on doing ICT lesson tutorials – so I shall carry on always 🙂

      Habib (ICT tutor)

      Reply
    • So, you have learnt about relative and absolute cell references and the differences between them. It’s not too difficult once you’ve understood it fully. Thanks Hannie for your feedback 🙂

      Habib (ICT tutor)

      Reply
  5. Hey Habib,

    I have been using excel a lot in the past as I worked with business consulting and IT security. However, I have not been actively using excel lately so your video was very useful for refreshing my memory.

    Thanks for a great lesson in excel!

    Best Regards,
    Joonas

    Reply
  6. Using Excel is like using magic! It’s amazing all you can do in this platform.
    I’m really glad to be learning all of this as it’s helping me with my business
    accounting.
    Thank you, you are a great teacher!

    Reply
    • You’re welcome Safiyah – I probably will agree with you as my students always feedback to me saying, how easy it is to follow my demonstrations in class, and also how easily they understand everything I explain. I always feel honoured and humbled when someone says these beautiful things.

      It makes me feel I’m doing something good for the world – teaching is most definitely the best profession in the world 🙂

      Habib (ICT tutor)

      Reply
  7. This is a very helpful article for understanding how to implement and use absolute and relative cell references. I struggled with this for years when using excel and it is such a necessary tool if you want to be effective at computing formulas efficiently.
    Thanks for sharing your insight!!!

    Reply
    • You’re very welcome Dan. Remember, relative and absolute references come into effect only if you are replicating a formula or function. You get this wrong and the whole spreadsheet will look a mess and full of errors.

      Habib (ICT tutor)

      Reply
  8. This is exactly what I’ve been looking for, I keep meaning to learn more about Excel but find content either too basic or just plain overwhelming!

    I’m bookmarking this for future reference, and will start at the beginning, thanks for such a good approach!

    Regards,

    Tony

    Reply
    • You’re very welcome Tony. I understand what you’re saying about some contents that’s available online. A lot of people are not qualified in the area they blog or crate contents for – hence they’re poor quality. I’m in the field of ICT and a qualified teacher, hence my lessons show and reflect this.
      Good idea to bookmark our site, now you can watch the lessons as often as you like. We also have a YouTube channel dedicated to my ICT lessons only – check it out 🙂

      Habib (ICT tutor)

      Reply

Leave a comment

Share via
Copy link
Powered by Social Snap