From the course: Excel 2016: Tips and Tricks

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Navigate within worksheets

Navigate within worksheets

From the course: Excel 2016: Tips and Tricks

Start my 1-month free trial

Navigate within worksheets

- [Voiceover] We're looking at a worksheet called HR List in our chapter four file and maybe we've never seen this worksheet before. We want to know how big it is. Now big we don't mean counting bits and bytes, but how much space does this take up in terms of how many rows, how many columns? Not as if we want to count but, how big is this? Get in the habit of pressing Control+End. The reason I'm saying that in that way is I don't mean Control+N meaning the letter N but the E-N-D key Control+End. In any worksheet when you press Control+End, the active cell moves to what we might call the lower right hand corner of the active part of the worksheet. It doesn't always mean that it ends up in a cell that has data, but when you press Control+End you can say with authority there is no data anywhere in this worksheet below row 742 and there is no data anywhere to the right of column K. You can be sure. If you'd like to go to the upper left hand corner, Control+Home. Nearly always this means…

Contents