Copy and Paste Columns in a Multiple Choice Variable Spreadsheet

At times, you may have an Excel spreadsheet or Microsoft Word table that contains the data you want to use as options, prompts, and merge text for a Multiple Choice variable. Other times you may want to copy this information from a Multiple Choice variable to a spreadsheet or table. Using the shortcut menu at the Multiple Choice Variable Editor, you can do this.

To copy data from a spreadsheet or table and paste it into the Multiple Choice Variable Editor

1. In the spreadsheet or table, select or highlight the columns and rows that contain the information you want to copy and copy them. (See the application's help for information on copying.)
2. Edit the Multiple Choice variable. (See Edit a Variable.) The Multiple Choice Variable Editor appears.
3. Place your cursor in the spreadsheet column where you want the new data to be used.
4. Right-click and choose Paste Multiple from the shortcut menu. The data is pasted into the spreadsheet.

To copy data from the Multiple Choice Variable Editor and paste it into a spreadsheet or table

1. In the Multiple Choice Variable Editor, place your cursor in the spreadsheet column where you want to copy the data.
2. Right-click and choose Copy Column (copies the text from the current cell down for this column only) or Copy All Columns (copies the text from the current cell down in all columns) from the shortcut menu.
3. In the spreadsheet or table, place your cursor where you want to paste the data and paste it. (See the application's help for information on pasting.)

To copy the spreadsheet from one Multiple Choice variable and paste it into another Multiple Choice variable, right-click on the first cell in the spreadsheet and choose Copy All Columns from the shortcut menu. Then edit the second variable, place your cursor in the first cell of the spreadsheet, and choose Paste Multiple from the shortcut menu.