+ Reply to Thread
Results 1 to 8 of 8

Page stuck

  1. #1
    Registered User
    Join Date
    01-14-2009
    Location
    Scarborough, UK
    MS-Off Ver
    Excel 1997
    Posts
    5

    Page stuck

    I've hesitated to post this, because I know I'm going to feel very foolish when I see the answer.

    Yesterday, I opened a much used document and found that I simply couldn't scroll it horizontally to view the whole of Column A and half of Column B.

    http://www.peaksoft.co.uk/oddimages/excel_image.jpg

    I've resized the screen and the document every-which-way and I'm stumped.

    Could someone please help me out?

  2. #2
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Try this..


    Click on Window Menu --> Unfreeze...

    It may help

  3. #3
    Registered User
    Join Date
    01-14-2009
    Location
    Scarborough, UK
    MS-Off Ver
    Excel 1997
    Posts
    5
    Many thanks for your suggestion.

    It wasn't already Freeze-d, so I chose Freeze then Unfreeze, but it's still stuck.

  4. #4
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Can you post the worksheet if it is not confidential .. or by removing the data with dummy data

  5. #5
    Registered User
    Join Date
    01-14-2009
    Location
    Scarborough, UK
    MS-Off Ver
    Excel 1997
    Posts
    5
    I've attached it (I hope)
    Attached Files Attached Files

  6. #6
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717
    Quote Originally Posted by peaksoft View Post
    I've attached it (I hope)

    I'm able to view the attached spreadsheet completely and able to scroll both hori and verti ..
    It has to do something with the excel setting.

    May be you can try...and play aroound

    Tool --> option --> View ...

  7. #7
    Registered User
    Join Date
    01-14-2009
    Location
    Scarborough, UK
    MS-Off Ver
    Excel 1997
    Posts
    5
    Thanks for that suggestion.

    I must have spent an hour trying various options there last night.

    I'm still stuck.

    If anyone can replicate the problem and make further suggestions, I'd be very grateful.

  8. #8
    Registered User
    Join Date
    01-14-2009
    Location
    Scarborough, UK
    MS-Off Ver
    Excel 1997
    Posts
    5
    I've downloaded it from the forum to another computer - and it's fine on that one.

    Mystery, huh?

    Thanks for your interest.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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