Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

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

Re: carriage return in the formula bar

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.

Re: carriage return in the formula bar, Thanks for the tip

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.