How to add a new line inside a (text-formatted) cell?

  • Thread starter Thread starter Guest
  • Start date Start date
Use Alt-Enter.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

VHE said:
Hi, does anybody know how a new line is inserted inside a text-formatted
cell?
 
Hi, does anybody know how a new line is inserted inside a text-formatted cell?

Alt+Enter

Search Help for "Display multiple lines of text within a cell" which
gives:
Select the cells you want to format.
On the Format menu, click Cells, and then click the Alignment tab.
Under Text control, select the Wrap text check box, and then click OK.
To start a new line of text at a specific point in a cell, click where
you want to break the line, and then press ALT+ENTER.
 
-----Original Message-----
Hi, does anybody know how a new line is inserted inside a text-formatted cell?
.
ALT + Enter places a hard return in a cell. But beware
they are awkward to remove

Regards
Peter
 
Back
Top