| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Entering multiple lines of text in a cell
I am creating a spreadsheet and would like to enter multiple lines of text in
a given cell as shown he 1 = Money 2 = Show 3 = Ready 4 = Go I can't figure out how to enter the text in a cell so it lines up as shown above. Thank you for any help. -- Charles Allen, MVP |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering multiple lines of text in a cell
You should be able to get away with <Alt+Enter
1 = Money <Alt+Enter 2 = Show etc. "Charles Allen" wrote: I am creating a spreadsheet and would like to enter multiple lines of text in a given cell as shown he 1 = Money 2 = Show 3 = Ready 4 = Go I can't figure out how to enter the text in a cell so it lines up as shown above. Thank you for any help. -- Charles Allen, MVP |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering multiple lines of text in a cell
Beautiful! I tried Shift and Ctrl but didn't think of trying Alt. Thank you.
-- Charles Allen, MVP "Sean Timmons" wrote: You should be able to get away with <Alt+Enter 1 = Money <Alt+Enter 2 = Show etc. "Charles Allen" wrote: I am creating a spreadsheet and would like to enter multiple lines of text in a given cell as shown he 1 = Money 2 = Show 3 = Ready 4 = Go I can't figure out how to enter the text in a cell so it lines up as shown above. Thank you for any help. -- Charles Allen, MVP |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering multiple lines of text in a cell
Happy to help! I actually learned that one on this board a while back...
"Charles Allen" wrote: Beautiful! I tried Shift and Ctrl but didn't think of trying Alt. Thank you. -- Charles Allen, MVP "Sean Timmons" wrote: You should be able to get away with <Alt+Enter 1 = Money <Alt+Enter 2 = Show etc. "Charles Allen" wrote: I am creating a spreadsheet and would like to enter multiple lines of text in a given cell as shown he 1 = Money 2 = Show 3 = Ready 4 = Go I can't figure out how to enter the text in a cell so it lines up as shown above. Thank you for any help. -- Charles Allen, MVP |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Entering multiple lines of text in a cell
You can enter multiple lines of text in a cell by pressing ALT ENTER
at the end of each line. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 14 Jan 2009 12:02:06 -0800, Charles Allen wrote: I am creating a spreadsheet and would like to enter multiple lines of text in a given cell as shown he 1 = Money 2 = Show 3 = Ready 4 = Go I can't figure out how to enter the text in a cell so it lines up as shown above. Thank you for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple lines of text within one cell | Excel Discussion (Misc queries) | |||
| Multiple Lines of Text in One Cell | Excel Discussion (Misc queries) | |||
| Multiple lines of text in a cell | Excel Discussion (Misc queries) | |||
| Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
| Multiple lines of text in a cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
