I have been trying to figure out how to resize the scroll bars on the bottom or side of a worksheet in Excel 2007.

Excel modifies the scroll bars when I paste in a dataset which requires smaller scroll bars, but it does not seem to work the other way. For instance, I might have tens of thousands of rows of data and the scroll bar is sized accordingly (smallest possible size and dragging it a hair moves hundreds of rows at a time). If I delete most of the data, however, and end up with a few hundred rows, I'd like to resize that scroll bar such that it is appropriate for the number of rows. Beyond copying and pasting the reduced data into a new sheet (which will adjust the scroll bar sizes accordingly), does anyone know a way to do this? I think the solution may have something to do with redefining the outer limits (row and column) of the sheet, but I don't know how to go about doing that.

Many thanks for your consideration of this question.

Chris