T Tom Freeman Dec 16, 2009 #1 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?
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 Dave Peterson Dec 16, 2009 #2 Debra Dalgleish shares a few ways here: http://contextures.com/xlfaqApp.html#Unused
D Daryl S Dec 16, 2009 #3 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.
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 Dec 16, 2009 #4 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
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
