+ Reply to Thread
Results 1 to 4 of 4

Worksheet Not Scrolling Down

  1. #1
    Registered User
    Join Date
    09-03-2006
    Posts
    14

    Question Worksheet Not Scrolling Down

    Hi All,

    Random question i have a large Excel Workbook (which is protected) and has over five sheets on it - however one sheet has randomly decided not to scroll... yes i know sounds random! If i use the cursor and down arrows the selection just disappears off the screen.
    The page will scroll if i filter by one field, but not if i select (All) for all filters.
    All other worksheets scroll fine.
    Any suggestions?

    Thanks in advance.
    Cheers Kaite

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Hi Kaitewright,

    On the troublesome worksheet, try clicking Window -> UnfreezePanes to remove any frozen panes. It sounds like someone may have set a frozen pane on a row below the currently visible screen while the data was filtered.

  3. #3
    Registered User
    Join Date
    09-03-2006
    Posts
    14
    Thank you! Solved the problem.
    You can tell i am having a bad day when i couldn't figure that one out

    Thanks again have a great day!

  4. #4
    Registered User
    Join Date
    06-13-2014
    Posts
    8

    Re: Worksheet Not Scrolling Down

    You lifesaver!

+ 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