I’m doing a huge project transferring the dimensions of documents typed in InDesign onto an Excel spreadsheet for use in a database. (Don’t ask.) It’s a mess and can’t be automated.
Some schlub (me) has to sit at the machine and individually highlight the dimensions for the bleed for the document, copy it, switch to Excel, and then paste. Then switch back to ID, highlight the trim dimension, copy it, switch to Excel, tab to the new cell, and then paste.
It’s been awful. I do as much keyboarding as I can, but I still have to manually highlight the text.
With only about 20% to go, I thought I’d try something daring. I turned on the Preference in Type for Drag and Drop text in the Layout mode.
I then highlight the text in InDesign and just drag it over to the cell in Excel. I highlight appears over the cell. I release the mouse.
The text appears in the cell, but I’m still in InDesign. It saves me 4 or 5 steps!
I actually had an out loud OMG moment. (The cat woke up to look at me.)
Again, OMG!
This article was last modified on December 21, 2021
This article was first published on October 1, 2012
Commenting is easier and faster when you're logged in!
Recommended for you
Script for Applying Object Styles While Placing Images in InDesign
Apply object styles as needed while placing images, with the aid of a free scrip...
This Week in InDesign Articles, Part 4
A few articles that caught my eye this past week. Enjoy!
The best way to create a Straddle Head
Keith shows an easy way to create a straddle head that works in all versions of...