LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35
Default 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
 
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
updating external data sheet causes loss of data on linked pages C_F_Dewey Excel Worksheet Functions 0 August 28th 07 11:48 PM
Sorting excel worksheet data, and ALWAYS maintain "row data" (in l Dave86 Excel Worksheet Functions 3 August 24th 07 02:56 PM
Can you sort within worksheet with grouped cells & keep cell group A Kelly Excel Worksheet Functions 0 August 21st 07 04:34 PM
Printing a group that is not grouped jerminski73 Excel Discussion (Misc queries) 2 May 22nd 07 07:38 PM
How to maintain hyperlink when sorting data? KJ Excel Discussion (Misc queries) 2 October 16th 05 12:01 PM


All times are GMT +1. The time now is 05:07 AM.

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

About Us

"It's about Microsoft Excel"