Navigating Within an Excel Spreadsheet

Рет қаралды 92,787

Technology for Teachers and Students

5 жыл бұрын

Learn how to quickly and efficiently navigate within an Excel spreadsheet by using some keyboard shortcuts and other Excel features. When working with a large spreadsheet, it can be easy to get lost or to have problems quickly getting to the end or beginning of your spreadsheet. These Excel tips and tricks will help you out with this issue. #excel #exceltutorial . ***Consider supporting Technology for Teachers and Students on Patreon***: www.patreon.com/technologyforteachersandstudents Here's the link to a practice file for this video: bit.ly/excelalignment

Пікірлер: 41

@andrewjohnson9437 3 жыл бұрын

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!

@livinginlalaville 2 жыл бұрын

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!!!

@DipsyDoodleDaisy Жыл бұрын

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 :)

@user-lz8xu6to4k 10 ай бұрын

From TechnTransit community and TechWithKhalid, we say thank you.

@GlennReschke 4 жыл бұрын

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.

@Gocep83 5 жыл бұрын

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 )

@donfillenworth1721 5 жыл бұрын

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

@henrydaquipel8700 5 жыл бұрын

This is great. Thank you for sharing great content!

@muzzamilmehmood2413 5 жыл бұрын

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

@13DCR 5 жыл бұрын

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

@Marnie67854 2 жыл бұрын

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

@zoed.473 5 жыл бұрын

Love it thank you so much!!!

@21016thistime 2 жыл бұрын

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

@jasonchan8793 3 жыл бұрын

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

@kokoko6kalisi 4 жыл бұрын

Another useful online lesson, thank you

@trilodroid3628 5 жыл бұрын

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.

@purplecrayon7281 5 жыл бұрын

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

@padynz9869 Жыл бұрын

Excellent video!!

@dadada9653 5 жыл бұрын

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?

@user-dn9cf1dh2m Жыл бұрын

thank you.

@LifestylewithSharon 3 жыл бұрын

Very helpful

@Howtoexcelatexcel 5 жыл бұрын

Great video good skills to learn

@yashchowmal821 3 жыл бұрын

Thank u so much sir

@lightlife917 5 жыл бұрын

Excellent

@Tri-Stone 5 жыл бұрын

thanks

@loickpouget5416 4 жыл бұрын

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

@TheArtfullWesman Жыл бұрын

Thanks

@TheArtfullWesman Жыл бұрын

Just got an analyst job and your videos really helped me prepare for the test I had to do💚💚💚

@techteachersandstudents Жыл бұрын

Thank you for your kind gift. I really appreciate it!

@techteachersandstudents Жыл бұрын

I'm so glad you found my videos to be helpful.

@elaizahthotngayai1228 5 жыл бұрын

Can anyone teach me preparation of table on MS Excel with use of formula

@kruka86 5 жыл бұрын

Can you tell me how to do it on Mac? my work provides me with Excel online

@macmsk 3 жыл бұрын

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

@techteachersandstudents 3 жыл бұрын

Here's the link to a practice file that you can use for this video: bit.ly/excelalignment Thanks for watching!

@macmsk 3 жыл бұрын

@@techteachersandstudents thanks a lot

@RobertMcSorleyJr 5 жыл бұрын

I have an Excel question, how can I copy exactly everything on one tab to another. for instance I'm doing fire extinguisher inventory and I'm trying to copy the exact layout from the month of October to the month of November, but November will be a different tab. can you show a small video about that please?

@erictorrez1913 5 жыл бұрын

Go to file top left corner, click save as, choose another or same file, change date, then clear date off of new sheet. Your now ready to input new data

@erictorrez1913 5 жыл бұрын

Clear data off new sheet*

@k_bv 5 жыл бұрын

Right click on the Sheet tab and then you can choose to Copy Or Move.