+ Reply to Thread
Results 1 to 1 of 1

Repeat rows ONLY before page break

  1. #1
    Registered User
    Join Date
    08-30-2013
    Location
    Kansas City
    MS-Off Ver
    Excel 2003
    Posts
    1

    Repeat rows ONLY before page break

    This may or may not be possible. I am writing a report in JET which is an Excel based formula. The report is set to produce multiple sheets based on projects. I have a page break inserted after revenue and expense that will then give the restricted support information which I'd like on it's own page. My problem is, I only want the rows to repeat before the page break because the data included at the page break has it's own column heading. I hope that make sense I feel like I'm rambling.


    Under Page Layout|Margins|Sheets|Rows to repeat, I've selected the rows below and the systems generates data.
    Resp Center Object Code Object Code/Description FY 2014 Approved Budget FY 2014 Budget Reprojections Current Month Operating Actuals for 07/31

    This is where my page break is inserted, so at this point, I do not want excel to repeat the rows listed above.
    Resp Center Fund Number Fund Name FY 2014 Approved Budget FY 2014 Budget Reprojections Current Month Restricted Support for 07/31
    Last edited by ddwash; 08-30-2013 at 12:54 PM.

+ 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. [SOLVED] Page Layout (Page Break Preview) is not working with hidden rows in excel.
    By ebin charles in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-31-2013, 03:32 AM
  2. Replies: 2
    Last Post: 03-02-2013, 01:34 AM
  3. [SOLVED] Rows to repeat on each page
    By jpreman in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-16-2006, 10:40 AM
  4. Conditional page break if merged rows won't fit on the page.
    By zbprtal in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2006, 04:00 PM
  5. Rows to repeat at top Except for the last page
    By nenzax in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2006, 01:10 PM

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