If I choose All Information, then sometimes, those pasted tables don't come in correctly. Inside the Clipboard Handling pane of the Preferences dialog box, I want to make sure that this When Pasting Text and Tables from Other Applications section is set to Text Only. Inside the Preferences sub-menu, I'm going to choose Clipboard Handling.
I'll open my Preferences dialog box by going to the InDesign menu on the Mac, or the Edit menu on Windows, and then choosing Preferences. If that happens to you, then you might not have had all the cells selected when you pasted, or you might need to make a small change to your preferences. For some people, when they paste, the whole table ends up sitting inside the first cell of the InDesign table. Oh, actually, I should point out two reasons why this might not work for you. All the data is put back in the table, but in the new order. I now have the right number of rows and columns, so now I can paste with Command + V or Control + V on Windows. I'll change this to four rows instead of five, and InDesign warns me that it's going to delete some of the data, that's OK, and I'm going to add one column. I can change that up here in the control panel. Before I paste, I want to make sure my table has the right number of columns and rows. However, my new table is going to have just the opposite. This table, the original table, had four columns and five rows. Now I can copy those cells one last time, head back to InDesign, but before I paste, I need to pay attention to something. What was a column is now a row, and vice versa. The data is pasted back into this worksheet, and you can see that it's now transposed. The Paste Special dialog box gives me all kinds of options, but all I need to do here is turn on the Transpose check box, and click OK. First, I'll select any other cell down here, then I'll go to the Edit menu, and I'll choose Paste Special. Yes, you really do need to select and copy all those cells again in order to take advantage of a special Excel feature, which you can find in the Edit menu. I now need to deselect these cells, and then select them again and copy them to the clipboard one more time. OK, so there's the data, looking pretty much the same as it did in InDesign, except it's not formatted. You can see all that data shows up inside the Excel document. All I need to do is paste, Command + V or Control + V on Windows. Now, I'll switch to Excel, and you can see I have a blank worksheet open here. Then, I'll copy all that data to the clipboard by pressing Command + C on the Mac, or Control + C on Windows. I can do that by simply placing my text cursor inside any one of the cells, and then pressing cmd + opt + a on the Mac, or ctrl + alt + a on Windows. To get the data into Excel, we first need to select all the cells in the table. Now, the Excel trick works best when your table is relatively simple and you don't have any formatting, like this one. I'll show you all three, but first, let me show you how you can do it in Excel.
#Active tables for adobe indesign free
You could use Excel, you could use a free script, or you could use an excellent plugin. Now, there's no obvious way to do this in InDesign, but you can do it with a little trick, in fact, three tricks. For example, I might want all the information in this first row to become part of the first column, and the second row should be the second column, and so on. Sometimes you have a table in InDesign in which you want to swap, or switch, the columns and rows.
0 kommentar(er)
