Scroll bar keeps deleted rows

  • Thread starter Thread starter Gill Keith
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scroll Bar Missing 1
SCROLL BAR ISSUE 4
Excel 2003 vertical scroll bar 4
Vertical scroll bar length 1
Scroll Bar question 2
Excel Cannot delete empty cells/rows 4
how do I change the size of vertical scroll bar 6
HOW DO I REVERT SCROLL BOX TO CURRENT VISIBLE WINDOW? 1

Back
Top