Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
One of my customers has asked for some space to appear between rows on one of the reports I've developed so that he can manually annotate some of the figures.
The information in question appears as a straight table. Does anybody know how I can force each row in a straight table to be a certain height?
I'm not sure if this would be easier if the information was displayed in a table box or a pivot table. However, if possible I'd rather not go down this route, as apart from the row height, everything else in by straight table looks perfect.
Can anyone make a suggestion?
Many thanks
Steve
Hi.
Try Properties->Presentation->Wrap Cell Text.
Hi Stephen,
I don't know of a way to make it a specific height but you can try changing with this Wrap Cell Text Cell Height
You cannot set a height as X pixels, but you can set the number of lines used by each row.
This is on the Presentation tab in the lower right corner - tick Wrap Cell Text and set the number of lines.
Thanks for this, within a few minutes I got 3 answers, all the same, all pointing me to a feature thatdoes the job well enough.
Cheers
Steve