No video :(

Excel Relative vs Absolute Cell References

Подписаться 1,5 млн

Просмотров 56 тыс.

50% 1

Learn the important difference between relative cell references and absolute cell references in Excel. This video explains the distinction as clearly as possible. My entire playlist of Excel tutorials: bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa... Here's the practice file that goes with this video: bit.ly/excelrelative #exceltutorial #excel

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 39

@ellennorris6484 Год назад

After watching several other videos that made absolutely no sense to me, I found yours. Thank goodness! It is easy to understand.

@amalrajraj8942 3 года назад

Brilliant teaching and easy to understand. Thank you so much.

@skiermac4679 Год назад

I got a final tomorrow and watched like 5 videos before this. They all made it confusing and complicated. THis was straight forward and simple. Thank you!

@rilkobholms Год назад

Made simple. Thank you.

@grxlsshalom5526 Год назад

Thank you! Simple clear and to the point. Well done!

@yagoedesdemona 3 года назад

thank you very much! at the same time an Excel lesson and an English review! Greetings from Italy 👍 Bye

@bentonarjun8513 3 года назад

Instablaster...

@ms.t_richardson 2 года назад

This is so clear and helpful!!! Thank you!

@batedordecartas 3 года назад

Always helping us, Thank you so much! 🇧🇷

@ladenise86 3 года назад

Thank you so much for the fantastic example /explanation!

@saozzie 4 месяца назад

So easy! Thanks! I have been struggling 30 years with this.

@nepomucenorubymae3680 Год назад

I love this video! This is so helpful. Thank you!

@crystalflores373 11 месяцев назад

Very helpful. I understand now about why and when to lock columns or rows.

@miracleanyanwu8680 2 года назад

You have been a Blessing..Thank you

@amolpathak199 3 года назад

Very well explained.! Thanks..

@kclo2278 Год назад

This was a great video. Thank you!

@suleimanshaik 3 года назад

Thanks a million.

@JaxMchunu Год назад

thank you - I understood cell references better because of it! :)

@saravananganesan1086 3 года назад

Very useful video

@isholinda1268 10 месяцев назад

Excellent explanation!👏

@adeltarakan7978 3 года назад

that really very good

@AMUDHASUBRAMANIAN Год назад

Thank you

@aabbe762 6 месяцев назад

Thanks ❤

@simoiyahector-morales3781 3 года назад

Can you teach mixed cell reference as well. Thanks for this vid

@deebaxley7800 3 года назад

Another great video. Is the "absolute" formula also called "fix a cell"? Thank you!

@hamidghawsi5890 3 года назад

Hi thanks for helping us plzz guide us how to type math formulas like x y and others

@cgr1825 3 года назад

At minute 8:34 you said to tie down the cell you need an * but you meant to say you need a dollar sign

@cycleSCUBA 3 года назад

I noted that too.

@user-mu2cp2uw9z 3 года назад

Finally!

@mazhar939 3 года назад

Can you do guide videos on LIBRE OFFICE application softwares like (libre office impress,calc,base,writer etc). I think you may consider this comment and make videos on these soon bcz I’m a subscriber of your channel and I liked 👍 most of your videos 😇. Thank you 🙏

@argawshewkena7209 3 года назад

Helpful and easy to catching thank you

@earthsteward9 3 года назад

Takako liked the first amount owed to them

@newtotry 3 года назад

Hello is there a way to do relative references with worksheets? Let's say that I want to reference a total in A1 in worksheet May to a carryover total cell A1 in worksheet June. I can make the reference to point to 'May'!A1 in June A1 but when I make a new worksheet July and copy the worksheet from June it stays at 'May'!A1 instead of doing a relative copy of 'June'!A1.

@chadstechschool8126 2 года назад

Great question! Unfortunately excel uses sheet references as absolute. There are a couple of workarounds for this, but the easiest would be to show formulas by clicking the formula tab in your ribbon > show formulas in the formula auditing section. Then, use the control + f function to bring open the find and replace tool. Then simply type the old sheet name and replace it with the new. Takes a matter of seconds! VBA would be the other way of accomplishing but much more complex!

@cycleSCUBA 3 года назад

Ooops ! 8:38 you say 'asterisk' instead of 'dollar sign'.

@dwayneseegars1086 10 месяцев назад

Do you create excel spread sheets for a fee?

@BTTFF 3 года назад

Give me the $435,000! NOW!!!! Thanks for the video again!

@geneticist1980 Год назад

Hi, I hope someone can help me. I have 1536 cells I put reference to different cells but forgot to press F4 to Absolute them. Is there any way I can apply F4 to all of them in one go? Thanks