How to Navigate Like a Pro In Excel | No Mouse Excel

You can use Excel without a mouse! This tutorial will show you how to navigate around Excel very quickly and efficiently like a pro, including how to pop in and out of cells, select blocks of cells, select, add and delete rows and columns, switch between worksheets and even teleport with the F5 key.

[lee]

Wish I could insert that comment without the mouse :)

3 years of learning excel and to me, those are by far the best Excel videos on youtube!

Just keep posting, it's just a matter of time till the right person or a corporate will find them and spread them between all employees. Those are too good to stay silent.

Thanks

[LazypunK]

the F2 saves my life. no need to double click cell. thnks a lot

[gothampartners]

Thank you so much for this video! Very useful stuff and I know that you already saved thousand hours of my life with these shortcuts! Also love how you show the keyboard and the shortcut keys on the right side! Hope there will be other videos soon as your last one was 6 months ago.

[thesystem]

Good job man, I'm enlightened through your video

[javiolonchelo]

Great video! Learned some good tricks, thank you!

[wchriswelch]

loving your content but the music is quite difficult to bear.

[godglobalobservationdevice]

should be thankful to the guys who made the mouse

[Seftehandle]

Also great one ctrl page down/up (no alt) and ctrl esv

[nihalgoel]

Yes brother loved it make more like this

[anandbiswas]

Thanks a lot sir. it will help me sure...

[agustinmardones]

Great video! Thanks for your content, im looking forward for one special shortcut regarding F2, where in google sheets you can go directly to the cell you are editing and move it as you like (press 1 time F2 start editing just as here, hit F2 in the cell, such as Teleportation but not using the F5 key)

Maybe is not the best explanation, but right now im using back excel and it is something im missing so much from google sheets haha

If you are aware of it please let me know!

[ianwatson]

This is awesome. If you have any more tricks on navigating without a mouse it would be greatly appreciated.

[HK]

in 6:47, how did u get the blue arrows across. what keys did u press for doing that?

[FranzTraininand]

This is amazing! Do you think you could do a finance for excel basics video? Thanks a lot! Subbed

[kelvinliu]

Hello, what should you do when you accidently select multiple tabs by hitting "Ctrl+Shift+PgUp/Down" together? How do you jump out of it by using just the keyboard? I know you can right click the mouse to "ungroup" it, but is there a way to do so by using just the keyboard? Thanks.

[jesusisthetruth]

What keyboard do you recommend for heavy excel use?

[Bored_Trumpet]

Some of this is useful. However I really wish my fingers could stay on the home row keys, like in Vim. I can use ENTER/SHIFT+ENTER, and TAB/SHIFT+TAB, but it only works for navigating, not selecting.

[debqmev]

Only ever worked with Mac and tried not using the touch pad and it seems not possible since there's no ALT alternative.
Question: did you learn this at uni or somewhere else or at the job? Because i'll be starting a new job that uses a lot of Excel and i'm kind of worried haha

[meenasaravanan]

Great video.. Just a suggestion..Pls keep the music little low.. It's overriding your voice..

[shrikantharer]

how to fix range in formula without f4 button ?