Open your word file and place the cursor at the place where you want to paste.Select the whole dataset and press Ctrl+C to copy.To copy the only text in a word book you can use the “ Paste Option” to get quick results. Use Paste Option Feature to Copy Only Text from Excel to Word Now we will copy text from this excel dataset to the word book.ġ. Suppose we have a dataset of a shop containing kitchen goods and their stock availability in the shop. In the following, I have shared 3 effective methods to explain this task. (When All Information is selected, InDesign will paste everything in a single cell.)Ĭlose the Preferences dialog box and re-paste and all will be well.3 Effective Methods to Copy Only Text from Excel to Word Click it, and under When Pasting Text and Tables From Other Applications, choose Paste: Text Only. All the way down at the bottom of the list of categories you’ll see Clipboard Handling. Press Command/Ctrl+K to open the Preferences dialog box. The table data will spread out over all the necessary rows and columns.ĭidn’t work, you say? Did all the table data go in that one cell you had selected, like this? You’ll know you have the cell selected when it’s fully highlighted. Alternatively, click and drag just to the cell border. You can do this by putting your cursor in the InDesign table cell and pressing Esc.

But it’s good practice since it helps you end up with a table that’s sized properly from the get-go.Īnd here’s the key step: Select the top left cell (or whichever cell where you want the pasted data to start filling in the table). This isn’t strictly necessary InDesign will add rows and columns to fit the data when you paste. In InDesign, create a table with the right number of row and columns to house your data. In Word or Excel, copy the cells you want to bring into InDesign. But if all you want is a simple, 2-second method, here it is: Of course, using File > Place will give you access to import options that can be very handy for controlling what content comes in from Word or Excel, and how that content is formatted. Here’s a quick tip for those times when you want to quickly get some tabular data from Microsoft Word or Excel into InDesign without going through the process of placing the file.

Copy word table to excel