View Single Post
  #2   Report Post  
David McRitchie
 
Posts: n/a
Default

Hi Larry,

In other words you want two different kinds of formatting so you would
use tow different worksheets. You can select both sheets when you
are ready to print with the help of the Ctrl+ key. Don't forget to
ungroup your sheets after issuing the File, Print as any change you
make to the visible sheet would cause destruction of data on the unseen
grouped sheet(s).

To ungroup sheet, right click on a worksheet tab, and use "Ungroup Sheets",
OR select a worksheet tab not in the group so that only one sheet is selected.

Page numbers will run consecutively through all of the grouped sheets.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"LarryF" wrote in message ...
How/Can I limit or specify the number of pages in an Excel 2003 report that
repeats the "print column labels"? I have 22 pages of financials that require
the labels. I want to add two or three pages of mostly text after the numbers
are presented. Thanks.