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
- [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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.