You can copy and paste the contents of the clipboard to the spreadsheet cells using a number of rules to specify which cells the data is pasted in to.
- After copying your data to the clipboard, from the menu select Edit | Paste Special.
- Select options as required then click OK.
|Skip empty items in clipboard||Skip over any empty/blank/missing items in the clipboard, and do not paste these to cells. The cell position in the spreadsheet is not advanced, so that the next non-missing item in the clipboard is written to the current cell.|
|Transpose clipboard items||Read the clipboard items column by column, rather than the default row by row order.|
|Overwrite cells with missing values||An empty item on the clipboard will be pasted to a cell, creating a missing value in that cell. If this option is not selected the cell will not be changed.|
|Only fill missing cells in spreadsheet||The clipboard item is only written to the spreadsheet when the spreadsheet cell contains a missing value.|
|Only advance clipboard on writing cell||The current item on the clipboard is kept for the next insertion until the combinations of the other options allow it to be written. For example, if Only fill missing cells in spreadsheet is set, and this option is also set, the clipboard contents will be used one by one to fill the missing cells. If this option was not set, then the clipboard item would be skipped, unless it coincided with a missing cell.|
|Fill cells||These options control the order that the cells in the spreadsheet are filled.
|Stop at the end of the first column/row||Only fill the first column in column by column mode (or row in row by row mode), and then stop.|
|Go to the top of next column/row||If multiple columns/rows are being filled (the above item is not selected), then selecting this option will cause the paste operation to go to the top of the next column on reaching the end of the current column. If this option is not selected, the paste operation will go to the cell in the next column which is in the same row as the starting cell.|
|Case of text||These options control whether the case of any text being pasted to the cells is modified.