Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Adam H
 
Posts: n/a
Default 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
  #2   Report Post  
Stephen Bullen
 
Posts: n/a
Default

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


  #3   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"