Reset the scroll bar in Excel

Posted on 2014-08-22
Last Modified: 2014-08-22
I know this is a simple/stupid question but it is driving me crazy.  How do I reset the scroll bars on an excel spreadsheet so that it doesn't cover so many columns/rows.

All of my information on the sheet is in columns A-Q but my scroll bar takes me all the way to AFM.  So that my data only takes up like 2% of the scroll bars potential Space.

I don't need a macro just a one time GUI.

Excel 2010
Question by:garyrobbins
    LVL 44

    Expert Comment

    by:Martin Liss
    Drag this bar t0 the right.
    Drag it
    LVL 25

    Accepted Solution

    Excel 2010 automatically adjusts the scrollbars however sometimes you need to do the following:

    1. Go to the last column that contains data
               Ctrl+Shift+Right Arrow
    2. Select all columns to the right
    3. Select Edit/Clear/All from the top menu
    4. Save the workbook
    5. Exit Excel
    6. Re-open Excel

    This should reset the vertical scroll bar.  If you need to do the same for the horizontal scroll bar change step 1 to Ctrl+Shift+Down arrow and step 3 to select all the rows below.

    Author Closing Comment

    Worked Perfectly!! Thanks Pony!!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now