Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
LarryF
 
Posts: n/a
Default Limiting the # of pages for Repeat Column Labels

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   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.



Reply
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
Change the width of a single column in a column chart Dave Charts and Charting in Excel 2 December 13th 04 07:25 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 01:55 AM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 0 November 26th 04 03:19 PM


All times are GMT +1. The time now is 08:28 AM.

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

About Us

"It's about Microsoft Excel"