View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WCM WCM is offline
external usenet poster
 
Posts: 59
Default Insert Row between items in list ...

Hi ...

I have an Excel sheet with 5,000 names in one column. Is there any fast way
to insert a row after every name so the names appear on every other row (i.e,
list will then occupy 10,000 rows, one empty row after each name)?

I can do this with a macro, but wanted to make sure there wasn't a simple
function or other Excel feature that is designed to do this.

Thanks for your help ...

bill