Datasheet
Navigating with the Mouse and Keyboard
The mouse is the primary tool that you use in Excel for executing commands,
making selections, and navigating in the worksheet. Following are the mouse
conventions that we use in this book:
Click: Click the left mouse button once.
Double-click: Click the left mouse button twice in quick succession. It may
take you some time to get the hang of this action.
Right-click: Click the right mouse button once.
Drag: Hold down the left mouse button and move the mouse. Release the
mouse button to complete the drag operation.
Hover: Place the mouse pointer over an element without clicking a mouse
button.
Select: Place the mouse pointer over an element and click the left mouse
button.
Mousing around
Every mouse action is associated with some element in the Excel window. An
element can be a slider, button, cell, chart object, and so on. You select or hover
over the element using the mouse pointer.
Navigating through a worksheet with a mouse works just as you’d expect. Just
click a cell, and it becomes the active cell. If the cell that you want to activate
isn’t visible in the workbook window, you can use the scroll bars to scroll the
window in any direction, as follows:
To scroll one cell, click one of the arrows on the scroll bar.
To scroll by a complete screen, click either side of the scroll bar’s slider
button (the large center button).
To scroll faster, drag the slider.
To scroll a long distance vertically, press and hold the Shift key while drag-
ging the slider button.
Note that only the active workbook window displays scroll bars. If you activate a
different window, its scroll bars appear.
After you right-click a cell, a range of cells, or another object in the worksheet
area, Excel displays a contextual menu, so-called because the menu includes
commands specific to working with the cell, range, or object.
Familiarizing Yourself with the Excel 2007 Window — Navigating with the Mouse and Keyboard
5
03_046716 ch01.qxp 11/16/06 6:40 PM Page 5