How To Access Excel F Keys on Laptop Computer - Huge List of Function Keys too - 365 MECS 01 Part 2

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

КОМЕНТАРІ • 119

  • @excelisfun
    @excelisfun  2 роки тому +9

    Teammate Richard Hay reports: the laptops Razer (windows) requires Shift + ESC to switch F modes. P.S. He said that Apple requires the same.
    Teammate Patrick Schardt reports: If you can access your computer’s BIOS, there’s usually a setting somewhere that changes the behavior of the fn key.

  • @GeertDelmulle
    @GeertDelmulle 2 роки тому +8

    Hold on, Mike, not so fast: it depends on the model laptop you’ve got.
    Look at the ESC key on your laptop: it’s got a few extra indications on it.
    On my HP laptop (from work) it is the LEFT SHIFT key that has that extra indicator for toggling the Fn lock.
    So, in general you have to look for that extra indicator.
    I sent you a picture.

    • @excelisfun
      @excelisfun  2 роки тому +4

      You are right. Radoslaw said about 95 % ; )
      LOVE the indicator tip!!!!

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

      Thanks for the indicator tip. 👍👍👍👍

  • @ExcelInstructor
    @ExcelInstructor 2 роки тому +10

    Hi Mike and The Team,
    1st thank you for the mention in your video - I feel truly Honored :)
    Yes my expierience was based on my work on company laptops.
    Lenowo, acer, asus, some HP's and with all of them it was ESC+FN, but trying to be reasonable I figured not ALL of them have to be FN+ESC so i typed 95% :) since i never met other combo laptops I only knew they must exist :)

  • @jidduv
    @jidduv 2 роки тому +5

    Omg. This has been driving me crazy for 2 years. Thanks Mike

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

      It has been driving me crazy for last 10. Lucky we have a great Team. Thanks, Radoslaw!!!

  • @mr.brownstone5716
    @mr.brownstone5716 2 роки тому +2

    Gotdamn I love ExcelisFun! Thanks for this brilliant tip.

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

      I know, Right? It's really our awesome Team : ) I did not know this till Radoslaw pointed it out : )

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

    Nice laptop Mike....can you tell us what brand it is and model?

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

      The funny thing is: I don't even know what type of laptop it is. I just checked it out from my work and whatever they give me, I just use. I just looked and it says Dell Computer. Not sure what model lol

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

    I guess I am lucky enough to have a laptop where I can use F1, F2... without the the need to use FN. I only need the FN key if I want to adjust volume, brightness , switch screens, turn off the webcam... It's exactly the opposite setting to what your (most?) laptop(s) has (have)...

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

      Sounds like the laptop computer I wish that I had lol

  • @LeviClark-ql2lu
    @LeviClark-ql2lu Рік тому +1

    I have a newer Logitech Ergo Keyboard that has shared media/function keys and there is a FN Lock key (FN with a padlock symbol) over to the right of F12 that toggles the Function / Media keys.

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

    Woah....wait...... hold on........taking a seat....for this one .... 😮😵🤯👌! Thank you Radoslaw!!!

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

      Mike you got me curious, how come on minute 1:39 you don't do F8 or SHIFT + F8?

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

      Thanks, Radoslaw!!!

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

      @@spilledgraphics Because it is too easy to use Shift and Ctrl...

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

      @@spilledgraphics Just a habit to use Shift Click and Ctrl + Click : )

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

    Interesting. Fun fact! Would actually be useful if I owned a LAPTOP. BUT I'm a desktop kind of guy so I will have to enjoy this tip vicariously!

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

      I use a laptop 99.9% of the time too. But now on my trips when I have to suffer through a laptop stint, BAM: got a useful tip from Radoslaw : )

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

      @@excelisfun Actually my stepsons have laptops; one has a Razer (windows) and the other has an Apple. Each of these laptops requires Shift+ESC to switch F modes. I didn't know that until I asked them a few minutes ago!

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

      @@richardhay645 That is a hot tip!!! I am sorry to hear that one of your stepsons has an Apple because he will not have the full Power Query...

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

      @@excelisfun the Apple user into graphic arts so he likes the Apple. Neither have Excel. They let me do theit excel tasks!! Both have side businesses so its a just matter of time till they get 365. I'm sure that the Apple laptop will then get a Windows soulmate!

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

      @@richardhay645 I get it. I started my business back in 90s with a Mac. I loved it and did lots of graphics art. But then soon had to switch to a real computer lol

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

    Great advice is always in the comments section!

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

      So TRUE!!!! What a great Team we have : ) : ) : )

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

    Boom!Radoslaw That's One Super Cool Tip...Thank You Mike :)

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

      Yes: One Rad Tip : ) Go Team!!!

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

    Thanks Mike for this EXCELlent video

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

      You are welcome, Fellow Teacher. Go Team!!!!!

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

    There’s another way to do this. If you can access your computer’s BIOS, there’s usually a setting somewhere that changes the behavior of the fn key, i.e, FN + F2 = edit or whatever the other setting is

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

      Thanks for that hot tip, Patrick!!! : ) Because the keyboard will not work on all computers.

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

      I added a pinned tip at the top with your hint!!!

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

    Very helpful trick 👌❤️

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

      Yes, we are lucky to be on such a great Team!!!!!

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

    Brilliant! I was wondering if there was a toggle but didn't look too much into it, thanks for the hint! :)

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

    That was super helpful Mike! Using F2 to put the cell into edit mode just got much quicker!

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

      So TRUE! Faster for me too with help from Radoslaw : )

  • @shy4real
    @shy4real Рік тому +2

    one of the best persons to exist in this planet, thank u for the videos.

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

      You are welcome for the existence and the fun videos and Excel files, Shy 4 Real!!!!!! : ) : ) : )

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

    One very useful F key keyboard missing from your list:
    How do you get to the Name Box without the mouse?
    not very many users know this shortcut:
    ALT+F3

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

      Thanks to you, Teammate Meni, the list now has it so that the Team can benefit from your cool tip : ) : ) : ) : ) I add it to pdf and Excel workbook.

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

      @@excelisfun
      Thank you for adding me to the team.
      When's the next game?

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

      @@meniporat3527 Meni, You have always been on our Team : ) : ) : ) : ) You have contributed many wonderful tips over the years.

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

      @@meniporat3527 I am not sure what you mean by "When's the next game?" Do you mean "When's the next video?"

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

      @@meniporat3527 I am sorry, but I do not understand what you are trying to communicate. It is probably my fault for not interpreting you correctly.

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

    Good tip, but I can no longer work without my two large monitors, so I use a docking station with normal keyboard.

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

      It is so funny, I also only work at docked desktop, but I am so fluent with Alt Tab that I still use only one Monitor lol So Old School.

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

      @@excelisfun I was that way too, but once I tried two monitors, I couldn't go back to one, especially when you have two view windows of excel open.

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

      @@bagnon I like it: two view windows of excel open. Maybe I have to go two now...

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

    Lol you just want to show off your nice laptop

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

      No, I hate my laptop lol I only use it when I am on a trip. I love my big clunky keyboard on my docked desktop on my desk at home and in my office ... lol^2

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

    On some laptops there's no such option so your only chance is bios.
    Btw, i didn't expect this kind of tip on excel channel, it does make kind of sense, same as how to use shortcuts in excel, but in reality it doesn't, similar to tip about how to remove virus that stop your apps, including excel.. you don't do that..:)

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

      But, Keyboards are almost the #1 tip for efficiency in Excel, so I have to teach it : ) : ) : ) : ) No virus stuff, though lol

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

      @@excelisfun thanks for noticing my comment, I'm a big fan, i learned about outer and inner queries in PQ from you. Very useful stuff.

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

      @@mienzillaz Happy to notice and happy to hang out with you here at excelisfun at UA-cam. Inner and Outer Power Query Custom Functions : )

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

    Sick trick... that drives me bonkers !!

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

      It has been driving me crazy for years too. Lucky we have a great Team!!!

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

    Great tips. Thank you Mike👍👍👍👍

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

      You are welcome, James! Thanks to Radoslaw too : )

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

    Love this, thanks for sharing best as always:), with love from Thailand 👍

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

      Thanks for the love from Thailand! Go Team JB Racing!!!! Go fast and have fun : )

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

      Please tell me what you race : ) Cars? BMX? Running?

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

    WHOA! What laptop ships with the less used hardware controls set to default instead of the more common F keys?
    Seriously How often is screen brightness, mouse on/off, wifi on/of, and screen switch, going to be used?
    Thanks for the tip.

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

      Seriously. It is the same as the stupid checked "Hide Extensions For Known File Types". If 99% of usesers don't want the default, why set it as default...
      You are welcome for the tip. Thanks, Radoslaw : ) : ) : ) : )

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

    Thanks for this Tip

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

      You are welcome, Teammate Santosh!!!!

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

    What a saver! Locking cells was such bummer on my HP. Much appreciated.

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

      This tip helped me a lot too : )

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

    I am using laptop for the last two years. But I didn't know this simple trick. Thank you for sharing the knowledge and for everything you educated us

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

      Me too, I have used laptop for 10 years and did not know this tip until Radoslaw gave it to us : ) : )

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

    wow- there goes my usb keyboard out of the picture. Thanks Mike and Radoslaw

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

      We are lucky to be on a good Team!!!!

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

    Perfect! Clicking fn was very irritating as my keyboard has it on the right side. Now problems solved thanks to Mike

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

      Yes indeed, BIPower, it has been irritating for me also - now solved from Radoslaw's tip : )

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

      @@excelisfun yes thanks to Radoslaw too :)

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

    It doesn't work on my laptop,😌

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

    This was awesome, as always Mike! Happy July 4th!

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

      Thanks, as always Chris M : ) Happy 4th for freedom at UA-cam to make fun and efficiency with Excel!!!

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

    Thank you so much! What is the website for the online community or page for the ExcelIsFun team?

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

    Thanks so much !!!

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

      You are welcome, Awaking Beauty : ) : ) : )

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

    Thank you 🙏

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

    Still didn't work for me

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

    i feel like an ass for not noticing that it literally says this on the fn key........... thanks for the tip

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

      No ass because most of us humans mess this up lol You are welcome for th etip!

  • @Victor-ol1lo
    @Victor-ol1lo 2 роки тому +1

    Nice Trick! Thanks for sharing!

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

      You are welcome, Victor: Thanks, Radoslaw!!!

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

    Fantastic! Thanks, Mike.

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

      You are welcome! It is great to hang out with such a rad team ; ) Thanks, Radoslaw!!!

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

    🙏🏼

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

    good tip i did that from the bios hehehe :)

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

      A number of other people posted about this also. But what does "bios" mean?

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

      @@excelisfun BIOS (basic input/output system) is the program a computer's microprocessor uses to start the computer system after it is powered on. It also manages data flow between the computer's operating system (OS) and attached devices, such as the hard disk, video adapter, keyboard, mouse and printer.

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

      @@sevagjb Thank you for this: BIOS (basic input/output system). But how does it allow for you to change the keyboard assignment? I was thinking that the bios was part of the Control Panel or something... lol

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

      @@excelisfun in any computer on the restart or startup you can access the BIOS ,
      every model has deferent access key ((for example i have dell laptop i can access my BIOS on booting by pressing F2 key))
      you can access some basic functions and you can find there the toggle function key and much more. :)

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

      @@sevagjb Cool. That is very helpful. I will try it : )

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

    Cool! Thanks for the tip.

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

      You are welcome, StaticBlaster!! Thanks, Radoslaw for the tip : )

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

      @@excelisfun 👍👍

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

    Happy 04th July. MIKE

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

      Thanks, Santosh. Happy 4th to you too!!!

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

    Thank you. Good tips.

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

    Mike. I can’t stopping loving your videos. After six years using my laptop and having to use the fn key, I watch your video and needless to say how much I loved it. Thank you.

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

      You are welcome!!!! I am happy to learn this trick too : )

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

    thanks for help me bro