Excel Cell Reference: Absolute, Relative or Mixed?

Join 400,000+ professionals in our courses here 👉 link.xelplus.c...
Reference cells correctly when writing Excel formulas. If your formulas are not working correctly when you copy them to other cells, you've probably made a mistake with your cell referencing.
Some cell references might need to be fully fixed, some partially fixed. This is called absolute versus relative cell referencing in Excel. Understanding this concept really simplifies your Excel work.
🔍 What You'll Learn:
Cell Referencing Basics: Grasp the concept of Relative Referencing and see how cell references adjust as formulas move across your worksheet.
Absolute Referencing Unveiled: Discover how to lock cell references with Absolute Referencing, essential for consistent calculations across your data.
Mixed Referencing Mastery: Learn when and how to combine Relative and Absolute referencing for precise and flexible formula adjustments.
Practical Examples: Apply these concepts in real-world scenarios, like calculating yearly totals, quarter percentages, and sales data comparisons.
★ Links to related videos: ★
Check out the full Excel Basics playlist here: • Excel Introduction - L...
★ My Online Excel Courses ★ www.xelplus.co...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
🎥 RESOURCES I recommend: www.xelplus.co...
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel

[@LeilaGharani]

Stay ahead with our Weekly Newsletter. Get the latest insights and updates straight to your inbox 👉 link.xelplus.com/yt-c-newsletter

[@ssoltani22]

This tutorial TRUELY reflects your level of knowledge

[@MyShagZlife]

You are simply an amazing instructor. As a Director of Nursing in this post-COVID19 world, I am required to generate and present copious amounts of data at a moments notice. You have rekindled my love for excel and exponentially improved my productivity. I am actually thinking of starting my own channel ... Excel for Nurse Managers, ... we will see.

[@LeilaGharani]

Best of luck, John!

[@derrickmuturi5343]

Thank you for explaining it so perfectly and in layman terms. I had so much trouble understanding this concept!

[@emmanuellasule5546]

This was really helpful, and i must applaud your calmness and ability to communicate well. Thanks a lot

[@LeilaGharani]

Glad you enjoyed it!

[@julianhurrell6741]

Thanks Leila, this sorts something I was having trouble with. Your way of explaining things is great. You are turning me into a excel nerd.

[@asmaalnumay1465]

I Love how you explain the mixed ref. part perfectly make it easy to understand for me

[@Mr_ELF]

You are one of the brilliant Online Mentor for Excel.
Thank you so much.

[@sunilsingh10]

Audio is completely in sync with your steps. Nicely explained. You are truly a gem. Thanks again. Keep sharing.

[@LeilaGharani]

My pleasure. Glad you find it useful.

[@imranmushtaq7445]

Miss Leila you are using Thoroughly and for me after using the MS Excel for more than twenty years and don't know even this mixed function.

[@Egypt_king6]

Hi mam, great job thanks alot. warm greating from middle east. it was really helpful , confident & simple explaination.

[@cecilia9020]

I hope you will be having 10 million subs✨one day dear eonni~
By the way your voice is very nice and rare🙂Which would make anyone to concentrate

[@andreausa123]

Why is it so great ? thank you very much !

[@reytumarao]

perfect very brilliant discussion madam...

[@saheerk7241]

Hi Leila you are my excel guru always

[@guadalupeaguilera7818]

GOOD JOB LEILA

[@claudegiguere8731]

Thanks for all your excellent tutorials and time Leila, I am learning a lot with you!!!

[@cm_dev]

Great video! Thank you!

[@LeilaGharani]

Glad you liked it!

[@JimChambers]

This just blew my mind and solved a ton of issues I have with writing formulas! I've been getting creative with my solutions, this is a hell of a lot simpler. Thanks!

[@LeilaGharani]

You're very welcome. Glad this helps :)

[@gabrielpineda6595]

The fact that I’m learning more from this video than class 💀

[@AnA-yh2zn]

Wonderful! You solved my problem and saved me a lot of time. Thank you.

[@suniltripathi0809]

Superb easy explanation, Thank You

[@housefambass8826]

Thank you so much

[@jakehenderson4425]

I'm from the U.S.! Thank you! I'm studying for my microsoft excel exam... this helped me! :)

[@rodneynyamutswa5267]

Thanks Leila. Mixed referencing is now clear to me

[@jckim2452]

Thank u for such a helpful tutorial. Now i understand why different types of referencing are used in Excel.

[@devilpuppy1969]

Impeccably well taught. You are very easy to understand and I have learned a great deal by viewing your videos when it comes to Excel, great job.

[@lindsayross2789]

Thank you, thank you!

[@gulshanmcauliffe]

Thank you for such a great explanation of this concept! I would like to mention that the shortcut for Absolute Reference in my computer is Function and F4 buttons pressed together.

[@fatimakamali8699]

Leila jan I wish you had a video for mac users as well.

[@chadstechschool8126]

Cmd key will take the place on the Control key!! Hope this helps!

[@sumanbiswakarma8573]

Loved the way you explain. Concise.Thanks a lot.

[@stacigarrity7471]

This video really helped! Thank you!

[@saumyap07]

Great explanation!

[@davidallen5562]

This individual is brilliant

[@Subhash_VCU]

Coulmns are called by letters and rows are called by numbers, now revisit the video if anyone are confused

[@jeanne85060]

I've always had a hard time understanding mixed references - this is a perfect explanation, thank you!

[@LeilaGharani]

Glad it was helpful!

[@josetorres1019]

Your instruction is so clear and easy to understand. You are beautiful, having a difficult time learning.

[@animeshshaw388]

Thank you mam 💞

[@mohammadkhalilansari3708]

Nice video mam

[@esbi1124]

Hello, clear and simple, as usual. I didn't know that changing the position of the $ can be so important. Thanks again.

[@LeilaGharani]

Glad it was helpful!

[@MakenX5]

I was too lazy to explain implicit/explicit cell referencing to my gf over the phone so I just sent her this link. It's perfect, thanks! :)

[@LeilaGharani]

Haha. I hope she liked it :)

[@amadif1793]

The example with the mixed referencing was very helpful. Thank you

[@LeilaGharani]

You're very welcome!

[@monabarakat7383]

Leila, you are the best of teaching XLS....thank you very much for your valuable efforts :)

[@LeilaGharani]

My pleasure. Glad you like the video.

[@AB-nv8tj]

Thank you very much. Really well explained. And your voice is so calm and composed.

[@victoriacorrea6769]

Thank you for Leila!! Your videos have been super helpful!

[@marsi5683]

Best explainer for me. Thank you.

[@alokkushwaha0]

Thanks Sis, I came from another course where i was having trouble in understanding , so i came to youtube and you explained it so easily, again thank you

[@LeilaGharani]

You are welcome 😊

[@itsmebhoomiarmy7487]

Miss Leila, thank you soo much for this video.. actually because tomorrow is my computer practicals exam.. soo, it's sooo helpful... Thank you soo much 💓

[@LeilaGharani]

Best of luck!

[@itsmebhoomiarmy7487]

@@LeilaGharani Thank you actually and it went well... All thank you you miss Leila. ✨

[@michaelperlow5280]

Leila provides the best concise lessons. Thank you so much for sharing.

[@小朋友-p8o]

Thank you!
very clear

[@djones0105]

very clear and concise explanation. thank you, Leila!

[@nikieberhardt4624]

This was a great explanation. Thank you. مرسی خیلی قشنگ و کامل توضیح دادید 🥰

[@riadzreik]

thank you leila شكرا يا غاليه

[@sumitthakur2241]

The best teacher in the world once again the Pearl from the ocean

[@LeilaGharani]

Oh that is so kind! I'm glad you find the tutorials useful. Thank you for your support.

[@LividLibruh]

Thank you! This explanation makes a lot of sense.

[@SoroushTorkian]

Thank you so much.

[@vitthumaulee5815]

Well organized and presented

[@LeilaGharani]

Glad you think so!

[@dhaniram3580]

Very well explained, Thank you!

[@LeilaGharani]

Glad you enjoyed it!

[@olusolaaladejebi4576]

I think you are a good teacher.

[@lisajackson1077]

Thank god for this lady and her videos. So helpful!!!!!!

[@jibrilkateregga5408]

precise and concise

[@Reggie9875]

Clear and concise. Thank you!

[@gladsonj2333]

Very very clear explanation. Thanks

[@BobNew-n5i]

Great and simple explanation with some very helpful shortcuts

[@charleskidney4279]

This is an impressive and very well presented tutorial

[@markbowker3283]

Very well explained, I have just started learning and your videos have helped me a lot.

[@jivanshusharma2503]

Mam aap bahut acchi videos banati ho

[@cranialzoo]

Yet again, thank you so much!

[@josephkogi4010]

So clear to follow your instruction. I will surely try this in my workplace.

[@kq6042]

Love the way you explain, it makes it super clear! Thank you

[@LeilaGharani]

You're very welcome!

[@kishanbangera8029]

your videos are so good and easy to understand thanks Leila for making such incredible excel knowldege videos

[@gregmilka7452]

You. Are. Awesome. You just saved me a ton of time!

[@samuelkodjoe1645]

i LOVE the way you think!!........that was really helpful!!!

[@ΧρηστοςΝικολακης-ω4γ]

Thank you so much that you make it clear to me, i am attending a course but still i could not get it thank you so much and i hope to have a happy new year :D

[@neranjankarunaratne1690]

Hi Leila, Have you a lesson absolute table formula ?

[@balrajvirdee1087]

You are amazing!!! Best explanation ever!!!

[@cuanhundermark4107]

Can't believe I didn't know about this! You just saved me so much time, thanks!

[@steeldove4333]

Excellent!!! Thank you for explaining this so well!

[@dylanhauke9643]

Applied this to GSheets, great lesson!

[@niks1298]

oh god, you just made me realised that I wasted days in manually changing cell referencing in my reports whereas it could have been simply done in minutes through mixed referencing.

[@LeilaGharani]

Hope it will come in handy in the future :)

[@niks1298]

@@LeilaGharani
Absolutely, I am already using it. In fact, I saw some of your other videos on excel and really it is a great help.
The best thing is your explanations are simple yet effective and relevant. Keep up the good work.

[@Heredia1973]

Thank you, Leila! I love your videos!!

[@ckokse]

Must know for every Excel user. Thanks for sharing!

[@LeilaGharani]

Very true! and you're very welcome :)

[@pfuhad3760]

Learned 3 things from this video
Alt + = gives sum
F4 for absolute referencing
$ for things to be fixed in absolute referencing

[@sandeepreddy7687]

Thanks for your brief and easy understanding of these important stuff. Your lessons are really informative thanks Leila

[@LeilaGharani]

Thank you very much Sandeep for your support. I'm very happy you find the videos informative.

[@BurgerKingFootLettuce]

Tommorow is my computer exam and i just saw this video
It helped me a lot
Thanx Leila

[@LeilaGharani]

Oh! Wish you all the best for your exam :)

[@RAJINDRANSILVERA-y8w]

Very good explanation. Understood. Thank you

[@timmer693]

I love your instruction. Thank you for your detail while keeping it simple.

[@yaniramonge2895]

Thanks Leila! I love the way you explain. It makes everything much easier. A question now, how do I use mixed references in an Excel table?

[@aaryanshabir6471]

Thanks Leila, Excellent Tutorial

[@exclusivelyeso7261]

Wow you made this so easy to understand

[@radhekrishna2938]

This really helped me a lot for understanding this! Thankyou so much ❤️

[@education4949]

Awesome presentation , easy to concentrate

[@LeilaGharani]

Glad you think so!

[@_aidid]

So simply explained! Thanks

[@christellelafrance3706]

Thank you your Courses are very helpful.

[@renusarvaninaveen1407]

such an informative video it was quiet helpful for my exam ❤

[@LeilaGharani]

Glad it was helpful!

[@prabhkahlon503]

Thanks a lot. I was struggling with the references for quite a well and by watching your video helped me to identify different types of references...Thanks again, madam.

[@LeilaGharani]

My pleasure. I'm glad the video is helpful.

[@sumonmondol47]

Thanks Leila for nice explanation.

[@JJ_TheGreat]

Can you do an example in which the row has to be fixed, but the column needs to change? Thanks.

[@Toby_Lehman]

I've needed this for a few months now....Thank you so much.

[@LeilaGharani]

Glad I could help Kevin!

[@gsa6186]

You're my hero!!!!!!!!