How do you start a new line within a cell?
I think this is a very basic question, but how do you start a new line
(or break a line) within a cell? When I try to hit enter, the hightlight just moves to the next cell. Thank you. |
hi,
data in a cell is stored as a continuous string. there is no "new line" per say. but you can wrap the text. formatcellsalignment tab check wrap text. this way the text in the cell will seem to be on different lines. regards FSt1 " wrote: I think this is a very basic question, but how do you start a new line (or break a line) within a cell? When I try to hit enter, the hightlight just moves to the next cell. Thank you. |
Use ALT-ENTER rather than ENTER
-- Gary's Student " wrote: I think this is a very basic question, but how do you start a new line (or break a line) within a cell? When I try to hit enter, the hightlight just moves to the next cell. Thank you. |
Use Alt-Enter
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message oups.com... I think this is a very basic question, but how do you start a new line (or break a line) within a cell? When I try to hit enter, the hightlight just moves to the next cell. Thank you. |
use alt and enter or either go to cell formatting and select work wrap |
All times are GMT +1. The time now is 10:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com