View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default need to input alternate blank rows in spreadsheet

--Insert a temporary column say (ColA)
--In cell A1 enter 1, in A2 enter A2..Autofill upto 24000
--Copy A1:A24000 to A24001:A48000
--Now sort ColA ascending
--Delete ColA

If this post helps click Yes
---------------
Jacob Skaria


"Confused from Hertford" 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?