The size of a scroll bar indicates the proportional amount of the used area of the sheet that is visible in the window.
My scrollbar indicates I have very many more active columns on my worksheet than I am using. This makes my scroll bar not useful for scrolling through the actual size of my worksheet (about 20 columns)
I have tried selecting all of the columns to the right that are not being used in my worksheet and deleting all of them, but this has not solved the problem.
use ctrl+end to see where your end cell is, then delete any blank cells 2. Reduce conditional formatting (try to avoid it unless necessary) 3. reduce formulas (if you can use values) 4. if using pivot table , dont save a copy of your data with pivot table, as it is already stored in pivot cache