eliminating extra rows in spreadsheet

R

roger-e

If I have a spreadsheet with several rows, the scroll bar goes down to the
last row. If I delete rows, the scroll bar still goes down to where the last
row used to be. This is cumbersome if I've got a large worksheet and I've
eliminated a lot of rows. Is there a way to readjust the scroll bar so that
it will stop at the new last row? Thanks.
 
B

Bob Umlas

After you delete the rows, you can save the file & reopen - should be OK.
OR, press Alt/F11 (takes you to the VBE), ctrl/G (displays immediate
window), type
Activesheet.usedrange
and press enter.
Then Alt/Q (returns to Excel)
and you should be OK.
Bob Umlas
Excel MVP
 
R

roger-e

Thanks Bob!
--
roger


Bob Umlas said:
After you delete the rows, you can save the file & reopen - should be OK.
OR, press Alt/F11 (takes you to the VBE), ctrl/G (displays immediate
window), type
Activesheet.usedrange
and press enter.
Then Alt/Q (returns to Excel)
and you should be OK.
Bob Umlas
Excel MVP
Click to expand...
 
Top