Rows with cells of varying number of lines

  • Thread starter Thread starter GWC
  • Start date Start date
G

GWC

How do I set-up my spreadsheet so:

A1 contains one line
B1 contains one line
C1 contains one line
D1 contains one to many lines
E1 contains one line
F1 contains one to three lines
G1 contains one line
H1 contains one to many lines


Note: The subsequent rows have the same situation as row 1
 
Hi,

Am Tue, 18 Nov 2014 20:02:21 -0800 (PST) schrieb GWC:
A1 contains one line
B1 contains one line
C1 contains one line
D1 contains one to many lines
E1 contains one line
F1 contains one to three lines
G1 contains one line
H1 contains one to many lines
Click to expand...

how do you create the new line? If you do it with Alt+Enter you can
count char(10):
For 3 lines only:
Data Validation => Custom =>
=LEN(F1)-LEN(SUBSTITUTE(F1,CHAR(10),))<=2


Regards
Claus B.
 
If I use ALT+ENTER to create multiple lines in a cell will the rest of the cells in that row become taller too?
 
Hi,

Am Wed, 19 Nov 2014 06:17:44 -0800 (PST) schrieb GWC:
If I use ALT+ENTER to create multiple lines in a cell will the rest of the cells in that row become taller too?
Click to expand...

yes, a row has the same height over all the columns. You can't create
cells with different height in one row.


Regards
Claus B.
 
Hi,

Am Wed, 19 Nov 2014 06:34:39 -0800 (PST) schrieb GWC:
How can I combine the contents in cells C3, D3, E3 and F3 into one cell?
Click to expand...

if you want wrap text format the cell and then:
=C3&CHAR(10)&D3&CHAR(10)&E3&CHAR(10)&F3
Else replace char(10) with " "


Regards
Claus B.
 
Back
Top