Contents
Can You import an Excel spreadsheet into an InDesign document?
And, because spreadsheets and tables rarely import into InDesign looking like they did in Excel and Word, we’ll give you a few tips on the easiest way to get started. To import your Excel spreadsheet into an InDesign document, first open your InDesign document and choose the Selection Tool.
Can you create a table within a cell in InDesign?
If you create a table within a cell, you cannot use the mouse to select any part of the table that oversets the cell boundary. Instead, expand the row or column; or place the insertion point in the first part of the table, and use keyboard shortcuts to move the insertion point and select text.
How to import a cell into an Excel spreadsheet?
When you choose File > Place and click the “Show Import Options” button, the dialog below appears. Normally, you’d have to use a “Cell Range” such as B6:F18 to designate which of the cells in the larger spreadsheet you want to import. But finding and remembering those coordinates can drive you batty. A better way is to use a “named range”.
How do I create a new row in InDesign?
You’ll see that InDesign has created a new blank row at the top of your table, and this is your new header row. You’ll need to select the row that was at the top a second ago (now your second row, with all your column heads in it), copy that row (Ctrl/Cmd+C), then select the new header row and paste the text in (Ctrl/Cmd+V).
How to import an unformatted table in InDesign?
If you want to import an unformatted table in InDesign and apply formatting at a later stage to have a greater level of control, check out this other InDesign Place command tutorial. Pagination overcomes conversion issues and accurately converts even the most complex spreadsheets.
How do I import a spreadsheet into Excel?
Select “Place” from the File menu. Select “Import Options” and double-click the Excel file containing your spreadsheet. The Import Options dialog box opens. 4. Click the “Sheet” menu and select the worksheet from the Excel workbook that you want to import. 5. Click the “View” menu to import custom views.
How do you create a place in InDesign?
Start by drawing a text frame with the Text tool and moving/resizing it to your desired location/area. Now choose File > Place from the InDesign menu – or by using Ctrl+D on a Windows machine or Cmd+D on a Mac. You’ll now see a new Place dialog box.