H
haze2000
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
(?Pixel?).
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!
Haze
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...
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
(?Pixel?).
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!
Haze
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...