Datasheet

38
Chapter 1

Navigating in Excel and Understanding the Interface
Using the Mouse to Drag and Drop or Fill Data
Up to this point, you have used three different mouse pointers (the white plus sign, the row/
column resizing pointer, and the I beam), but Excel has more and you must understand them
in order to use them correctly to perform the action you intend. The ones we will use for this
exercise are pictured in Figure 1.9.

The white plus sign is used only for selecting cells and ranges.

The black four-headed arrow is used to drag and drop cells and ranges.

The black plus sign is seen only if your mouse hovers over the fill handle on a cell. The fill
handle is the small black box you see in the lower-right corner of any selected cell or
range, as shown here. This pointer is used to copy data or fill a series.
15. Once you have completed all of the monthly sales sheets, move your mouse over the task-
pane text that reads “Monthly Sales Report.” You will see a dropdown arrow to the right of
the text. Click this arrow and choose Delete to remove this item from the Office Clipboard.
16. Move to the 1st Qtr Sales sheet and click cell A3. Click the list of store names in the task
pane to paste them into cells A3:A11.
17. Click the April Sales sheet. Click cell A3 and paste the store names.
18. Click cell B3 and paste the week titles (Week 1, Week 2, etc.).
When using the Office Clipboard, your column widths do not come through; choosing Paste
Special gives you different choices, and you cannot choose to paste the column widths. You
will have to use one of the other methods you learned to adjust the column widths.
19. Click cell B11 and paste the numbers for the Flora store.
20. Click the Clear All button at the top of the task pane to remove all of the items from the
Office Clipboard.
21. Use the Save As command to save the file in your Chapter One folder and name it Exer-
cise 1-19.xls. Close the file and close Excel.
EXERCISE 1.19 (continued)
4002book.fm Page 38 Friday, March 24, 2006 11:36 PM