MrExcel Publishing
Your One Stop for Excel Tips & Solutions

carriage return in the formula bar


Posted by steven scaife on October 02, 2001 2:45 AM

Is it possible to do a carriage return in the formula bar.

for example.

if i have the following text: [terms, day 1: do this, day 2: do something else] in a cell is it possible to format it so that it looks like

terms,
day 1: do this
day 2: do something else

cheers

steven scaife


Posted by Amanda Pitter on October 02, 2001 3:52 AM

Try using [Alt] [Enter] when typing in the text. This should put in the carriage return for you.

Posted by steven scaife on October 02, 2001 4:30 AM