Stacie

How many are you looking to insert?

If it is just say 20, hold the ctrl key down while selecting every other row
and then taking the menu option you outline, it will insert a row at each
selection. (Depending on your data you may need to repeat)

If it's hundreds we could use code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Stacie" wrote in message
...
I need to know if there is a way to insert one row in between each line on
a
worksheet without having to click "insert" then "row" everytime?