Tips, Tricks, and Answers
The following articles are available for the 'Navigation' topic. Click the article''s title (shown in bold) to see the associated article.
Choosing Direction after Enter On a Workbook Basis
Excel lets you specify how it should behave when you press Enter. If you change this behavior, Excel assumes you want it changed for all workbooks on which you might be working. Here's how to adjust it so that the behavior can vary based on which workbook you are using.
Finding the End of the Worksheet
Want a quick way to get to the last cell in your worksheet? This tip provides a handy shortcut and a potential "gotcha."
Going to the Corners of a Selected Range
When you select a range of cells (particularly if it is a large range of cells), you may not be quite sure if you've selected everything you needed to. One way to check is to move around the corners of the selected range, using the shortcut key described in this tip.
Jumping to a Range
Need a quick way to jump to a particular part of your worksheet? You can do it by using the Go To dialog box.
Jumping To a Specific Page
Want to jump to a specific printed page within a worksheet? It's not as easy as you might think, but here's some techniques you can use.
Jumping to a Specific Worksheet
Want to make fast work of moving from one worksheet to another? Here's how to do the task when you have a lot of worksheets in your workbook.
Jumping to the Real Last Cell
Jumping to the last cell in a worksheet should be easy, but you may not always get the results that you expect. This tip looks at why this could be the case and how you can get around the problem.
Limiting Scroll Area
If you need to limit the cells that are accessible by the user of a worksheet, VBA can come to the rescue. This doesn't involve the use of macros, but the setting of properties.
Odd Arrow Key Behavior
Press the up or down arrow keys, and you expect Excel to change which cell is selected. If this doesn't occur on your worksheet, it could be due to a simple inadvertent keypress on the keyboard.
Removing Cells from a Selected Range
Select a large range of cells and you may later want to remove a few cells from that selection. This is not as easy as you might expect. Here's how to unselect those cells you don't want in the selection.
Scrolling Up and Down
Need an easy way to move through a spreadsheet using a mouse? Here are a couple of ideas.
Selecting a Column
Two easy ways to select an entire column in Excel.
Selecting a Row
Need to select an entire row? Here are two really easy ways to make the selection.
If you have two worksheets displayed at the same time, you might want those worksheets to remain visually "in sync" with each other. Here's a couple of small macros you can use to scroll the worksheets simultaneously.
Tab Key Jumps a Screen at a Time
Have you ever pressed the Tab key, expecting to move to the next cell in your worksheet, only to have Excel completely change what you see on the screen? This could be due to a setting deep inside Excel related to transitioning from other spreadsheet programs.
Using Go To to Jump to a Chart Sheet
Create a chart on its own worksheet, and you can display it by simply clicking the tab at the bottom of the Excel work area. But if you can't do that, then you may want to use Go To to jump to that sheet. Here's the skinny on whether you can do that or not.
Weird Mouse Shortcut
If you like to use the mouse in your worksheet navigation efforts, you'll want to pay attention to this tip. Here you discover a way you can navigate using the mouse and the borders of the selected cell.