Discussion Locked

Text prints outside gridlines on Excel

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In order to get all columns on one page of a particular document, I reduced the scale to 85%. The columns are set to wrap-around. I did an autofit for the rows. However, when I print it, the data in several of the cells overlaps the cell above it. If there is data in the cell above, the text will print over the text above. Can't figure out how to get the cells large enough without doing each line individually.

Thanks.

3 replies

by chainsawz

This worked for me: after setting the wrap text, highlight the range of cells. Then select Format - AutoFormat, and go into options. Make sure that the width/height button is selected, then click ok. The cells should automatically resize,and not overlap.
I hope this works for you!

This discussion is closed to new replies.