Eudi Online Help

Excel Clipboard conversions

Using the clipboard to perform conversions is a powerful way to handle tables that span more than one page. It is also useful when you need to copy several tables from one file into one excel sheet.

To perform Clipboard conversions do the following:

1. Select the Clipboard as Excel Sheet button from the drop-down menu of the Convert Drop Down Button in the Standard Toolbar to store the selected table data in the clipboard.
2. Open Excel.
3. Select a cell.
4. Paste the information (Press Ctrl-V or use the Edit -> Paste command) and the data will be pasted in the Excel (as shown below).

   

If the table continues on the next page do the following:

1. Clear the table layout (see Clearing table layout).
2. Mark the table on the second page
3. Click the Clipboard as Excel Sheet button.
4. In the Excel Sheet, select the cell just bellow the last line in the first column.
5. Paste the information. This will append the information from the second page to the excel table (as shown below)
6. Repeat from stage 1 for all the pages that contain the table.

Note: This process is effective when the table spans a relatively small amount of pages. For cases where the table spans many pages (tens, hundreds and more), use the technique outlined in the multiple page conversion topic.