Results 1 to 5 of 5
  1. #1
    Mark P. Zaitsoff
    Guest

    Worksheet size and resizing

    Excel 2000, 9.0.3821 SR-1. I have a workbook with 8 worksheets. The worksheets do not fill the entire screen area. I can't stretch the size of the worksheets. The Minimize/Restore/Close boxes are missing for the workbook (not for Excel in general). The horizontal and vertical scrollbars work for all but the last worksheet, there the vertical scrollbar works but not the horizontal. Similarly I can maneuver through cells except horizontally on the last sheet, though the cell name box shows the cursor is moving through cells that are not visible. Other workbooks are alright. File is attached.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Worksheet size and resizing

    Hi Mark,
    Can you try and attach the file again please - it doesn't seem to have worked the first time. Thanks.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Mark P. Zaitsoff
    Guest

    Re: Worksheet size and resizing

    Sorry sometimes the technology overwhelms. Didn't check before, the workbook is 227K, so that's probably the problem. System will not allow me to attach it now.

  4. #4
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Worksheet size and resizing

    Mark,

    Can you try either:

    .Compressing it using pkzip and attaching the result

    or

    .Cutting down the size of the worksheet, but where it still exhibits the problem

    Thanks
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  5. #5
    Mark P. Zaitsoff
    Guest

    Re: Worksheet size and resizing

    Problem rectified itself when I unprotected workbook to edit it down for size. Worksheets jumped to full screen and useability. Still don't understand what was going on. Thanks for the help, sorry for the bother.

Posting Permissions

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