Inspiring

Answered

Pasting Copied Text From Excel Into InDesign Proble

Forum|Forum|6 years ago
March 25, 2019
2 replies
3315 views

I am having a weird problem that I cannot figure out. I have used both Excel and Indesign for years and never had a problem with pasting long columns of text from Excel to InDesign. I have three columns of data in Excel. All plain text and formatted the same. I copied column A and pasted to Indesign. Once all pages were pasted, I was able to Command-Y to bring it to the text editor and format it using the paragraph style that I wanted. Worked fine. I then copied column B in Excel and pasted to InDesign, but the data is double spaced. Even if I do the Command-Y and apply the same paragraph style as column A, the data stays continues to have spaces between the lines (double spaced). I have looked at all settings in both programs and cannot come up with a reason it should be double spaced, or how to remove that. It seems that if I format two columns of text using the same Paragraph style, that should take care of it.

indesign text formating

Correct answer richardb62236718

Barb:

I never figured it out and had to hand work the data to get it in there. Could not come up with a reason. Did not appear to be formatting, either in Excel or InDesign.

Anyway, I had to work around and move on.

Thanks

Richard Beirne

S

sbano-gensler

New Participant

This issue is in your preferences. To paste the cell data as plain text, you need to go to preferences > clipboard handling and select "text only" from the When Pasting Text and Tables..." options. It defaults to All Information.

I would recommend switching it back after you are done though as it can be really helpful to have "all information" for most instances.

R

richardb62236718Author

Inspiring

I wish your answer would solve my issue, but it does not. I had already made

sure my Prefs for the clipboard were set at ³text-only². Whatever is causing

this weirdness is not that.

To repeat, I have an Excel spreadsheet with 4 columns. Column 1 has a list

of people. Column 2 has their locations. Column 3 has their years of

service. All three are formatted th same as plain text. Column 1 places into

Indesign just fine. When I place Column 2, the data is double spaced.

Nothing I do can change that except make the column as wide as the entire

page. (which makes layout almost impossible) I have checked the formatting

in both Excel and Indesign. I have set the Indesign prefs to handle the

clipboard as ³text-only².

After using Pagemaker for years followed by Indesign, this would not be an

issue. Weird.

Richard Beirne

T

Thari DV

New Participant

Hii there, how did you work around this issue? I'm having the same problem and the text only isnt fixing it.

Barb Binder

Community Expert

Hi Richard:

Did you get this one figured out? Could be that the type is vertically justified or snapped to a baseline grid? Or maybe there is something off with the relatively new Space Between Paragraphs using the Same Style setting?

If you are still having this issue let us know and we can see if we can help.

~Barb

~Barb at Rocky Mountain Training

R

richardb62236718AuthorCorrect answer

Inspiring

Barb:

I never figured it out and had to hand work the data to get it in there. Could not come up with a reason. Did not appear to be formatting, either in Excel or InDesign.

Anyway, I had to work around and move on.

Thanks

Richard Beirne

Barb Binder

Community Expert

Hi Richard:

Glad you are back on track. If it happens again, just reply to this post and we'll see if we can give a hand. I'm sure there was a logical explanation—just not sure what it was.

~Barb

~Barb at Rocky Mountain Training

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded