Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    351
    Thanks
    3
    Thanked 0 Times in 0 Posts
    For some unknown reason other than my rediculous blunder, I lost my horizantal scroll bar. I tried to get it back but the best I could do was open up a freeze pane window to get a horizontal scroll bar on the newly opened pane.

    Anyone out there know how to fix this?


  2. #2
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by MNN View Post
    For some unknown reason other than my rediculous blunder, I lost my horizantal scroll bar. I tried to get it back but the best I could do was open up a freeze pane window to get a horizontal scroll bar on the newly opened pane.

    Anyone out there know how to fix this?
    Have you checked Tools | Options | View and seen whether the Horizontal Scroll Bar is ticked?

    For 2007, Excel Button | Excel Options | Advanced

  3. #3
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    351
    Thanks
    3
    Thanked 0 Times in 0 Posts
    yes. The horizontal scroll is turned on.

  4. #4
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by MNN View Post
    yes. The horizontal scroll is turned on.
    Hmmm,
    Has the left hand side of the scrollbar been moved right over to the right? - do you see a sort of double block at the right hand end? (pre 2007)

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts
    Is the Excel window fully maximized?
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    3 Star Lounger
    Join Date
    Jun 2005
    Posts
    351
    Thanks
    3
    Thanked 0 Times in 0 Posts
    Yes GFamily the scroll is moved to the right and if i double click it is creates a split screen and i could move the scroll within the split screen. if i close it reverts back to a non usable horizontal scroll. I do have the worksheet maximized.

  7. #7
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by MNN View Post
    Yes GFamily the scroll is moved to the right and if i double click it is creates a split screen and i could move the scroll within the split screen. if i close it reverts back to a non usable horizontal scroll. I do have the worksheet maximized.
    If you are seeing this, [attachment=88260:corner.jpg], you need to make sure you're dragging the leftmost of the two blocks otherwise you will 'split' the screen as you've found.

    On re-reading your reply I see you double-clicked; I suggest a click and drag (on the leftmost of the 2 blocks) rather than double-click.

    If you don't see a double block I suggest you reinstall Excel.
    Attached Images Attached Images

Posting Permissions

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