Select the source row, press CTRL-C

Select the target range, right-click-Paste Special-Formats...
this will copy ALL the formatting of source to destination...

If you just want to change height then choose Format-Columns and enter the
height desired.


"Markman" wrote:

I would like to copy my row height from the first 50 rows to the next 50 rows
and so on in the same work sheet. This would save alot of time. Thanks