Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
New Lines in an Excel cell
Name: KansaiJin2 Date: June 11, 2004 at 07:49:29 Pacific OS: W XP CPU/Ram: .
Comment:
Very simple question
How can I use new lines inside the text in one single cell???
Name: Report_2 Date: June 11, 2004 at 09:03:08 Pacific
Reply:
Not sure if I understand but hit F2 to Edit Cell. When done adding your text go to Format, Cells, Alignment and select "Wrap Text". When adding your text you may need to add spaces in between the words in order to get it to separate into the lines you want.
HTH Bryan
0
Response Number 2
Name: Gavin Davis Date: July 22, 2004 at 10:44:54 Pacific
Reply:
You can break a long text entry on a spreadsheet into separate lines by positioning the cursor in the cell entry where you want the new line to start and pressing Alt+Enter. Excel automatically wraps the text in the cell, according to the cell's column width and the position of the line break.
Summary: Thanks Bryco, and rhawk7938 I installed Row Liner but can not get rid of the red lines on the rows and columns so have it turned off at the moment, will play with it later but some of the fuctions ar...
Summary: I have Office XP and would like to create a new line in a mailto command. I have looked at all the obvious but I simply cannot do it. @echo off cls start "" "mailto:support@computing.net?subject=Want ...
Summary: I am trying to code a carriage return within an excel cell using vbscript. When I append chr(10) or Chr(10) & Chr(13) to the string that is being written in the cell, it begins a new row in the excel ...
0 
