Navigating Within an Excel Spreadsheet

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

To get to the bottom of the same column, you can also use the keyboard shortcut Ctrl + Down Arrow. Vice Versa to get to the top. Horizontally use your right and left arrows with the Ctrl command. Thank you!

andrewjohnson
Автор

Thank you! It was a novelty - to get to the bottom of the table with a double click.

elinat
Автор

Oh yay!!! The "double click on the cell" tip was unknown to me and very helpful. I typically have used the CTRL and arrows. THANK YOU :)

DipsyDoodleDaisy
Автор

A couple of great tips here. The double click option, either up or down depending on where you want to go, is a great tip that I'm using now as I have a large spreadsheet that has over 1, 900 records. It's very useful! I accidentally discovered if you hit the ctrl key along with the up or down arrow keys, you can go up or down to the top or bottom of a tab's contents as well but I prefer the double click option. BTW, it won't work when you have freeze frames on.

GlennReschke
Автор

Double-tap to zoom up or down was new to me. Thanks for sharing!

donfillenworth
Автор

From TechnTransit community and TechWithKhalid, we say thank you.

AyodejiLawal-kc
Автор

Great tutorial !!! I just wanna give a little tip. If someone wanna go to down or up in one column there is one more way and that's using the keyboard keys page up ( PGUP) or page down ( PGDN )

gotse
Автор

Your'e doing such a great job i am not a good English speaker and listener but everything in your videos is clearly understandable for me it helps me a lot. Thank you

muzzamilmehmood
Автор

Another useful online lesson, thank you

kokokokalisi
Автор

Once again a great video with good content.
I already look forward to the next one.

DCR
Автор

This is great. Thank you for sharing great content!

henrydaquipel
Автор

Thank you! This tutorial was just what I was looking for 😊

Marnie
Автор

Omgoodness how did I not know about clicking the top or bottom of a cell to move to top or bottom of sheet?? No wonder I would suddenly end up in odd places and thought it was Excel trying to be funny!!! Thank you!!!

livinginlalaville
Автор

This is great! saved me a lot of time. Thank you for sharing great content!

jasonchan
Автор

Great Shortcut, in the same way if we double click on left and right side of the cell we are navigating to the left most and right most point of our data

thistime
Автор

Hi, Thank you for your videos. I got a job recently and am learning a lot from your lectures. Powerful lecturing
Is there any keyboard shortcut for jumping in the middle of the column?

dadada
Автор

I think you could also use the Page Up/Down keys from the keyboard to move up/down a column really quickly.

purplecrayon
Автор

I like the double click on the edge of a cell to quickly jump to top/bottom/right side/left side. However, I have seen it bug out sometimes. I'm trying to use it on a slightly busy template and it works inconsistently. On a plain old spreadsheet I've made myself it works great.

trilodroid
Автор

is this working with a MAC ? because i'can't
Great jobs btw, u rock man !!!

loickpouget
Автор

I really like your vids. May I have the large spreadsheet?

macmsk