ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How can i set consecutive columns in an excel worksheet to differ. (https://www.excelbanter.com/charts-charting-excel/244-how-can-i-set-consecutive-columns-excel-worksheet-differ.html)

Adam H

How can i set consecutive columns in an excel worksheet to differ.
 
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

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


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

Regards

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



Barb Reinhardt

You might be able to merge cells to approximate the effect that Adam wants.

"Stephen Bullen" wrote in message
...
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


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

Regards

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






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

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