Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updating external data sheet causes loss of data on linked pages | Excel Worksheet Functions | |||
Sorting excel worksheet data, and ALWAYS maintain "row data" (in l | Excel Worksheet Functions | |||
Can you sort within worksheet with grouped cells & keep cell group | Excel Worksheet Functions | |||
Printing a group that is not grouped | Excel Discussion (Misc queries) | |||
How to maintain hyperlink when sorting data? | Excel Discussion (Misc queries) |