PS Exam

  • Full Screen
  • Wide Screen
  • Narrow Screen
  • Increase font size
  • Default font size
  • Decrease font size

Microsoft Excel Problems and Solutions - Why do my scrollbars go to row 500 -- my data ends in cell E50?

E-mail Print PDF
Article Index
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
All Pages

 

 

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:

    1. Select the last cell that contains data in the worksheet
    2. To delete any unused rows:
      • Move down one row from the last cell with data.
      • Hold the Ctrl and Shift keys, and press the Down Arrow key
      • Right-click in the selected cells, and, from the shortcut menu, choose Delete
      • Select Entire Row, click OK.
    3. To delete any unused columns:
      • Move right one column from the last cell with data.
      • Hold the Ctrl and Shift keys, and press the Right Arrow key
      • Right-click in the selected cells, and, from the shortcut menu, choose Delete
      • Select Entire Column, click OK.
    4. Save the file. Note: In older versions of Excel, you may have to Save, then close and re-open the file before the used range is reset
 

 

 

 

 



 

Subscribe

Wish to get contents in your Email?

Enter your email address:

Who's Online

We have 180 guests online

Sharing Enriches!

You are here: Class Notes and Others Notes on Computer Science Microsoft Excel Problems and Solutions - Why do my scrollbars go to row 500 -- my data ends in cell E50?