ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Space within cells (https://www.excelbanter.com/excel-discussion-misc-queries/259560-space-within-cells.html)

j

Space within cells
 
How do you create a space between sentences within one cell?

Jim Thomlinson

Space within cells
 
Use Alt + <Enter to add a carriage return to your cell.
--
HTH...

Jim Thomlinson


"J" wrote:

How do you create a space between sentences within one cell?


Dave Peterson

Space within cells
 
Hit the space bar?

If you mean you want to force the next sentence onto a new line within that
cell, hit and hold the alt key when you hit Enter.

If you see a little box where that alt-enter is, then you have to change the
wrap text property.

Rightclick on that cell
Format Cells|Alignment tab|check "Wrap text"




J wrote:

How do you create a space between sentences within one cell?


--

Dave Peterson

Roger Govier[_8_]

Space within cells
 
Hi

Type Alt + Enter to force a line wrap
--
Regards
Roger Govier

J wrote:
How do you create a space between sentences within one cell?



All times are GMT +1. The time now is 07:31 AM.

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