Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Reset the scroll bar in Excel

Posted on 2014-08-22
Medium Priority
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 50

Expert Comment

by:Martin Liss
ID: 40279092
Drag this bar t0 the right.
Drag it
LVL 26

Accepted Solution

pony10us earned 2000 total points
ID: 40279095
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

ID: 40279185
Worked Perfectly!! Thanks Pony!!

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

578 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