View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
 
Posts: 2,819
Default Excel 2007 showing empty rows at bottom

Simply Select and Delete rows after your data down to row 385. Not
"Clear contents", but r-click, Delete.

Saucer Man wrote:

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?