Results 1 to 7 of 7

why can't i scroll to the right

This is a discussion on why can't i scroll to the right within the Excel Questions forums, part of the Question Forums category; I cant scroll to the right the bar does but the sheet doesn't...

  1. #1
    Board Regular
    Join Date
    Jun 2007
    Posts
    153

    Default why can't i scroll to the right

    I cant scroll to the right the bar does but the sheet doesn't

  2. #2
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    16,997

    Default

    Try pressing your Scroll Lock key
    Office 2007/2010

  3. #3
    Board Regular
    Join Date
    Jun 2007
    Posts
    153

    Default

    nope that doesn't work

  4. #4
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    16,997

    Default

    Do you have any code that sets the scroll area?

    Try running this macro and see if it fixes it:

    Code:
    Sub fixScroll()
    ActiveSheet.ScrollArea = ""
    End Sub
    Office 2007/2010

  5. #5
    Board Regular
    Join Date
    Jun 2007
    Posts
    153

    Default

    Iam sorry that doesn't help. The only macro with code is display is true or false

  6. #6
    Board Regular MarkVMcCullagh's Avatar
    Join Date
    Oct 2002
    Posts
    72

    Default

    Hmm I wonder if you have frozen panes on your worksheet. Is it all workbooks or one specific one?

  7. #7
    Board Regular
    Join Date
    Jun 2007
    Posts
    153

    Default

    yeah the freeze panes are on when the options for formulas is on it expands the cells so that i cant get to panes on the right

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