Results 1 to 3 of 3

Cant Scroll or Page Down -Sheet Locked [URGENT]

This is a discussion on Cant Scroll or Page Down -Sheet Locked [URGENT] within the Excel Questions forums, part of the Question Forums category; Ive created a Spreadsheet in Excel 2007. It only contains a few conditional-formats and have utilized filtering. It has been ...

  1. #1
    New Member
    Join Date
    May 2011
    Posts
    39

    Default Cant Scroll or Page Down -Sheet Locked [URGENT]

    Ive created a Spreadsheet in Excel 2007. It only contains a few conditional-formats and have utilized filtering. It has been working fine for many weeks of data entry, but last week, after applying a custom filter, I can no longer scroll up or page-up/page-down, even AFTER ALL FILTERS REMOVED. The cursor will move down thousands of rows (offscreen) but the page will not move with it. When I try to navigate via the vertical slide-bar, it wont go up past C387, or at least thats what it says when I left click on it. But the row displayed at the top is ONE! Ive double and triple checked all filtering, and went to another sheet of raw data within this workbook and it scrolls just fine.

    Please point out all of the places I need to check on this strange phenomenon. Please also let me know if youve heard of any known-bugs in this version. Perhaps I need to apply a patch. I need help ASAP. Thanks.

  2. #2
    Board Regular
    Join Date
    Mar 2011
    Location
    Solihull, UK
    Posts
    310

    Default Re: Cant Scroll or Page Down -Sheet Locked [URGENT]

    Quote Originally Posted by BrooksTech View Post
    Ive created a Spreadsheet in Excel 2007. It only contains a few conditional-formats and have utilized filtering. It has been working fine for many weeks of data entry, but last week, after applying a custom filter, I can no longer scroll up or page-up/page-down, even AFTER ALL FILTERS REMOVED. The cursor will move down thousands of rows (offscreen) but the page will not move with it. When I try to navigate via the vertical slide-bar, it wont go up past C387, or at least thats what it says when I left click on it. But the row displayed at the top is ONE! Ive double and triple checked all filtering, and went to another sheet of raw data within this workbook and it scrolls just fine.

    Please point out all of the places I need to check on this strange phenomenon. Please also let me know if youve heard of any known-bugs in this version. Perhaps I need to apply a patch. I need help ASAP. Thanks.

    have you tried checking to see if Freeze Panes is on?

    Excel 2010 (64-bit)

  3. #3
    New Member
    Join Date
    May 2011
    Posts
    39

    Default Freeze Paines

    Heh, heh. You know its funny as long as Ive been doing spreadsheets (mostly in earlier versions) Ive NEVER used the freeze-paine-function. I dont know how it got stuck in that mode however Im glad it was not a bug. Thanks.

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com