O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Moving Around the Excel Screen

EACH WORKSHEET IN EXCEL has more than 17 billion individual cells. Luckily, Excel offers several methods using your mouse, your keyboard, and even the Ribbon for moving around them all. Depending on how you use Excel, you may find that you will use all three methods.

Using the Keyboard

Arguably the easiest, but surely the most common, way to move around an Excel worksheet is by using the keyboard. Table 1-1 displays some of the ways you can use the keyboard to move around an Excel workbook.

Table 1-1. Keystroke Movement in Excel
KeystrokeMovement
Arrow keysMoves one cell at a time in the direction of the arrow
TabMoves one cell right
Shift+TabMoves one cell left
EnterMoves one cell down
Shift+EnterMoves one cell up ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required