Group data and maintain grouped data on dedicated pages
 

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

Group data and maintain grouped data on dedicated pages
 

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" wrote in message
...
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

Group data and maintain grouped data on dedicated pages
 

Thanks Ashish,

When I use datasubtotal 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" wrote:

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" wrote in message
...
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

Group data and maintain grouped data on dedicated pages
 

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

"Erol" wrote in message
...
Thanks Ashish,

When I use datasubtotal 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" wrote:

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" wrote in message
...
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