Defining Hight of Every Other Row

  • Thread starter Thread starter Amr Tabbarah
  • Start date Start date
A

Amr Tabbarah

I often need to change the row height of every other row and searching
for a way to do that other than selecting each every other row before
using Format/Row/Height.
 
Amr,

If you copy two rows, one changed and one unchanged, then you can
select a large block of an even number of rows and use pastespecial
format to change the row heights in the alternating pattern.

HTH,
Bernie
MS Excel MVP
 
Bernie,

Thanks. I have tried it and it works well for new/empty sheets.
However, for existing sheets, copying the format of the 2 rows changes
all the previously set format for the rows the height of which I want
to change.

Is there a way to overcome this?


Amr
 
Back
Top