Datasheet

Chapter 1



Navigating in Excel and Understanding the Interface

EXERCISE 1.15

Methods of Copying and Pasting

1. Open Excel and select File  Open. Browse to find the file you saved at the end of the last

exercise, named Exercise 1-14.xls, and open it. (If you did not do the last exercise or think

you may have omitted some steps up to this point, extract Exercise 1-14.xls from the

zipped file for this chapter.)

2. Go to the January Sales sheet.

3. Select cell A7, which contains the store name Riley, and copy it, using one of these methods:



Click the Copy button on the Standard toolbar.



Choose Copy from the Edit menu.



Use the keyboard shortcut Ctrl+C to copy it.



Right-click the cell and choose Copy.

4. Notice the moving marquee once you have copied the cell.

5. Now move to the February Sales sheet. Click cell A8 and paste, using one of these methods:

Click the Paste button on the Standard toolbar.

Choose Paste from the Edit menu.

Use the keyboard shortcut Ctrl+V.

Right-click the cell and choose Paste.

6. Move to the March Sales sheet and use one of the Paste methods to paste it again, this

time into cell A12. Whatever is copied remains on the Clipboard for you to paste over and

over, until you copy or cut something else to overwrite it or you remove it from the Clipboard.

7. Go back to the January Sales sheet and you’ll notice that the moving marquee is still

present on cell A7. Press the Esc key on your keyboard and the marquee disappears.

Notice that the Paste button on the Standard toolbar is now grayed out. If you right-click,

you will see Paste is also grayed out, and if you go to the Edit menu, Paste is grayed out

there as well. Removing the marquee from the cell removes the data from the Clipboard.

8. Using the copy and paste techniques above, copy cell D7 on the January Sales sheet and

paste it into cells B8, C8, D8, and E8 in the February Sales sheet. Remember to widen your

columns if the text is cut off.

9. Go to the March Sales sheet and continue to paste into cells B12, C12, D12, and E12, and

again, widen your columns if necessary.

10. Return to the January Sales sheet and copy cell A4. (If you are simply going to select a

new cell to copy, you don’t need to remove the marquee from the original selection;

Excel will do that automatically.)

4002book.fm Page 30 Friday, March 24, 2006 11:36 PM