<div>
Drag this bar t0 the right.<br />
<a href="https://filedb.experts-exchange.com/incoming/2014/08_w34/868074/drag.jpg" target="_blank" title="Drag it (21 KB)"><img alt="Drag it" class="file-block lazyload" style="max-width: 348px;" data-src="https://filedb.experts-exchange.com/incoming/2014/08_w34/868074/drag.jpg" /></a>
</div>


Drag this bar t0 the right.
Drag ithttps://filedb.experts-exchange.com/incoming/2014/08_w34/868074/drag.jpg

drag.jpg

<div>
Worked Perfectly!! Thanks Pony!!
</div>


<div>
<div class="content wysiwyg-content">
I know this is a simple/stupid question but it is driving me crazy. &nbsp;How do I reset the scroll bars on an excel spreadsheet so that it doesn't cover so many columns/rows.<br />
<br />
All of my information on the sheet is in columns A-Q but my scroll bar takes me all the way to AFM. &nbsp;So that my data only takes up like 2% of the scroll bars potential Space.<br />
<br />
I don't need a macro just a one time GUI.<br />
<br />
Excel 2010
</div>
</div>


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

Reset the scroll bar in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.