Limiting the # of pages for Repeat Column Labels

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat Pivot Row on when printing 1
Repeating first Row AND first column on every page 1
Printing column label on every page. 2
Excel2000:How to link Print Area with a named range 5
How can I have Excel cells populate a Word label template? 1
column labels 2
Print Titles - Columns to Repeat at Left 1
how do i average the totals of multiple cells, that have the same label 5

Back
Top