Paste Special

Ribbon bar. Select the Edit tab. In the Clipboard/Data group, click the Paste arrow and from the menu, select Paste Special to display the Paste Special dialog box.

Classic menus. From the Edit menu, select Paste Special  to display the Paste Special dialog box.

This dialog box contains a list of available ways to paste the contents of the Clipboard into the current document. Choose the desired format (i.e., Rich Text Format, text, or picture) in which the Clipboard object will be pasted in the current document. The options available depend on the contents of the Clipboard and the options selected on this dialog.

Source. The Source field reports the source from which the current Clipboard object was taken. This information helps you determine what options to select. For example, if the source is an Excel spreadsheet, you may wish to use the Paste Link option so that the selection is linked to the source file. Then, the selection is updated when the source file changes.

Paste. Select the Paste option button to paste the contents of the Clipboard into the document without maintaining any links to the source file.

Paste Link. Select the Paste Link option button to paste the contents of the Clipboard into the document and maintain a link to the source file. Then, the selection is updated when the source file changes.

As. The As box contains a variety of formats in which the Clipboard contents can be pasted. Select the one that best suits your needs. To see what will result from selecting a specific format, select the format and read the description in the Results field (see below).

Display as icon. Select the Display as icon check box to display the Clipboard contents as an icon in the Statistica spreadsheet.

Result. The Result field displays a detailed description of what will happen when you paste the Clipboard contents into your document using the format selected in the As box.

OK. After you have specified how to paste the Clipboard object, click the OK button to paste it.

Cancel. Click the Cancel button to exit this dialog box without performing any actions.