Why do you need alternate blank rows?
This will make it very difficult to sort, filter, copy and other stuff.
If for appearance only, maybe just increase the row height to double?
Gord Dibben MS Excel MVP
On Mon, 30 Nov 2009 02:28:01 -0800, Confused from Hertford <Confused from
wrote:
Need to input alternate blank rows into imported spreadsheet. Currently has
24000 lines of data and would like to find a way of not having to manually
input these blank rows! help! Also if this is possible will I be able to
format row height at the same time?