Prevent scrolling to bottom row excel 2010

[shirty89]

Hi there,

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.

Any Ideas?

Thanks
Sam

 

[laga]

I solved this problem with hiding the rows. Deleting didn't work for me, even when I deleted the whole sheet rows, nothing changed.
I scrolled at the end of sheet then press shift + Home. All cells selected, then by keeping shift, pressed arrow down key and deselected the cells I need. then hide the other cells.

but if anybody have better idea, PLZ share it.
Thanks