Excel 2007 For Dummies
Book image
Explore Book Buy On Amazon

Microsoft Office Excel 2007 offers a variety of keyboard shortcuts for selecting a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if this is required to move the cell cursor. You’ll find these keystrokes and their actions in the following table.

Keystrokes for Moving the Cell Cursor in Excel 2007
Keystroke Where the Cell Cursor Moves
→ or Tab Cell to the immediate right.
← or Shift+Tab Cell to the immediate left.
Cell up one row.
Cell down one row.
Home Cell in Column A of the current row.
Ctrl+Home First cell (A1) of the worksheet.
Ctrl+End or End, Home Cell in the worksheet at the intersection of the last column that has any data in it and the last row that has any data in it.
Page Up Cell one full screen up in the same column.
Page Down Cell one full screen down in the same column.
Ctrl+→ or End, → First occupied cell to the right that is either preceded or followed by a blank cell.
Ctrl+← or End, ← First occupied cell to the left that is either preceded or followed by a blank cell.
Ctrl+↑ or End, ↑ First occupied cell above that is either preceded or followed by a blank cell.
Ctrl+↓ or End, ↓ First occupied cell below that is either preceded or followed by a blank cell.
Ctrl+Page Down The next worksheet of that workbook.
Ctrl+Page Up The preceding worksheet of that workbook.

In the case of those keystrokes that use arrow keys, you must either use the arrows on the cursor keypad or disengage the Num Lock key on the numeric keypad of your keyboard.

When you use Ctrl and an arrow key to move from edge to edge in a table or between tables in a worksheet, you hold down Ctrl while you press one of the four arrow keys (indicated by the + symbol in keystrokes, such as Ctrl+→).

When you use End and an arrow-key alternative, you must press and then release the End key before you press the arrow key (indicated by the comma in keystrokes, such as End, →). Pressing and releasing the End key causes the End Mode indicator to appear on the status bar. This is your sign that Excel is ready for you to press one of the four arrow keys or Home.

About This Article

This article is from the book:

About the book author:

Greg Harvey has authored tons of computer books, the most recent being Excel Workbook For Dummies and Roxio Easy Media Creator 8 For Dummies, and the most popular being Excel 2003 For Dummies and Excel 2003 All-In-One Desk Reference For Dummies. He started out training business users on how to use IBM personal computers and their attendant computer software in the rough and tumble days of DOS, WordStar, and Lotus 1-2-3 in the mid-80s of the last century. After working for a number of independent training firms, Greg went on to teach semester-long courses in spreadsheet and database management software at Golden Gate University in San Francisco.
His love of teaching has translated into an equal love of writing. For Dummies books are, of course, his all-time favorites to write because they enable him to write to his favorite audience: the beginner. They also enable him to use humor (a key element to success in the training room) and, most delightful of all, to express an opinion or two about the subject matter at hand.
Greg received his doctorate degree in Humanities in Philosophy and Religion with a concentration in Asian Studies and Comparative Religion last May. Everyone is glad that Greg was finally able to get out of school before he retired.

This article can be found in the category: