View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
margaret1115
 
Posts: n/a
Default How can I insert a blank row after every row with data with Excel

I need to insert a blank row after every row containing data (to facilitate
reading and adding survey data by hand) in an Excel spreadsheet. Is there any
way to do so automatically by selecting the data then doing some menu option
or keystroke? I can add a blank row with a macro but that is only a bit less
laborious than having to add each blank row by hand. Thank you for your help.
Margaret