How to Use Absolute Cell Reference in Excel

Поділитися
Вставка
  • Опубліковано 16 вер 2024

КОМЕНТАРІ • 66

  • @nicolec.8725
    @nicolec.8725 11 місяців тому +5

    Thank you so much! I have been trying for days how to absolute cell reference for my class. Lifesaver!!

  • @BeenaDevarajan626
    @BeenaDevarajan626 3 роки тому +12

    Thank you so much, I was struggling to finish my assignment. this video was so helpful. the presentation was simple and easy, anybody can understand, I watched many videos but it was not detailed.

  • @dhwanitgohel3804
    @dhwanitgohel3804 3 роки тому +4

    Tomorrow is my computer exam and this is helpful. May you reach 10M Subs!

  • @AdnanAli-iz8ln
    @AdnanAli-iz8ln 3 роки тому +6

    Exactly what I was looking for. Thank you.

  • @Strikerfm1
    @Strikerfm1 2 дні тому

    Thank you AI Maria.

  • @bkhudkhudia
    @bkhudkhudia 3 роки тому +5

    Very nice presentation and very easy to understand. Thanks a lot. 🙏

  • @avamarie1059
    @avamarie1059 11 місяців тому

    This helped SO much for my Computer Science class. Thank you for breaking down each step!!

  • @kamarasiakarifa6359
    @kamarasiakarifa6359 8 місяців тому

    Absolutely this is my first time,and the presentation is marvelous and quick to understand compare to others I watched before trying this.thanks.

  • @Yourmom-sq2yh
    @Yourmom-sq2yh 10 місяців тому

    Thank you so much! I’ve missed a few days of school and this was very easy to understand

  • @sachin505sharma
    @sachin505sharma 4 місяці тому

    Very well explained.Thanks

  • @krishnee4939
    @krishnee4939 8 місяців тому

    Thank you, explained precisely ❤

  • @reallymeknown
    @reallymeknown 2 місяці тому

    Very Very Helpful information that is.

  • @teenhaelynn1950
    @teenhaelynn1950 2 роки тому +2

    Thanks a lot! This is really helpful for my studies 🙂❤️

  • @FredrickNaamanGura-tv5fe
    @FredrickNaamanGura-tv5fe 3 місяці тому

    Very useful and more helpful❤thanks alot

  • @papperman38
    @papperman38 2 роки тому

    Thanks. Learned more in a UA-cam video than I did on cengage.

  • @portiakhayingana7086
    @portiakhayingana7086 5 місяців тому

    This is helpful, thank you.

  • @Merrick0001
    @Merrick0001 2 роки тому +1

    F4, that was the button I was looking for. Thanks guys. ☺

  • @Dan-of2qz
    @Dan-of2qz 2 роки тому

    this channel is GOATED

  • @manuurs8714
    @manuurs8714 5 місяців тому

    Thank you

  • @lourdesvaleriamb3987
    @lourdesvaleriamb3987 3 роки тому +2

    Thank you!🙌

  • @edgarfalculan4743
    @edgarfalculan4743 3 роки тому

    Thank you Ma'am for the lesson learned.

  • @ShabnamKureshi-gp2xj
    @ShabnamKureshi-gp2xj Місяць тому

    Amazing Thankyou very much 🥰🥰🥰

  • @AsifAli-kz1zt
    @AsifAli-kz1zt 3 місяці тому

    Very useful video 😊😊😊

  • @yuriariston-smith2417
    @yuriariston-smith2417 Місяць тому

    Very nice

  • @vulcomryan8360
    @vulcomryan8360 2 роки тому

    Thank you for this video. this is very helpful.

  • @adelsalam9735
    @adelsalam9735 3 місяці тому

    thanks very useful

  • @jaibir8769
    @jaibir8769 2 роки тому

    Perfect man otherwise everybody just told me first how to use keyboard and then come to main topic

  • @neetusinghneetusingh9724
    @neetusinghneetusingh9724 Рік тому +1

    Nice

  • @foreverrcocochenel
    @foreverrcocochenel 2 роки тому

    Very useful! Thank you.

  • @feminico2613
    @feminico2613 6 місяців тому

    thank you so much

  • @kxngmeliokxng
    @kxngmeliokxng 2 роки тому

    Thank u luv

  • @nhlanhlantabanyana1603
    @nhlanhlantabanyana1603 2 роки тому

    Thank you🥺🙏🏽

  • @jonathankayeyi9953
    @jonathankayeyi9953 3 роки тому

    Thanks this was really helpful thank you

  • @noel-maycoulsen6811
    @noel-maycoulsen6811 3 роки тому

    exactly a year later, im watching this for a test. thanks, it helped

  • @IMZZ__
    @IMZZ__ 2 роки тому

    Thank you ma'am

  • @DOITFARRUD
    @DOITFARRUD 3 роки тому

    Very helpful 🙏🏾

  • @cycleSCUBA
    @cycleSCUBA 3 роки тому

    Great explanation 👍

  • @gbeatrice7716
    @gbeatrice7716 3 роки тому

    You save me. 😊 Thank you

  • @prabhatyadav1971
    @prabhatyadav1971 4 роки тому

    Nicely explained miss thanks for post this video

  • @EdgardoDicla
    @EdgardoDicla Рік тому

    Thanks..well explained..

  • @defafa9249
    @defafa9249 3 роки тому +3

    fn +f4 isn’t working

  • @Arooshann19
    @Arooshann19 3 роки тому

    Thank you Mam

  • @alfredsario505
    @alfredsario505 3 роки тому

    Thank you

  • @mposw
    @mposw 4 місяці тому

    Is there a method for setting absolute cell reference in a range of cells containing formulas? Imagine 2 columns of 100 cells. Column A has random dates. Column B has formulas referencing data in different locations or sheets. The data in column B has to remain with its date in column A when sorted. Is there a way to highlight all the formulas in Column B and change them to absolute cell reference or does each formula need to be changed indiviually. For clarification, the sort can not be done until after both columns and 100 cells are filled. Thank you. Jeff

  • @pranalinanavare1123
    @pranalinanavare1123 Рік тому

    thanks🙏

  • @geneticist1980
    @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

  • @subramanirangasamy3320
    @subramanirangasamy3320 4 роки тому

    Super enjoy the lot... love and expect more videos

  • @TicklePickleLover
    @TicklePickleLover Рік тому

    my f4 locks it but it still drags the same answer down
    what do i do

  • @halethornhill-wilson9044
    @halethornhill-wilson9044 Рік тому

    Hello, I followed every step but I don't think my excel is set up to copy the formula to the rows beneath them. Is there a formatting issue I am missing?

    • @halethornhill-wilson9044
      @halethornhill-wilson9044 Рік тому

      When I try to highlight the $c$16 and paste to the rows below, it says "Alert: the data your posting isn't the same size as your selection. Do you want to paste anyways?"

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Рік тому

    Maam laptop mein kisi kre fixed reference plz tell me

  • @thanksforall2677
    @thanksforall2677 Місяць тому

    Fn+F4

  • @Unknown-xe6ni
    @Unknown-xe6ni 2 роки тому

    The teacher I get "Copies from textbook"
    The teacher i want-

  • @miriamart9712
    @miriamart9712 10 місяців тому

    I am using Google Sheets and the formula doesn't transfer to the other cells. 😓 What am I doing wrong.

  • @kushanudarakumarasiri6486
    @kushanudarakumarasiri6486 12 днів тому

    I cant absolute the range one by one.

  • @paveithrachandrasehar7937
    @paveithrachandrasehar7937 2 роки тому

    😌👍👍

  • @ateefrehan6133
    @ateefrehan6133 3 роки тому

    Uno Reverse Card

  • @Log_Among_Trees
    @Log_Among_Trees 2 роки тому

    way to long to explain.....

    • @ninasazonova2511
      @ninasazonova2511 8 місяців тому

      So what? That is great detailed explanation for me!

  • @zXBananaGamingXz
    @zXBananaGamingXz 6 місяців тому

    thank you

  • @renki8333
    @renki8333 3 роки тому

    thank you