How can i set consecutive columns in an excel worksheet to differ.

A

Adam H

Just trying to create a worksheet and the need to have different row heights
in alternating columns is necessary, or can i change the height of one cell
only? Imagine each row in column 1 is 20 units high. I want all the rows in
column 2 to be 20 units high too except in row 1, which I want to be 30 units
high, so 99% of column 2 is offset (I guess it would like a typical brick
pattern for a wall) Sorry if this is confusing but any help would be greatly
appreciated. Running xppro
Adam
 
S

Stephen Bullen

Hi Adam,
Just trying to create a worksheet and the need to have different row heights
in alternating columns is necessary, or can i change the height of one cell
only? Imagine each row in column 1 is 20 units high. I want all the rows in
column 2 to be 20 units high too except in row 1, which I want to be 30 units
high, so 99% of column 2 is offset (I guess it would like a typical brick
pattern for a wall) Sorry if this is confusing but any help would be greatly
appreciated. Running xppro
Click to expand...

No, sorry. You can only set the height of an entire row.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to set the desired column width for a table with merged cells 0
Unable to set the desired column width for a table with merged cells 0
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
Row reference for consecutive series calculation 0
Comparing 2 columns from 2 different Worksheet and Returing Value of a 3rd column 2
how do I set up or adjust my column chart? 2
How can I combine data that is in 2 rows to 1 row 7
Six columns randon no.'s no dupes 6

Top