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?

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

Tom Freeman wrote:

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

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.
--
Daryl S


"Tom Freeman" wrote:

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?

Reset the used range.

Go to Column X

Shift + End + Right Arrow.

EditDeleteEntire Columns.

Save the workbook.

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


Gord Dibben MS Excel MVP

On Wed, 16 Dec 2009 07:51:01 -0800, Tom Freeman
wrote:

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?