Group data and maintain grouped data on dedicated pages

[Erol]

I have a total of 15 rows of data. They are divided to 3 section; therefore
each section has 5 rows. When I print the whole excel sheet first page should
have 5 rows of data (1st section), second page should have another 5 rows of
data (2nd section) and third page should have the last 5 rows of data (3rd
section).

I want to be able to group (or ungroup) data in first 5 rows but when I
print it I want to make sure the 2nd section (5 rows of data) is still in 2nd
page and 3rd section (5 rows of data) is still in 3rd page.

Is there anyway to do this? (I have MS Office 2000, would this limit me on
this ability?)

Thanks in advance

 

[Ashish Mathur]

Hi,

First of all, Group data by using Data > Subtotal. In the Subtotal window,
there is a check box for "page breaks between groups"

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[Erol]

Thanks Ashish,

When I use data>subtotal and then "page break" it breaks each row to
different pages. Which was good to learn. I wanted to only page break after
every 5 rows. But I wasn't so aware of "page break" function and thanks to
you know I know I can use it. I guess I will just put manual page break after
every 5 rows, because that solves my problem.

Thanks again

 

[Ashish Mathur]

Hi,

If you want to insert a page break after every 5 rows, insert another column
indicating the group number. So you will have 3 numbers (for 3 groups).
then sort this column and now run Data > Subtotals

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com