Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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. |
#2
![]() |
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change the width of a single column in a column chart | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |