![]() |
how to insert a 'carriage return' in a cell?
what i mean is my cell is definetly wide enough to accomodate three
lines of text because i am writing it in Times, point 8 and i have widened the cell dimensions. At the moment I am having to continously press the space bar to reach a new line and then type the next sentence and so on (which is just silly). By the way, I know there is a wrap text and shrink to fit but that's not what i am trying to do here. An example (sort of). Imagine this is the cell: ________________________________________ What i mean is my cell is definetly wide enough. to accomodate three lines of text. because i am writing it in Times, point 8. ________________________________________ |
how to insert a 'carriage return' in a cell?
Use ALT-ENTER.
HTH, Elkar "showsomeidnow" wrote: what i mean is my cell is definetly wide enough to accomodate three lines of text because i am writing it in Times, point 8 and i have widened the cell dimensions. At the moment I am having to continously press the space bar to reach a new line and then type the next sentence and so on (which is just silly). By the way, I know there is a wrap text and shrink to fit but that's not what i am trying to do here. An example (sort of). Imagine this is the cell: ________________________________________ What i mean is my cell is definetly wide enough. to accomodate three lines of text. because i am writing it in Times, point 8. ________________________________________ |
how to insert a 'carriage return' in a cell?
Elkar, so 'simple' (when you know how), and yet so effective. now i
know how and i know it's effective! thank you so much; you're an absolute star*. |
All times are GMT +1. The time now is 12:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com