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. --------------------------------- Groups are talking. We´re listening. Check out the handy changes to Yahoo! Groups. ************************************************************* 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 *************************************************************