Navigating Within an Excel Spreadsheet
video description
Date: 2022-04-08
Related videos
Comments and reviews: 9
Glenn
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.
reply
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.
reply
Robert
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?
reply
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?
reply
Trilo
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.
reply
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.
reply
Aimee
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!!!
reply
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!!!
reply
Andrew
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!
reply
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!
reply
GP83
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 )
reply
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 )
reply
DaDa
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?
reply
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?
reply
muzzamil
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
reply
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
reply
Naresh
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
reply
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
reply
Add a review, comment
Other channel videos
