+ Reply to Thread
Results 1 to 3 of 3

Page Break Excel Help Needed ASAP

  1. #1
    Registered User
    Join Date
    10-09-2012
    Location
    USA
    MS-Off Ver
    Excel 2003, 2012
    Posts
    9

    Lightbulb Page Break Excel Help Needed ASAP

    Guys,

    Excel is automatically putting pagebreak after every single column. Would you please help me what is wrong in my attached sheet that causing this problem? I would appreciate if you could help me ASAP. Thank you so much in advance. I have tried changing printer and it still displays same.

    Thanks.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Page Break Excel Help Needed ASAP

    rows 2 and three are merged cells that span your entire workbook from column A to column II, un merge the cells then click the Page Layout/Page Setup/Print Tiles Button

    Then:
    set Print area: A1:II76
    Rows to repeat at top: $1:$9
    Columns to repeat at left: $A:$A
    Click Print Preview to make sure that it comes out to 8 pages
    grab a beer and celebrate!

  3. #3
    Valued Forum Contributor
    Join Date
    11-20-2012
    Location
    Seattle, WA USA
    MS-Off Ver
    Excel 2010
    Posts
    597

    Re: Page Break Excel Help Needed ASAP

    Book1 (3).xlsx
    here's the file pre-done for you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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