Datasheet

Moving and Copying Data
37
4. Move to the January Sales sheet. Use one of the methods you learned earlier to get into
Edit mode in cell A1 and change the content of the cell to read January Monthly Sales
Report.
Reminder: To get into Edit mode in a cell, do one of the following:

Double-click the cell.

Click the cell and press F2.

Click the cell; then click in the Formula bar.
5. Still in Edit mode, using the I beam, drag across the text “Monthly Sales Report” to select
all the text except the word January. Copy it and it will appear on your Office Clipboard.
6. Move to the March Sales sheet, select the range A3:A11, and copy it. It also appears on
the task pane.
7. Next, select B3:E3 and copy that range.
8. Now, select B11:E11 and cut that range. Then select A11 and press Delete.
9. You now have four different blocks of data on your Office Clipboard. Move to the Febru-
ary Sales sheet.
10. Get into Edit mode in cell A1 and select just the word Sales, not the word February.
11. With the word Sales selected, click the task-pane text that reads “Monthly Sales Report.”
Notice that the text is pasted over what you had selected, so cell A1 now says “February
Monthly Sales Report.”
12. Go to the March Sales sheet and repeat step 11 to change cell A1 to “March Monthly
Sales Report.”
13. Go to the April Sales sheet and type the word April in cell A1; press your spacebar one
time; then click the text “Monthly Sales Report” in the task pane. Cell A1 now shows
“April Monthly Sales Report.”
14. Follow the previous procedure to put the appropriate month, followed by a space, fol-
lowed by the text “Monthly Sales Report” into the May through December Sales sheets
(not in the Qtr Sales sheets nor the Yearly Totals sheet).
EXERCISE 1.19 (continued)
4002book.fm Page 37 Friday, March 24, 2006 11:36 PM