Hi, this is Wayne again with a topic “Navigating Within an Excel Spreadsheet”.
In this article tutorial we’re gon na look at an issue that comes up in Excel sometimes, and that is how to navigate around a huge spreadsheet. So we can all deal with a small spreadsheet, let’s say there’s 10 or 15 records in the spreadsheet. It’S easy to kind of move around and keep track of the data, but what about when you get hundreds of these records or thousands? Even it’s easy to kind of lose track of the data where it is and how to get to different parts of your spreadsheet quickly, and so, let’s look at a few options that you have. The first thing I would point out is over here in the lower right corner. We have a view zoom level and for me right now, it’s set to be two hundred and thirty five percent, but I can just click and drag on this bar to make it much smaller, and so I can quickly get a sense of the data in my Spreadsheet now you’ll notice, when you do that, look what happens to some of the data if the data doesn’t fit. Naturally, in the columns you’ll get these pound signs. Don’T worry about that.
The data is still good and watch as I go bigger again zoomed in more those pound signs disappear. So that’s one thing you can do to get a sense of your data. How big it is where everything is just change that zoom level.
Now there is another way to do the same thing, and that is by holding the ctrl key on the keyboard and then using the scroll wheel on your mouse. If you scroll up it zooms in if you scroll down on the scroll wheel, it zooms out – and you can see it’s adjusting here as well next, let’s look at how to jump from maybe the top of your spreadsheet down to the bottom. So here I am pretty much at the top of this spreadsheet and I’m looking at the information looking at the data, but now I’d like to get back down to the bottom of the sheet to enter more information. There’S a couple of ways. I could do this. One is to use a keyboard shortcut if you hold the ctrl key and then tap the end button.
It takes you not only down to the bottom of your spreadsheet, but also to the right edge. So the bottom right corner of the range of your data and that worked beautifully for me now. What if I want to get back up to the top there’s another keyboard shortcut for that and that is hold ctrl and tap the home button.
And that takes me to the upper-left corner. Now there is another little-known way to do a similar thing. Let’S say I’m here in column G and I would like to get down to the bottom of the spreadsheet, but I don’t really want to go to the bottom right corner, so I’m not gon na use control end. I just want to get to the bottom of column G watch, this I’m gon na increase the zoom just a little bit so that you can see this better but watch this technique. All you have to do is go to the bottom edge of the cell. That you’re in at the moment, put your mouse right there on the bottom edge and then click twice fast and that quickly it took me to the bottom of the spreadsheet. Now, if I want to get back up to the top in the same column, I just double click on the top edge of the cell that I’m currently in, and it takes me up to the top. So what a beautiful, simple and elegant way to get to the bottom of a spreadsheet and also to the top of a spreadsheet very quickly by double clicking and, as I pointed out earlier, it keeps you in the same column that you’re currently working in the last Technique – I’d like to show you is, let’s say, as you’re zooming in zooming out, jumping to the top to the bottom, maybe the bottom right corner of your spreadsheet. Let’S say you get to a point where you find that you want to just work on one section: one range in your spreadsheet at the moment. Maybe just this part, that’s what I want to work on now. I can click and drag to highlight it, and then I can go up here to view and I can choose to zoom to selection. Let’S see what that does it maximized the view so that that section that I highlighted is zoomed in as much as it possibly can be? Now, if I had chosen a different part of the spreadsheet and click to zoom to selection, you can see it’s much more dramatic, so those are three or four tips and tricks that you can use in Microsoft Excel to help you move around your spreadsheets, especially big Ones, and that can help you to see the data and navigate around the data a little bit better and easier thanks for watching.
I hope you found this tutorial to be helpful. If you did, please click the like button below and consider connecting with me on my social media accounts like Facebook, Pinterest and Twitter, and definitely do subscribe to my youtube channel for more videos about technology for teachers and students, and when you do, please click the bell. Next to the subscribe button that way, you’ll be sure to be notified whenever I post another video and watch for another video from me at least every Monday. If you’d like to support my youtube channel, please consider becoming a supporter of mine through my patreon account and you’ll find a link to that in the description below .