Topic: Navigation

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Choosing Direction After Enter On a Workbook Basis Excel allows you to configure what happens when you press Enter in a cell. This change, which controls the direction in which the following cell is selected, is applicable to all instances of Excel you use from that time forward. You may want to vary, on a workbook by workbook basis, how the Enter key behaves. This tip explains how this can be done. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Finding the End of the Worksheet Understanding how to get to the end of the Excel worksheet. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Jumping to a Range You can name various ranges of cells in your worksheet, which is very handy when you are putting together formulas. Excel knows that you may also want to jump to and select a named range, so it provides two quick and easy ways to accomplish the task. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Jumping to a Specific Worksheet When you’ve got a workbook that has a huge number of worksheets in it, jumping to a specific worksheet can be a challenge. Excel provides some tools to select from a large number of worksheets, but you can also create your own tool that will do the job even better. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Odd Arrow Key Behavior The arrow keys should allow you to navigate around a worksheet, selecting different cells. If your arrow keys don’t work this way, it could be because of your Scroll Lock key, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Removing Cells from a Selected Range Selecting a large range of cells is easy; unselecting some of the cells in that range is not so easy. In fact, there is no click or shortcut you can use to unselect cells in the range. Instead, you must turn to a macro or a third-party solution, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Scrolling Up and Down Moving through the spreadsheet with a mouse. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Selecting a Column Two easy ways to select an entire column in Excel. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Selecting a Row Two ways to select an entire row in Excel. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Simultaneous Scrolling 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tab Key Jumps a Screen at a Time When you press the Tab key, Excel moves the cell cursor one cell to the right. If you press the Tab key and, instead, Excel moves the cell cursor more than one cell to the right, it could be because of an obscure configuration setting in Excel. This tip explains how to fix that setting. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using Go To to Jump to a Chart Sheet Using Go To with a cell reference on a different worksheet is a great way of jumping somewhere. Using Go To with a chart sheet is impossible, however, because there are no cells on the sheet to reference. There are workarounds, however, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tips, Tricks, and Answers

An Amazing Resource!

Helpful Links

Great Info!

RSS Feeds