How do I correct scroll bar range?

T

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?
 
D

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.
 
G

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
 
Top