View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default How do i insert blank rows between data that is thousands of rows


One way in this post... http://tinyurl.com/yupz9w
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"paul.eatwell"
wrote in message
I want to insert a blank row between each line of data that I have in the
quickest way possible. My spreadsheet is 12 000 rows long and want to do this
as quickly as possible. I know how to insert a row wherever I want but is
there a quick way, maybe a function I could use, that will insert a blank row
inbetween each row of data I have?
Please email me on...
many thanks
Paul