Row height limit of 409

Row height limit of 409

Post by haze200 » Sat, 19 Jun 2004 00:26:00

Hello all,

I need to print out an Excel Sheet with a lot of texte in Cells.
The Sheet is created from SAP R/3.

However the cells have wordwrap activated - and the text has to be i
different "lines" (ALT-ENTER) - But I can't see the whole text (an
it's not printed either) because I can't make the ROW higher than 40

One soloution could be making the Font smaler...
Does someone has a Macro , that automatically reduce the font till th
text fitts into the cell?
(Shrink to fitt doesn't work with wordwrap!)

Are there Printer settings that would allow me to print all text i
these cells?

Thanks for your support!


P.s.: Merge Cells isn't easy to do - becuase I would have to make th
decession in R/3 - and the EXCEL should be sortable...

Row height limit of 409

Post by Gord Dibbe » Sat, 19 Jun 2004 06:45:06

Have a look here for work-around to get 15,000+ to show in cell.

Gord Dibben Excel MVP

On Thu, 17 Jun 2004 10:26:00 -0500, haze2000