How do I remove extra space when text wrapping?

C

chosen-girl

I am working in Excel 2007. I have a column with cells containing various
lengths of text. The control is set on wrap text and the alignment is on
bottom. The problem is that all of the cells look fine on the screen,
however, when I print there is added space (a whole blank line) at the
beginning of some of the cells. The cells are not sizing themselves
properly. Trim does not work to remove the space. Any suggestions?
 
J

Joel

Try setting the cell vertical allignment to the top of the cells using the menu

Format - Cells - Alignment - Top
 
H

Hardeep_kanwar

Try This
Press CTRL+H
Find What : ALT+0160
Replace With: Blank
Ok

Note: When you type 0160 in find What Hold the ALT Key While Entering the 0160
 

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

How do I remove extra space when text wrapping? 2
Text Wrapping 2
Wrapping Text in Merged Cells 4
Remove an extra space after a number. 3
How do you wrap larger quantites of text? 4
Remove non-space spaces? 3
Space round text in cells 0
Wrapping text 1

Top