Importing Excel Tables into InDesign

InDesign does not import tables from Excel as well as Quark. Here's a tip I found today from an InDesign CS2 user. I'm in CS4, but it should provide a clue at least.

Remember the range of cells that you want to copy (and the sheet name if more than one) from the Excel spreadsheet.

With the Excel spreadsheet closed select File/Place in InDesign. When the Place file window opens check the "Show Import Options" box.

After selecting the Excel file, another window will appear asking for the sheet name and range in the Excel worksheet.

Drag the Place pointer to insert the table. Once the table has been inserted you can double click on it to edit or use any of the InDesign Table Options to alter the highlighted text.

Hope this helps.