Navigating within worksheets


show more Navigating within worksheets provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts show less
please wait ...

Navigating within worksheets

Within any given worksheet, there are some tips and techniques for moving around the worksheet perhaps faster than simply scrolling or using arrow keys. One tip that I think is viable in any worksheet and almost anytime, particularly when it's relatively new to you, is to get some idea of how big is this worksheet. Get in the habit of pressing Ctrl+End. Not the letter N but the End key. Now, I just pressed Ctrl+End, and the active cell has moved to into what we might call the lower right-hand corner of the active part of the worksheet, and there might or might not be any data in there.

Doesn't mean anything is wrong if it's empty. What does this mean? I just pressed Ctrl+End. I can say flat out and with total assurance that there is no information in this worksheet anywhere below this row. This is row 742. There's no information anywhere to the right of this column. You can be sure, if we scroll leftward, is there data in this row? Probably, not necessarily, but probably. Is t...

Navigating within worksheets
Video duration: 5m 13s 3h 43m Intermediate

Viewers:

Navigating within worksheets provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2010 Power Shortcuts

Subject:
Business
Software:
Excel
Author:
please wait ...