why can't i scroll to the right

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: why can't i scroll to the right

  1. #1
    Board Regular
    Join Date
    Jun 2007
    Posts
    153
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    19,225
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try pressing your Scroll Lock key
    Office 2010/365

  3. #3
    Board Regular
    Join Date
    Jun 2007
    Posts
    153
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    nope that doesn't work

  4. #4
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,225
    Post Thanks / Like
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)

    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 2010/365

  5. #5
    Board Regular
    Join Date
    Jun 2007
    Posts
    153
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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

User Tag List

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