New Line in Cell

S

Sprinks

In preparing reports in Excel, one of our managers would like to present
items on another line within the same cell, like:

1st Draft Due
Final Review
etc.

Does anyone know if this is possible?

Thank you.
Sprinks
 
B

Bob Flanagan

After you type "1st Draft Due", press ALT-Enter. This takes you to the next
line in the cell.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
 
C

challa prabhu

Hi,

1. Double-click the cell.
2. Press Alt+Enter to move the cursor to the next line.
3. On the Format menu, Click Cell.
The Format Cell dialog box is displayed.
4. Click the Alignment Tab.
5. Under Text control, Select the Wrap Text check box.
6. Click Ok. To return to the Worksheet.

Challa Prabhu
 
Top