ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i write a sentence in a cell? (https://www.excelbanter.com/excel-discussion-misc-queries/34617-how-do-i-write-sentence-cell.html)

mega meg 13

how do i write a sentence in a cell?
 
im reli confused i dont no how to write a sentence in a exel cell without it
running into the cell next to it n its buggin me cos im having to ut a good
paragragh in a cell n its not workin

Max

Select the column, say col A
Click Format Cells Alignment tab
Check "Wrap text" OK

Now when you type in col A, the text will wrap around w/o running into the
next cell. You could of course, increase the width of the column by dragging
the right edge of the column header to the right, etc

And if you need to break for a new line within the same cell,
press Alt + ENTER

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"mega meg 13" <mega meg wrote in message
...
im reli confused i dont no how to write a sentence in a exel cell without

it
running into the cell next to it n its buggin me cos im having to ut a

good
paragragh in a cell n its not workin





All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com