How do I enter a line break within a cell?
|
How do I enter a line break within a cell?
ALT + ENTER
Gord Dibben Excel MVP On Thu, 17 Nov 2005 11:15:15 -0800, "Striving for efficiency" wrote: |
How do I enter a line break within a cell?
alt-enter if you're typing
or "& char(10) &" if you're using a formula: ="this is line 1" & char(10) & "this is not line 1" format|Cells|alignment tab|check wrap text. Striving for efficiency wrote: -- Dave Peterson |
How do I enter a line break within a cell?
does anyone else get an error when responding to a post with no text? I
can't respond at all to these posts. "Gord Dibben" wrote: ALT + ENTER Gord Dibben Excel MVP On Thu, 17 Nov 2005 11:15:15 -0800, "Striving for efficiency" wrote: |
All times are GMT +1. The time now is 04:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com