+ Reply to Thread
Results 1 to 2 of 2

insert header/footer causes split

  1. #1
    Registered User
    Join Date
    01-26-2015
    Location
    sacramento ca
    MS-Off Ver
    10
    Posts
    7

    insert header/footer causes split

    excel 2007, when I insert a header/footer, it splits the sheet, if its the default new sheet it splits after column j, so its trying to make sheets about 7" wide. How do I stop this behavior???
    If I widen some columns then columns to right get pushed into the 'split' second sheet to the right.
    I have used other versions of excel that don't do this, and my version 2007, did not do this until all of sudden today
    This is some parameter setting somewhere?
    This is very annoying and frustrating

  2. #2
    Registered User
    Join Date
    01-26-2015
    Location
    sacramento ca
    MS-Off Ver
    10
    Posts
    7

    Re: insert header/footer causes split

    ok found it, its the page layout box bottom of page on right, there's 3 boxes there, normal, page layout, and page break preview, must have hit the page layout button at some point. just never really noticed those, kinda scary after all the time I have spent with excel.

+ 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] Insert cell contents into header/footer
    By joeeng in forum Excel General
    Replies: 9
    Last Post: 07-06-2016, 07:51 AM
  2. [SOLVED] Insert into Header/Footer List Box
    By HORNUNG in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-21-2006, 07:50 PM
  3. How to insert same header/footer across multiple worksheets?
    By bcottun in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-26-2005, 07:10 PM
  4. [SOLVED] insert the content of a cell into a header/footer
    By subscriptionsink in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM
  5. How to insert a picture in the Footer (not the Header) in Excel 20
    By jmon in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-17-2005, 02:06 AM

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