Excel 2019 Bible

(singke) #1

Part I: Getting Started with Excel


copied and a brief description (it will hold up to 24 items). Figure 4.9 shows the Office
Clipboard with five copied items (four from Excel and one from Word).

FIGURE 4.9
Use the Clipboard task pane to copy and paste multiple items.

When you’re ready to paste information, select the cell into which you want to paste infor-
mation. To paste an individual item, click it in the Clipboard task pane. To paste all of the
items that you’ve copied, click the Paste All button (which is at the top of the Clipboard
task pane). The items are pasted, one after the other. The Paste All button is probably more
useful in Word for situations in which you copy text from various sources and then paste it
all at once.

You can clear the contents of the Office Clipboard by clicking the Clear All button.

The following items about the Office Clipboard and how it functions are worth noting:

■ Excel pastes the contents of the Windows Clipboard (the last item you copied to the
Office Clipboard) when you paste by choosing Home ➪ Clipboard ➪ Paste, by press-
ing Ctrl+V, or by right-clicking and choosing Paste from the shortcut menu.
Free download pdf