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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
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

Wrapping text leaves blank line when printing 1
Row height setting problem 8
How do I remove extra space when text wrapping? 2
I cannot delete the extra rows or columns in Excel 2007 2
Wrap text creates an extra line 7
Having Blank Cells, etc. ? 1
counting blank cells within two columns 2
Blank Lines Question 2

Back
Top