Datasheet

Chapter 1



Navigating in Excel and Understanding the Interface

Using the Office Clipboard

The Windows Clipboard is rather limited; it holds only the last item you cut or copied. As soon

as you cut or copy something new, the previous item is overwritten. However, Excel allows

you to use the Office Clipboard, which can hold up to 24 blocks of data at one time. This lets you

make multiple cuts and copies before you paste any of them, and then you can choose what

you want to paste, and where you want to paste it. This is the way to override Excel’s behavior

of not allowing you to cut or copy noncontiguous selections. Exercise 1.19 shows you how.

10. To deselect the selection, simply click in any cell that is not part of the selection.

11. Close the file and click Yes when Excel asks if you want to save it. This will overwrite the

previous copy.

EXERCISE 1.19

Pasting Multiple Cut and Copied Blocks of Data

1. Open the file Exercise 1-18.xls that you saved in the last exercise. (If you did not save it,

extract it from the zipped file for this chapter.)

2. Select Edit  Office Clipboard.

3. The Office Clipboard task pane appears. It should be empty, as shown here. If it is not

empty, click the Clear All button near the top.

EXERCISE 1.18 (continued)

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