cfo.com

Print this article | Return to Article | Return to CFO.com

Spreadsheets: Honey I Shrunk the Scrollbar Slider

The slider on the vertical scrollbar that allows Excel users to navigate among several screens has been accidentally shrunk to a point that it is unusable. What now?
Bill Jelen, CFO.com | US
October 5, 2011

Editor's Note: If you would like Bill Jelen to answer your Excel question in an upcoming column, post a question on the Community Center at the right, or send an e-mail note to If Bill selects your question to use in an upcoming column, you'll win one of his Excel books as a thank you.

One reader writes: "I have a worksheet with two or three screens of data. I can easily grab the vertical scrollbar and move to the top or bottom of the data set. Something happened, and now the huge scrollbar slider has become really tiny. Further, if I move it just one pixel, instead of jumping to the next screen of data, Excel will move to row 4500.

Fig. 1

This can happen if someone pressed End Down Arrow key to move to row 1048576.

Fig. 2

You can often restore the size of the slider by moving it completely to the top of the spreadsheet. If this does not work, then there is one rogue cell way below your data that has become activated. Perhaps someone pressed the Spacebar or applied text formatting or something. Follow these steps:

• Note the last row that you believe to contain data.
• Press the End key and then press the Home key. Excel will jump to the intersection of the last active row and the last active column. This row is usually way beyond the row that you believe to be the last row.
• Delete all rows from the bottom of your data set to the rogue last row.
• Save the workbook. The scrollbar slider will return to full size.

Saving the workbook is the key. Even after you delete the extra rows, Excel will not restore the size of the workbook. In past editions of Excel, copying the worksheet was enough, but in Excel 2007, the scrollbar will not resize until you save the workbook.

CFO contributor and founder of MrExcel.com Bill Jelen is the author of 33 books about Microsoft Excel. His latest book, Learn Excel 2007-2010 from MrExcel contains solutions to 512 mysteries like this one. Bill's next webcast on CFO.com is Using Excel for Advanced Data Analysis, airing on Tuesday, October 11.




CFO Publishing Corporation 2009. All rights reserved.