| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert 5 rows between existing values in a single column 1
I have a sheet with over 10,000 rows of existing data, all in a single column.
I need to insert 5 rows in between each existing row quickly and easily. Doing it manually is not so efficient! For example: F14745 F14746 F14747 needs to become: F14745 F14746 F14747 etc., Likey a way to do this with a Macro, but I don't have a clue on how to do it. Easy way seems to elude me. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I insert a colon into a column of existing numbers | Excel Discussion (Misc queries) | |||
| to allocate unique a number to existing rows & new insert of row | Excel Discussion (Misc queries) | |||
| Insert Rows between the existing rows | Excel Discussion (Misc queries) | |||
| Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
| Insert Rows into an existing array | New Users to Excel | |||
Threaded Mode
