How do I remove extra blank lines in a column when I print?

G

Guest

I am using Excel 2002 SP3. I have some columns (not all) which span multiple
lines. I have word wrap clicked on. When view the spreadsheet, the text
appears to be formated fine, however when I print it, many of the rows have
blank lines at the end. I have searched and searched for these blank rows to
eliminate them and have been unsuccessful.
 
G

Guest

I'm not sure if you're referring to actual blank rows on the spreadsheet, or
ones within a specific cell of word-wrapped text, caused by
control-characters........in either event, ASAP Utilities, a free add-in
available at www.asap-utilities.com has features to fix the problem.

Vaya con Dios.
Chuck, CABGx3
 
G

Guest

Did you check your print setup? Highlighted only the area you want to print?
Did you try deleting them? Check the doc in print preview.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Row height setting problem 8
Blank Lines Question 2
I cannot delete the extra rows or columns in Excel 2007 2
Printing truncates cell contents 6
How do I remove extra space when text wrapping? 2
In Excel, how do I get blank rows and columns to print? 6
blank lines in text cells 4
How can I remove extra space when using autofit in Excel 2003? 3

Top