|Microsoft Excel Problems and Solutions|
|Why do my scrollbars go to row 500 -- my data ends in cell E50|
|Password and Protection|
|Entering and Saving Data|
Why do my scrollbars go to row 500 -- my data ends in cell E50?
Excel may be remembering some data that was in row 500, but has been deleted. To go to the cell which is currently the "Last Cell" in the worksheet, hold the Ctrl key, and press the End key. If the Last Cell (cell J500 in this example) is outside the range of cells that is actually being used, you can reset the used range, so the scroll bar works correctly.
Note: If any cells contain references to the deleted cells, those references will be replaced with a #REF! error. If you have cells that are formatted, but outside the range that contains data, the formatting will be lost.
To manually reset the used range:
|< Prev||Next >|