Select all rows and double the height at FormatRowsHeight.

I do not recommend inserting a row between each existing row.

Would make filtering, sorting, copying, pasting and other operations very
difficult.


Gord Dibben MS Excel MVP

On Tue, 24 Jul 2007 09:52:07 -0700, tud52
wrote:

i have a very large worksheet and it is single spaced, i would like to make
it double spaced, is there a way to do that other than inserting an empty
row, one at a time?