ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to insert a 'carriage return' in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/142002-how-insert-carriage-return-cell.html)

showsomeidnow[_2_]

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.
________________________________________


Elkar

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.
________________________________________



showsomeidnow[_2_]

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