A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » Excel Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How do I remove extra space when text wrapping?



 
 
Thread Tools Display Modes
  #1  
Old March 20th 09, 08:31 PM posted to microsoft.public.excel.worksheet.functions
chosen-girl[_2_]
external usenet poster
 
Posts: 1
Default How do I remove extra space when text wrapping?

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?
Ads
  #2  
Old March 21st 09, 03:34 AM posted to microsoft.public.excel.worksheet.functions
joel
external usenet poster
 
Posts: 9,101
Default How do I remove extra space when text wrapping?

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

Format - Cells - Alignment - Top

"chosen-girl" wrote:

> 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?

  #3  
Old March 21st 09, 05:58 AM posted to microsoft.public.excel.worksheet.functions
Hardeep_kanwar[_2_]
external usenet poster
 
Posts: 103
Default How do I remove extra space when text wrapping?

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




"chosen-girl" wrote:

> 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?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I remove extra space when text wrapping? chosen-girl Excel Discussion (Misc queries) 2 March 17th 09 07:25 PM
Remove an extra space after a number. Hummingbird Excel Worksheet Functions 3 March 11th 09 08:31 PM
How do I remove a space infront of text in a cell? GAC Excel Discussion (Misc queries) 7 October 10th 06 01:41 AM
Issues with white space when printing & with wrapping text Michelle Excel Discussion (Misc queries) 0 June 15th 06 10:02 PM
Remove Space in Text Tian Excel Discussion (Misc queries) 5 April 6th 06 07:09 PM


All times are GMT +1. The time now is 02:07 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 ExcelBanter.
The comments are property of their posters.