How do I correct scroll bar range?

[Tom Freeman]

I have a worksheet where the scroll bar range is A through WVL where all I
need is A through W. Is there a way to correct this?

 

[Dave Peterson]

Debra Dalgleish shares a few ways here:
http://contextures.com/xlfaqApp.html#Unused

 

[Daryl S]

Tom -

If there is nothing in the spreadsheet to the right of column W, then
highlight columns V through WVL and then Edit | Delete. Then Save the
worksheet. When you open it, the scroll bar should be fixed.

 

[Gord Dibben]

Reset the used range.

Go to Column X

Shift + End + Right Arrow.

Edit>Delete>Entire Columns.

Save the workbook.

If you don't want to see any columns past W, simply hide those columns.


Gord Dibben MS Excel MVP