Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Mar 2008
    Location
    Port Talbot, South Glamorgan, United Kingdom
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    New feature with 2007? (2007)

    Hi,

    The screenshot shows a viewing divider which Excel 2007 seems to have for dividing the Z column from the AA column.

    Is this a new feature with the 2007 version?
    What was the idea behind it?
    Is it possible to switch it off & how?

    Thanks.
    Attached Images Attached Images

  2. #2
    Silver Lounger
    Join Date
    Oct 2002
    Posts
    1,993
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: New feature with 2007? (2007)

    It has been around for several versions (not between Z and AA however <img src=/S/smile.gif border=0 alt=smile width=15 height=15>).

    Drag it to the right of the screen or just double-click it and it should move over there.

    The idea: as you see, you can work with several places of the sheet viewing at the same time.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: New feature with 2007? (2007)

    You can turn this feature on in pre-2007 versions of Excel by selecting Window | Split , and in Excel 2007 by clicking the Split button in the View tab of the ribbon.
    Alternatiely, drag the little "split bar" at the right hand side of the horizontal scrollbar to the left, or the one at the top of the vertical scroll bar down. See screenshot below.
    Yet another method is to double click the split bar(s).

    You can turn it off in pre-2007 versions of Excel by selecting Window | Unsplit, and in Excel 2007 by clicking the Split button in the View tab of the ribbon.
    Alternatively, drag the split bars back to their original position.
    Yet another method is to double click the split bar(s).
    Attached Images Attached Images
    • File Type: png x.png (30.1 KB, 0 views)

Posting Permissions

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