View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Russell@Tikit Russell@Tikit is offline
external usenet poster
 
Posts: 1
Default Row height representations in print/print preview

All,

I have devised a spreadsheet that functions as a PO for clients, which
requires a lot of word-wrapped text for product descriptions, but I have
noticed that when it comes to printing (to file or to hard copy), often the
row height cuts off the text in the cell when it has multiple lines. This is
despite the cell appearing fine on the screen and the rows being set to
autoheight.
A work-around is to alt+return for a line or so after each but this ruins
the uniformity of the spreadsheet and takes much trial and error; is there a
way to re-configure the autoheight function so that it displays the correct
cell height on each, in real terms?
Thanks,