Using the Clipboard

Pasting Data to Excel

To paste the contents of a Mathematica list to an Excel range:

• In a Mathematica notebook, select the list you wish to copy.

• Press Ctrl-C or choose Copy from the Edit menu.

• Switch to Microsoft Excel and select where to insert the contents of the list. If a single cell is selected, data will be pasted down and to the right of that cell.

• Press Ctrl-Shift-V or right-click and choose Paste if Mathematica Contexts are enabled.

Notes

• If nothing was pasted, verify Mathematica keyboard shortcuts are enabled in Excel. You can do this under Mathematica Options

Interface.

• For best results, convert your data to Mathematica InputForm before pasting the data into Excel. You can do this in Mathematica or using the Mathematica Clipboard window in Excel. See Fixing Problematic Data. • Be sure the opening and closing brackets of the Mathematica list are selected. Excel will not recognize the Clipboard contents as a Mathematica list unless these brackets are present.

• A convenient way to select an entire Mathematica list is to place the cursor at the beginning of the list and triple-click.