Adding rows
I have a 800 line workbook that I want to add rows to. I only want to add a
row to every 8th row but I don't want to do it by hand. I can't find any place to do a "conditional" add a row. Thanks |
Adding rows
Add a helper column.
Number the rows 1 through 7, 9 though 15 etc. Number remaining rows 8, 16 etc. (Highlighting at least two cells and extending them takes the tedium out of it). Sort the spread sheet on the helper column. Regards. Bill Ridgeway Computer Solutions "cdavis82" wrote in message ... I have a 800 line workbook that I want to add rows to. I only want to add a row to every 8th row but I don't want to do it by hand. I can't find any place to do a "conditional" add a row. Thanks |
All times are GMT +1. The time now is 11:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com