Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Feb 2001
    Location
    Cascais, Portugal
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Zoom + new window

    I'm using O2K
    When i open a new window in Excel, Zoom setting goes to 100%, even though the setting (of all shhets of file concerned) is 80% - this is annoying. Is there a fix?
    Thanks

    Ken

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    Michigan, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Zoom + new window

    the Rube Goldberg method would be to create a one sheet workbook, set the zoom (and any other properties) to your liking, and save the workbook as a template named "Sheet.xlt" in the XLStart folder (usually'C:Program FilesMicrosoft OfficeOfficeXLStart')
    Then whenever you insert a sheet in a workbook, it will have the settings of 'Sheet.xlt'

    HTH

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Zoom + new window

    That doesn't work. I have both Sheet.xlt and Book.xlt set to 80% and both work correctly. However if I press New Window on a sheet set at 80% the new window comes up at 100%. This is XL97 SR2. Incidentally what is New Window used for? Help is most unhelpful on NW.

  4. #4
    2 Star Lounger
    Join Date
    Dec 2000
    Location
    Sault Ste. Marie, Michigan, USA
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Zoom + new window

    New Window opens a new window on the current workbook. The only use I have found for it is to look at two different sheets in the same workbook at the same time by using Window | Arrange and checking the "Windows of Active Workbook" check box.

    Ken

Posting Permissions

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