I think deactivate is the wrong word....
In a worksheet, when one scrolls down, one can normally only scroll to the last "active" cell in the worksheet i.e. a cell with some content in it.
I have a worksheet where the scroll bar is going all the way down to the bottom row of the worksheet, but the actual data in the worksheet only goes up to about row 200. This makes it very difficult to use the scroll bar to navigate around these 200 rows.
Is there a way that I can "deactivate" the cells below my data, so that the scroll bar only goes from row 1 to row 200?
I hope I've explained this clearly?!
In a worksheet, when one scrolls down, one can normally only scroll to the last "active" cell in the worksheet i.e. a cell with some content in it.
I have a worksheet where the scroll bar is going all the way down to the bottom row of the worksheet, but the actual data in the worksheet only goes up to about row 200. This makes it very difficult to use the scroll bar to navigate around these 200 rows.
Is there a way that I can "deactivate" the cells below my data, so that the scroll bar only goes from row 1 to row 200?
I hope I've explained this clearly?!