Skip navigation
Neil Weinberg
Neil Weinberg
Currently Being Moderated

Is it possible to set the cell height in a cell style?

Aug 16, 2012 5:07 PM

In the attached screenshot, the cell height is set to exactly 0.125. I put my cursor in the cell, then opened the cell styles panel and created a new cell style based on this cell. But when I apply the cell style to other cells, it does not apply the cell height. There were no overrides or other styles applied to the other cells. I also opened up the cell style definition from the cell styles panel, but don't see anywhere to set the cell height there either. Is there another way to do this that I am missing?Screen Shot 2012-08-16 at 5.01.57 PM copy.jpg

661 Views   5 Replies   Latest reply: flaming1, Aug 20, 2012 2:59 PM
 
Replies
  • Steve Werner
    Currently Being Moderated
    1. Steve Werner,
    Aug 16, 2012 5:21 PM   in reply to Neil Weinberg
    Report

    Not possible. You can't define dimensions—row height or column width— in a cell style. This always has to be done manuallly.

     
    |
    Mark as:
  • Neil Weinberg
    Currently Being Moderated
    2. Neil Weinberg,
    Aug 16, 2012 5:30 PM   in reply to Steve Werner
    Report

    OK, thanks for confirming. The cell dimensions seem an integral part of the "style" to me, so I don't understand the logic of that decision on the part of Adobe.

     
    |
    Mark as:
  • flaming1
    Currently Being Moderated
    3. flaming1,
    Aug 19, 2012 7:25 PM   in reply to Neil Weinberg
    Report

    It is possible - and it's fairly simple.

     

    To set the row height as part of the cell style, all you have to do is use the cell inset above and below. As long as you set the style as 'At least' then this works perfectly well for having predefined cell styles.

     

    I have been using this successfully for large financial documents for some time without any hitches. For example I use it to get separation between sections within the tables by having a style with extra space above, and similarly for totals rows at the bottom of the table. It can of course also apply different stroke styles at the same time. Having the style set as 'At Least' also allows for multiple line entries to still have the correct spacing above and below.

     

    So if you spend a bit of time calculating required heights and setting up your styles, then apply a keyboard shortcut to each style, you can then save a whole lot of time when formatting the document.

     

    I've just finished nearly 400 pages of financials using this method over the past couple of days!

     

    This solution may not suit your sitation, but if you have a lot of tables to get through it's got to be worth giving it a try.

     
    |
    Mark as:
  • Neil Weinberg
    Currently Being Moderated
    4. Neil Weinberg,
    Aug 20, 2012 2:16 AM   in reply to flaming1
    Report

    An elegant solution. Thanks very much!

     
    |
    Mark as:
  • flaming1
    Currently Being Moderated
    5. flaming1,
    Aug 20, 2012 2:59 PM   in reply to Neil Weinberg
    Report

    You're welcome Neil.

     
    |
    Mark as:
Actions

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