Skip to main content
Participating Frequently
August 1, 2017
Question

Blank cells appearing where there should be values (placing excel data)

  • August 1, 2017
  • 1 reply
  • 471 views

Hi All,

I'm very new to indesign and have already come across a problem that I just cannot find a way around. I've searched google and these forums but no joy.

I feel pictures will explain best, what's going on. These are the cells in excel:

I need to place these columns separately (unformatted tabbed text) in indesign - however nothing in the M column is appearing.

Do let me know if more information is required and apologies if this is a really easy one. I've only been using indesign for a day!

This topic has been closed for replies.

1 reply

BobLevine
Community Expert
Community Expert
August 1, 2017

Try placing it as a table and converting to text after placing in ID.

Participating Frequently
August 1, 2017

Thanks for the reply. If I place as a formatted table, the column appears, however it won't allow me to position specific cells and I get the lines of the cells. Apologies, but i'm not sure how to convert to text?

I'm trying to get the cells to appear next to each other, as if in a recipe book e.g.

150g Chicken

A handful of Spinach

Rather than:

150g             Chicken

A handful of  Spinach

The values are linked as the ingredient quantities will be changing regularly in excel (I create tailored meal plans for clients with different needs).

BobLevine
Community Expert
Community Expert
August 1, 2017

Place as a table. Select the table and from the table menu select convert table to text.