Skip to main content
faeb
faeb
Participant
May 9, 2018
Answered

Resize imported table in InDesign CC

  • May 9, 2018
  • 2 replies
  • 4185 views

Hello,

I have imported a table from an Excel spreadsheet into an A4 InDesign page. I need to resize the formatted table so that I can fit it to one page (currently it is slightly larger than the page so I need to shrink it down).

Unfortunately, there is no option to resize the table once it has been imported, unlike an imported image which you can paste to fit the frame- does anyone know a work around?

I cannot recreate the table in InDesign as the Excel table has specific formatting and lots of detail...

Thanks,

Fae

This topic has been closed for replies.
Correct answer faeb

Hi Barb,

Unfortunately the table was too complicated to resize manually - there were merged cells, different sized rows, images etc.

As a work around, I saved the excel table as a PDF, making sure it was scaled to fit an A4 page, then I imported the PDF of the table into  InDesign. This way I could easily resize like an image.

Nonetheless, thank you for your help

Fae

2 replies

faeb
faebAuthor
Participant
May 14, 2018

Hi All,

As mentioned there was no option to scale the table by selecting the text frame... I was able to make the frame smaller but this had no effect on the table itself.

Thank you for your suggestions.

Fae

L
Community Expert
LaubenderCommunity Expert
Community Expert
May 14, 2018

Hi Fae,

what do you mean by "no option" to scale the text frame?

A table is always tied to a text frame. And a text frame can always be scaled.

Example

Before scaling a text frame containing a table

After scaling a text frame containing a table to 50% :

Preferences for scaling ( from my German InDesign CS6 ):

Scaling preferences set to Apply Scaling Percentage.

Best,
Uwe

    Barb Binder
    Community Expert
    Barb BinderCommunity Expert
    Community Expert
    May 14, 2018

    Hi Uwe:

    I did not know that!  And it works with the Scale X/Y Percentage buttons on the Control Panel too, of course.

    Thank you, Uwe. A great way to start a new week.

    ~Barb

    ~Barb at Rocky Mountain Training
    Barb Binder
    Community Expert
    Barb BinderCommunity Expert
    Community Expert
    May 9, 2018

    Hi Faeb:

    It's a multi-step process. Without seeing your exact situation, it will go something like this:

    1. Format the text so that it is small enough to fit on a page.
    2. Reduce the row height and/or cell margins:
    3. Hold the Shift key to resize the right side of the table and then bottom the table—Shift tells InDesign to resize all the columns and all the rows—without it, it will just resize the final column or row.

    ~Barb

    ~Barb at Rocky Mountain Training
    faeb
    faebAuthorCorrect answer
    Participant
    May 9, 2018

    Hi Barb,

    Unfortunately the table was too complicated to resize manually - there were merged cells, different sized rows, images etc.

    As a work around, I saved the excel table as a PDF, making sure it was scaled to fit an A4 page, then I imported the PDF of the table into  InDesign. This way I could easily resize like an image.

    Nonetheless, thank you for your help

    Fae

      Barb Binder
      Community Expert
      Barb BinderCommunity Expert
      Community Expert
      May 9, 2018

      Hi Faeb:

      That was going to be my next suggestion, since it was pre-formatted in Excel. Glad you are back on track.

      ~Barb

      ~Barb at Rocky Mountain Training
      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices