Thursday, November 22, 2012

How to Transfer an Adobe InDesign Table Into Microsoft Excel


1. Count the exact number of rows and columns in the InDesign table you wish to transfer. Knowing the exact number will be important when you are working in Microsoft Excel.
2. Click on the Type tool in the Tool Palette. The Type tool looks like a capital letter T.
3. Select all columns and rows of the table. To do this, hold your mouse over the left most line on the top row of the table. The cursor will turn into a solid back arrow. Hold the mouse button down to highlight the first row and drag the mouse down to the bottom of the table to highlight all of the rows. The table will be selected when all cells are solid black.
4. Choose 'Copy' from the edit menu.
5. Open Microsoft Excel and find the place you want to insert the table. You can add to an existing document or create a new document.
6. Click in the cell in which you want to start your table. Drag the mouse to the right and down to select the same number of rows and columns that you had in your InDesign document. If you do not select the same number of rows and columns, the information may not display properly.
7. Paste the data into the selected sells by choosing 'Paste' from the 'Edit' menu.

Blogger news