Excel: Relative and Absolute Cell References

In this video, you’ll learn the basics of using relative and absolute cell references in Excel 2019, Excel 2016, and Office 365. Visit edu.gcfglobal.... for our text-based lesson.
This video includes information on:
• Creating and copying formulas using relative references
• Creating and copying formulas using absolute references
• Using cell references with multiple worksheets
• Referencing cells across worksheets
We hope you enjoy!

[@ceciliapalomo6457]

Finally someone who knows how to communicate well!

[@JustSimplyMatt]

This makes so much more sense than the way my class material was trying to explain it. Thank you!

[@theballereli]

EXACTLY. Also helps when you're a visual learner

[@yusufdadkhah7561]

@@theballereli true.

[@psonthebeat7614]

nerds fam

[@griffeycuprynski2995]

my class just linked this video lmao. paying thousands of dollars for an education I could get for free

[@shaktiexports4717]

nice!! vid

[@brannonchatham2143]

Short & Simple and to the point, GREAT refresher!!!

[@GCFLearnFree]

Glad it was helpful!

[@DrMcGuireWU]

Thank you for reviewing this distinction. And, for those interested, the shortcut key for toggling between absolute and relative references is F4 on a PC.

[@bobbytrap2554]

the hero I was looking for, it is so tedious to have to the dollar signs for 5 values in a formula

[@hafsahsiddiquah3526]

I honestly HATE computer but this made me really clear. Thank you so much!!
*Edit*: I meant the subject computer, lol.

[@velona509]

Excellent. Very well explained.

[@uraibasif8053]

Thx, this is gonna help me in my exam tomorrow

[@3sisters49]

You explianed it very well with very easy... Thank you so much

[@nattyasrat2078]

you are a life savior. Thank You.

[@radu0505]

Excellent Video - Exactly what I was looking for. Thanks !!!!!

[@quinnjacobs7260]

Thank you for the chart that explains each type of absolute value. Very helpful!

[@bernadettedoh9445]

Thanks so much

[@eveline9530]

Simple uncomplicated example! Thank you

[@alleefattah8045]

Very Very Beautiful explanation ever !! Thank you so much

[@josec439]

Loved the explanation, made it real easy to understand. Thank you!

[@vladislavbarbarii2089]

perfect explanation

[@LuckyundGacki]

omg most helpful tutorial ever. got it. thanks.

[@Wong2k]

Very well explained. Thanks for making things very visual.

[@ahmedferdous2433]

Very nice..Precise and "as a beginners want"

[@sahelikayalmolykayal4907]

Thank You so much . Such a great , brief explanation 😀

[@debjitmajumder1405]

Brilliantly explained !!!!!!

[@GCFLearnFree]

Thank you!

[@karolinerobinson43]

Very helpful! Many thanks.

[@beezhangholizadeh-anzabi7840]

WATCH THIS VIDEO. Very helpful and straight to the point, ty!

[@rakeshmehrotra8837]

Excellent I understood it very well pls make more videos on formulas of excel class 7

[@oraclesolutions8592]

Awesome video got some clarity on cell referrences.

[@GCFLearnFree]

Glad it was helpful!

[@jaypandya4047]

Thank you so much very nice and easy explanations

[@kevinpinto9082]

Thanks for sharing very well expalined !!

[@amirusewmin6318]

You are very good at explaining

[@l4rjy]

Brilliant!

[@allsmiles3281]

Very professional and concice! Thank you

[@munirahkabir8082]

Thanks, this video was really helpful! ☺️

[@GCFLearnFree]

You're so welcome!

[@clarissar6911]

Great explanation!

[@westfield90]

So well explained

[@abhishek7417]

beautiful explanation . thank you so much.

[@gabrielthemessenger]

Outstanding Tutorial, Thank you so much!

[@TheO_siddiqui]

Reallu helful! Keep it up!!!

[@shadishadi9410]

Really good vedio pleas keep up on good work

[@shahzaibzafar629]

Brilliant explanation

[@Son0fFalse]

Thanks very much!

[@GCFLearnFree]

You're welcome!

[@Simar09]

Really helpful 👍🖤...

[@srinivasak3869]

Thanks a lot! It helped me so much

[@keefs41]

Thank you for this vid. it really helped a lot!

[@nasibrahman9]

Really helpful video. Keep up the good work!

[@motakuw_2906]

Smooth and efficient, thank you!

[@alexfeher4402]

Nicely explained!

[@floydmartinauman1368]

thanks for the explination

[@RonTheGod]

you're a lifesaver

[@LividLibruh]

this was really helpful!

[@GCFLearnFree]

Glad you think so!

[@mohasahal1771]

thanks for this concise explanation

[@GCFLearnFree]

Glad it was helpful!

[@kshitijsinha2029]

Thanks a ton. It will help in my exam surely!

[@wilcamacho5074]

THANK YOU!

[@nirmalgharti6971]

Thank you so much

[@kobeb365]

Thank you!!

[@NikhilSharma-il1ye]

Great Video!

[@anabel9460]

Thank you this helped me

[@GCFLearnFree]

You're welcome!

[@faridagaber4860]

very useful . THANK YOU

[@GCFLearnFree]

You are welcome

[@Tarmedy]

Thank you so much!

[@bluejay8411]

THANK YOU SM! :)

[@GCFLearnFree]

No problem!!

[@yoyocr2034]

thanks

[@bbossin]

Just what I needed!

[@floydmillar2875]

Fantastic presentation. thanks so much

[@GCFLearnFree]

Glad you liked it!

[@shalloh3201]

wow how do you explainn so well thanks

[@ezauramarule]

Thank you so much♥️🙏🏾

[@GCFLearnFree]

No problem 😊

[@MrRottensalad]

Thanks!

[@sangeetayadav2297]

Tysm💞 :)

[@CraftyShawn]

Thks for sharing you solved as problem I was having with keeping the one variable stationary

[@faresd2570]

Perfect thanks

[@nasridryden3775]

ty

[@calebdrobnick4874]

Perfect

[@marthagomez4103]

Thank you so much for the different examples!

[@GCFLearnFree]

Glad it was helpful!

[@BabaGhazi]

Thanks

[@mochaticha5944]

Best explanation ever! Thank you

[@hazelpablo6063]

you are awesome

[@mrmoe5272]

2:50 Table is useful

[@rifatislam5836]

Fantastic 😎

[@GCFLearnFree]

Thank you! Cheers!

[@214sioeh]

👍👍👍

[@muhammadnazmulhasan4613]

Good job

[@jonathanorellana3924]

If the worksheet name do not have a space do you still need to put the single quotation marks?

[@dr.smitadubey267]

Nice

[@bktiwari6230]

make video on virus mam

[@Understandingtgescience]

Good

[@vemulasrikanth4460]

Super

[@vemulasrikanth4460]

After watching this is very easy to understand

[@sunitamoktan624]

Why did you use parenthesis ?

[@ahmadsafi9]

Thanks a lot

[@AI_Masterpiece_]

Thanks so much!

[@rzparksjp]

Thank you!

[@kebigilemopaye6648]

thanks

[@SrFK531]

Thanks

[@santoshsapkota4579]

thanks