Skip navigation
Currently Being Moderated

Copy from Excel to InDesign

May 10, 2012 3:51 PM

Tags: #cs5 #indesign_cs5

In the past, I was able to copy blocks of rows and columns in Excel and then highlight my table cell blocks in InDesign and paste the new data right into the table. I tried to do this today, and the only thing that would paste was the first cell in InDesign (the other copied cells would not paste). I ended up pasting the Excel data in InDesign as a separate text block, then converting the copied table to text and pasting it into the formatted InDesign table.

 

This work-around is OK, but  I'm curious what I'm doing wrong. I checked to see if there were contingent cells in either Excel or InDesign, and they weren't.

 
Replies
  • Currently Being Moderated
    May 11, 2012 11:58 AM   in reply to pelicanadv

    The range of copied cells is probaly larger than the number of cells available in the table that you are pasting into. So if you copy a 5 column by 4 row selection, you will not be able to paste this into a table that has only 4 columns by 3 rows.

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points