Excel 2010 Bible

Part IV: Using Advanced Excel Features

616

Here are the general steps that are required to copy from one application to another:

1. Activate the source document window that contains the information that you want
   to copy.


2. Select the information, using the mouse or the keyboard.


3. If the source application is a Microsoft Office 2010 application, choose Home ➪
   Clipboard ➪ Copy. Most other applications have an Edit ➪ Copy menu command. In
   most cases, pressing Ctrl+C works as well. The selection is copied to the Clipboard.

Tip
You also can choose Home ➪ Clipboard ➪ Cut (or Edit ➪ Cut) from the source application menu. This step
deletes your selection from the source application after placing the selection on the Clipboard. n

4. Activate the destination application. If the program isn’t running, you can usually start
   it without affecting the contents of the Clipboard.


5. Move to the appropriate position in the destination application (where you want to
   paste the copied material).


6. If the destination application is a Microsoft Office 2010 application, choose Home ➪
   Clipboard ➪ Paste. Most other applications have an Edit ➪ Paste command, and you
   can usually use Ctrl+V to paste. If the Clipboard contents aren’t appropriate for pasting,
   the Paste command is disabled. You can sometimes select other paste options by choos-
   ing Home ➪ Clipboard ➪ Paste (or Edit ➪ Paste Special).

Note
If you repeat Step 3 in any Office application, the Office Clipboard task pane appears automatically. If it
doesn’t appear, click the dialog launcher in the Home ➪ Clipboard group. Use the Options button at the bot-
tom of the Office Clipboard to control when this task pane appears. n

If you copy or cut information while working in a Microsoft Office application, the application places

the copied information on both the Windows Clipboard and the Office Clipboard. After you copy infor-

mation to the Windows Clipboard, it remains on the Windows Clipboard even after you paste it so that

you can use it multiple times.

Because the Windows Clipboard can hold only one item at a time, when you copy or cut something

else, the information previously stored on the Windows Clipboard is replaced. The Office Clipboard,

unlike the Windows Clipboard, can hold up to 24 separate selections. The Office Clipboard operates in

all Office applications; for example, you can copy two selections from Word and three from Excel and

paste any or all of them in PowerPoint.

Two Clipboards