Paste Clipboard into Design Matrix
By selecting the Fill | Paste menu choice, or hitting the Ctrl+V key, you can paste the contents of the clipboard into the Design Matrix, starting at the highlighted cell (cursor location at the time of the paste). Multiple columns and rows will be filled with values, as dictated by the clipboard contents. For example, 2 columns and 14 rows in a Quattro Pro spreadsheet can be selected and pasted into the clipboard with the Ctrl+C keys, or the edit and copy command. Then, the cursor can highlight a cell in the design matrix. When the Ctrl+V keys are pressed, the values that were in the Quattro Pro spreadsheet are now inserted into the design matrix.
A useful option is to Save the design matrix as a dBase (DBF) file, edit the spreadsheet, and then copy the modified design matrix to the clipboard for pasting back into the Design Matrix Window.