#1   Report Post  
cdavis82
 
Posts: n/a
Default 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
  #2   Report Post  
Bill Ridgeway
 
Posts: n/a
Default 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



Reply
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
Adding five new rows every 40 rows in a spreadsheet? Olzki Excel Discussion (Misc queries) 8 May 18th 07 02:14 AM
Adding Rows Richard Excel Discussion (Misc queries) 1 October 10th 05 03:58 PM
adding rows to pivot table cwinters Excel Discussion (Misc queries) 2 June 6th 05 06:22 PM
Adding summaries, rows and pre-population JFH New Users to Excel 1 May 24th 05 08:52 PM
Adding Rows to Master Sheet Excel Newbie New Users to Excel 1 December 23rd 04 11:56 PM


All times are GMT +1. The time now is 04:14 PM.

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

About Us

"It's about Microsoft Excel"