How to Split the table and keep the header on each portion.

C

capxc

We would like to split the spreadshit in even portions of 2400 rows and keep
the header on each of them. How can this be done?
And, after it is done, can those portions be saved separately?
 
P

Pete_UK

In the next free column, enter this formula:

=ROW()-1

and copy down - it will give you a simple sequence 1, 2, 3, 4 etc,
assuming your data starts on row 2. Apply Autofilter to this column,
and from the filter drop-down select Custom and then choose Less than
or equal to and enter 2400. You can now select all the visible cells
including the header row and <copy> and paste them into a new
worksheet.

For your next batch you should choose Custom from the Filter drop-down
and choose two conditions:

Greater than 2400
And
Less than or equal to 4800

Again, highlight the visible cells including the header and copy/paste
into a new sheet. Keep doing this until you are finished, adjusting
the range of numbers as appropriate.

Finally, you can delete the original sheet and use File | Save As to
give the file a different name.

Hope this helps.

Pete
 
Top