+ Reply to Thread
Results 1 to 2 of 2

Printing - Sheet Options - Print Titles

  1. #1
    Registered User
    Join Date
    01-10-2011
    Location
    Garden Grove, CA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Exclamation Printing - Sheet Options - Print Titles

    Hello,

    The attached Excel printout shows an example of the header that we want to repeat on each applicable page at (1).

    We want to replicate the header on all subsequent pages, which is shown at (2).

    So, we went to the Page Layout and in the Sheet options, we asked that the row be repeated in all pages under "Print Titles."

    However, in the process of doing this, we now got an unnecessary header at (3). The report now looks weird. Can you suggest a way in that we can eliminate the problem at (3)?

    Thanks for your kind help!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Printing - Sheet Options - Print Titles

    It's not obvious from the printout why it's happening. Can you remove the private data then post the Excel file?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Print Titles with Dynamic Print Range
    By Daeghen in forum Excel General
    Replies: 0
    Last Post: 08-01-2011, 12:11 PM
  2. [SOLVED] excel chart options titles tab should allow copy paste in fields
    By belohls in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-11-2006, 10:20 AM
  3. Replies: 4
    Last Post: 02-17-2006, 08:36 AM
  4. [SOLVED] Why is the Print Titles option in Page Setup:Sheet greyed out?
    By timz in forum Excel General
    Replies: 2
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] print different row titles in one sheet w/ many pages
    By Carman Law in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-24-2005, 07:38 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1