Scroll bar keeps deleted rows

G

Gill Keith

I deleted several hundred rows from a spreadsheet but the
vertical scroll bar seems to think they are still there.
All the active cells are in the top 10% of the scroll bar,
the rest of the scroll bar is looking at empty data
cells. Anyone have any thoughts?
 
R

Ron de Bruin

Hi Gill

Excel can think that the usedrange is bigger then it is.

You can see how big your usedrange is on every sheet with CTRL-END
If the row/column is not the last row/column with data then:

1 Select the first row below your last row with data
2 CTRL-SHIFT-DOWN ARROW
3 Right click on the selection and choose delete

And then for the columns

1 Select the first column next to your last column with data
2 CTRL-SHIFT-RIGHT ARROW
3 Right click on the selection and choose delete

Save the file an close it
 
Top