Datasheet

Moving and Copying Data
39
FIGURE 1.9 Mouse pointers can make a big difference in Excel.
It’s definitely easier to understand these pointers in action, so you’ll get a chance to practice
using them in Exercise 1.20.
EXERCISE 1.20
Using the Different Mouse Pointers to Select, Move, and Copy Data
1. Open Excel with a new blank workbook showing.
2. In cell A1, enter the number 100 and press Enter.
3. Click cell A1 and copy it.
4. Select the range A2:B10, using the white plus sign pointer, and paste. Note that you can
paste the same data into multiple cells if you select the range before you paste.
5. Use the Ctrl key with the white plus sign to select cells C1, C3, and C10, and paste again.
Note that you can paste into noncontiguous cells as well. Notice the marquee remains
around cell A1 because the content of A1 is still on the Clipboard and you can continue
to paste it as many times as you want until it is cleared from the Clipboard.
6. Press your Esc key to remove the marquee and clear the Clipboard.
7. Select cell A1 and type 200, then press Enter.
Black Plus Sign
White Plus Sign
Black Four-Headed Arrow
4002book.fm Page 39 Friday, March 24, 2006 11:36 PM