[mso] Re: EXCEL - REMOVING THE ALT CR USED FOR SECOND ETC. LINES IN A CELL..
- From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Mon, 7 Aug 2006 01:26:14 +1000
Not sure quite what you are meaning by "Line Break". It may not be the same
as my definition.
If you mean a break input with Alt-Enter, then just put your cursor on the
first word of the second line and hit the backspace key - then the space key
(assuming you want a space between the two words).
However, Excel might still do an auto line wrap.
If you want to stop Excel doing a line wrap, go to the cell formatting and
uncheck the wrap checkbox. (But first make sure you don't have any
Alt-Enter breaks in the cell.)
Also make sure you don't have an Alt-Enter at the end of the contents of the
cell. Just edit the cell and right-arrow until the cursor stops moving. If
it's on a line by itself, hit backspace to remove the trailing Alt-Enter.
If you are using copy/paste to bring text into a cell from a text file, then
carriage returns in the text file will become Alt-Enter breaks in the cell.
Regards, Dave S
----- Original Message -----
From: "Jamshed F. Mehta" <roameri@xxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Sunday, August 06, 2006 8:22 PM
Subject: [mso] EXCEL - REMOVING THE ALT CR USED FOR SECOND ETC. LINES IN A
CELL..
> Dear Dave:
> Format Row > Autofit did not do it.
> But Format Cell > Line Wrap did it.
> But still, how can I delete a " Line Break" ?
> Cheers !!!
> j.
>
> From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
>
> To: <mso@xxxxxxxxxxxxx>
> Date: Sun, 30 Jul 2006 16:00:41 +1000
> I suspect your row has a specific height. Format the row to autofit and
> see if it fixes it. (You don't need Alt-Enter to see the rest of the
> contents of a cell, unless you want the line breaks at a specific place.
> Simply format the cell for line wrap.) Regards, Dave S -----
> Original Message ----- From: "Jamshed F. Mehta" <roameri@xxxxxxxxx> To:
> <mso@xxxxxxxxxxxxx> Sent: Sunday, July 30, 2006 3:17 PM Subject: [mso]
> EXCEL - REMOVING THE ALT CR USED FOR SECOND ETC. LINES IN A CELL. >
> Dear All: > I have entered data in a cell and to fit it into the coloumn
> width, I > used ALT + ENTER to get the second and subsequest lines.
> Later I extended > the width of the coloumn. The cell was aligned
> vertically for TOP. Now > since the three lines' data fits into two
> lines I have a blank third line. > I used DELETE at the end of the
> second line to remove the blank third line > but that does not do it.
> How can I do it ? > Thanks, > j.
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
