LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Matching items in 2 list to consolidate to one list hot dogs Excel Discussion (Misc queries) 2 April 25th 07 04:01 PM
Items on Insert ribbin on excell 2007 are grayed out. Why? Bill Excel Discussion (Misc queries) 3 April 19th 07 06:50 PM
How do I delete items in one list from another list? Danielle Excel Discussion (Misc queries) 4 December 13th 05 02:32 AM
named range, data validation: list non-selected items, and new added items KR Excel Discussion (Misc queries) 1 June 24th 05 05:21 AM
sum particular items from a list Jeff Excel Discussion (Misc queries) 3 March 1st 05 03:50 PM


All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"