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 there data in this column? Probably. We could scroll up.…

Resume Transcript Auto-Scroll

Author

Released

8/12/2010

In Excel 2010 Power Shortcuts, Excel expert Dennis Taylor shares tips and shortcuts to vastly increase efficiency and get the full power out of Excel 2010. There are tips for working with the Ribbon and Quick Access toolbar, navigating workbooks and selecting cells, rapid data entry and editing, working with formulas, formatting data, working with charts, sorting data, and much more. Exercise files accompany the course.

Topics include:

Creating charts with keyboard shortcuts

Converting formulas to values by dragging

Repeating Undo and Redo actions

Displaying formulas instantly

Navigating quickly through worksheets and across workbooks

Formatting numeric, and date/time data in a flash with keystroke shortcuts