Page 50 - Excel 2007 Bible

05_044039 ch01.qxp 11/21/06 10:55 AM Page 7
TABLE 1.2
Excel’s Worksheet Movement Keys
Key
Action
Up arrow
Moves the active cell up one row.
Moves the active cell down one row.
Down arrow
Left arrow of Shift+Tab
Moves the active cell one column to the left.
Moves the active cell one column to the right.
Right arrow or Tab
PgUp
Moves the active cell up one screen.
PgDn
Moves the active cell down one screen.
Alt+PgDn
Moves the active cell right one screen.
Moves the active cell left one screen.
Alt+PgUp
Ctrl+Backspace
Up arrow*
Scrolls the screen up one row (active cell does not change).
Down arrow* Scrolls the screen so that the active cell is visible. Introducing Excel 1
Scrolls the screen down one row (active cell does not change).
Left arrow* Scrolls the screen left one column (active cell does not change).
Right arrow* Scrolls the screen right one column (active cell does not change).
* With Scroll Lock on
Navigating with your mouse
To change the active cell by using the mouse, click another cell; it becomes the active cell. If the cell that
you want to activate isn’t visible in the workbook window, you can use the scrollbars to scroll the window
in any direction. To scroll one cell, click either of the arrows on the scrollbar. To scroll by a complete screen,
click either side of the scrollbar’s scroll box. You also can drag the scroll box for faster scrolling.
TIP If your mouse has a wheel on it, you can use the mouse wheel to scroll vertically. Also, if you
TIP
click the wheel and move the mouse in any direction, the worksheet scrolls automatically in
that direction. The more you move the mouse, the faster the scrolling.
Press Ctrl while you use the mouse wheel to zoom the worksheet. If you prefer to use the mouse wheel to
zoom the worksheet without pressing Ctrl, choose Office ➪ Excel Options and select the Advanced section.
Place a check mark next to the Zoom On Roll With Intellimouse check box.
Using the scrollbars or scrolling with your mouse doesn’t change the active cell. It simply scrolls the work-
sheet. To change the active cell, you must click a new cell after scrolling.
Introducing the Ribbon
The most dramatic change in Office 2007 is the new user interface. Traditional menus and toolbars are
gone, and they’ve been replaced with the Ribbon. Office 2007 is the first software in history to use this new
interface, and it remains to be seen whether it will catch on and replace traditional menus and toolbars.
7