ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   rows within a cell? (https://www.excelbanter.com/excel-worksheet-functions/132500-rows-within-cell.html)

AK Maine-iac

rows within a cell?
 
I would like to enter a name and address per cell. So it would have 3 rows in
rach cell. Is that doable?

Jane Doe
123 a street
yoiur city, state 12345

Gary''s Student

rows within a cell?
 
insert ALT-ENTER in the text to make the linebreaks
--
Gary''s Student
gsnu200708


"AK Maine-iac" wrote:

I would like to enter a name and address per cell. So it would have 3 rows in
rach cell. Is that doable?

Jane Doe
123 a street
yoiur city, state 12345


Bob Phillips

rows within a cell?
 
Put Alt-Enter between the text you want to break. Set wrap text
(FormatCellsAlignment), and increase the height.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"AK Maine-iac" wrote in message
...
I would like to enter a name and address per cell. So it would have 3 rows
in
rach cell. Is that doable?

Jane Doe
123 a street
yoiur city, state 12345




AK Maine-iac

rows within a cell?
 

thanks! veery helpful
"Gary''s Student" wrote:

insert ALT-ENTER in the text to make the linebreaks
--
Gary''s Student
gsnu200708


"AK Maine-iac" wrote:

I would like to enter a name and address per cell. So it would have 3 rows in
rach cell. Is that doable?

Jane Doe
123 a street
yoiur city, state 12345


AK Maine-iac

rows within a cell?
 


"Bob Phillips" wrote:

Put Alt-Enter between the text you want to break. Set wrap text
(FormatCellsAlignment), and increase the height.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"AK Maine-iac" wrote in message
...
I would like to enter a name and address per cell. So it would have 3 rows
in
rach cell. Is that doable?

Jane Doe
123 a street
yoiur city, state 12345



Thanks, very helpful



All times are GMT +1. The time now is 06:46 PM.

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