Excel 2007 showing empty rows at bottom

  • Thread starter Thread starter Saucer Man
  • Start date Start date
S

Saucer Man

I have an excel sheet which has about 200 rows of data. When I pull the
scroll bar down, it goes down to row 385. These extra rows don't have data
in them. How can I set it so the scroll bar only pulls down to one row
after the last row of data?
 
Simply Select and Delete rows after your data down to row 385. Not
"Clear contents", but r-click, Delete.
 

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

Excel Cannot delete empty cells/rows 4
Excel 2003 vertical scroll bar 4
Restore bottom scroll bar (Excel 2007) 4
Bottom of Page 4
Scroll Bar question 2
locked rows on top and bottom 6
How do I conceal the unused range from the scroll bar? 1
Cannot remove empty rows 8

Back
Top