Excel 2010 :: Prevent Scrolling To Bottom Row

I'm currently creating a workbook whereby I have (regrettably) highlighted entire columns and formatted these columns to show borders. The reason I did this was because drawing them in manually (I thought) would take much longer with the way the worksheet is laid out.

Obviously highlighting the entire column has meant that borders were drawn all the way down to the bottom row of the workbook, and so the vertical scroll bar cannot effectively be 'dragged' up and down as even a tiny movement will cause it to scroll right past the worksheet.

I have tried running a macro to clear contents and formatting for all the unused rows, but the scroll bar remains to be a pain.

I want the scroll bar to only scroll down to a few cells below the available work space like it should do.