Excel Quick Tip: F4 for Absolute Cell References

Поделиться
HTML-код
  • Опубликовано: 11 сен 2024

Комментарии • 35

  • @beamaze4977
    @beamaze4977 2 года назад +2

    Thank you for making it simply and understandable..

  • @Carla369
    @Carla369 Год назад +1

    Thanks!! happy to see someone explaining that using the f4 !! I didn't know it and sometimes you have tables with many many cells to modify quickly

  • @georgeelliottphotography3602
    @georgeelliottphotography3602 8 месяцев назад

    Brilliant thanks. That's exactly what I was looking for. I also didn't know about double-clicking the '+' in the bottom right of the cell would auto-populate the rest. Super, many thanks again.

  • @blackhole99913
    @blackhole99913 Год назад +5

    Do I need to hit ctrl + f4?
    Simply pushing f4 isn't adding the dollar signs

    • @skip031890
      @skip031890 7 месяцев назад +7

      If you're using a laptop, then you need to press and hold the "fn" key at the bottom of your keyboard along with F4.

  • @susuvekerekere563
    @susuvekerekere563 2 года назад +2

    Thanks for being simple and easy to understand video, especially on relative and absolute cell references.

  • @lawrencekazibwe9751
    @lawrencekazibwe9751 2 года назад +1

    Thanks Boss, very resourceful

  • @devjichawda9091
    @devjichawda9091 3 месяца назад

    Thanks for your information.

  • @_askb.
    @_askb. 3 месяца назад

    Thank you!

  • @seemasharma-ss03rc
    @seemasharma-ss03rc 2 года назад

    Very well explained this useful tip👍👌

  • @abyssal8722
    @abyssal8722 Год назад

    you're a legend tysm!!!!!!

  • @RajSinghPasha1378
    @RajSinghPasha1378 Год назад +1

    I am pressing f4 but it is not working.

  • @mikegee902
    @mikegee902 4 месяца назад

    Thank you

  • @HamdanYouTuber
    @HamdanYouTuber 2 года назад

    Thanks for sharing

  • @winvest9261
    @winvest9261 Год назад

    bro teaches the teacher! haha! Good job

  • @harrytse4239
    @harrytse4239 2 года назад

    thank you, amazing!

  • @DM-kd3yt
    @DM-kd3yt Год назад

    Excellent.

  • @sulemansiddiqui3027
    @sulemansiddiqui3027 2 года назад +8

    the F4 on my laptop doesnt work

    • @jackiec3919
      @jackiec3919 2 года назад +8

      theres should be a fn key on your lap top hold that down while pressing the f4 key

    • @ashley2705
      @ashley2705 Год назад +1

      Thank you so much for this

    • @victoriapierro7283
      @victoriapierro7283 Год назад

      @@jackiec3919 THANK YOU SM

    • @gradimukwasa1386
      @gradimukwasa1386 Год назад

      Press the fn key on your keyboard then press F4 it will work

    • @HAJSTU
      @HAJSTU Год назад

      ​@@jackiec3919
      Thank you !

  • @hanazenabu7778
    @hanazenabu7778 2 года назад

    I have a name list of an Employee and he got promoted, however the birth date is not the same as before. how can I make excel prevent entering different birth date again?

  • @aishabagigah7892
    @aishabagigah7892 2 года назад

    Hello Could you do a video using SAP software?

  • @bengelinemetantin8272
    @bengelinemetantin8272 Год назад

    How about here in Philippines?? We used PESO..
    PESO SIGN WILL BE USE IN THE FORMULA??

  • @Journeymane
    @Journeymane 2 года назад

    Hello sir, how can we schedule one item per day data entry from one excel file to another blank excel file? The source excel file has single column entries only, in Google excel sheet.

  • @naderthomas690
    @naderthomas690 Год назад

    I tap F4 and my screen options pop out from the right side of my screen. Is there an alternative way to do this?

    • @lucka6576
      @lucka6576 Год назад

      Did you find the answer???

    • @skip031890
      @skip031890 Год назад

      It depends if you're using a laptop keyboard or a desktop keyboard. Function keys don't work properly on laptop keyboards. You need to be using a desktop keyboard.

  • @madhushree8263
    @madhushree8263 9 месяцев назад

    Why is my f4 not working😢

    • @skip031890
      @skip031890 7 месяцев назад

      Press fn on your keyboard and then F4.

  • @slartibartfass5729
    @slartibartfass5729 Год назад

    Pretty low salary for your sales people. The janitor gets more...

  • @vanjennifer48
    @vanjennifer48 2 года назад

    Thank you !