ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   2lines worth of writing yet in one cell (https://www.excelbanter.com/excel-discussion-misc-queries/12760-2lines-worth-writing-yet-one-cell.html)

Asta

2lines worth of writing yet in one cell
 
How do i make it so that i have 2 lines of writing but its still 1 single cell?

Bernard Liengme

Use ALT+ENTER to split the text
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Asta" wrote in message
...
How do i make it so that i have 2 lines of writing but its still 1 single
cell?




Mike R

Alt + Enter if you need a hard return at a particular point or
Formatcellalignmentselect "text wrap"

"Asta" wrote:

How do i make it so that i have 2 lines of writing but its still 1 single cell?


Gord Dibben

Asta

first line

ALT + ENTER

second line


Gord Dibben Excel MVP

On Fri, 11 Feb 2005 15:25:04 -0800, "Asta"
wrote:

How do i make it so that i have 2 lines of writing but its still 1 single cell?




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

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