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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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

"Amr Tabbarah" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> 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.
>
>
>
> ------------------------------------------------
> ~~ Message posted from http://www.ExcelTip.com/
> ~~ View and post usenet messages directly from
http://www.ExcelForum.com/
>

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/