Dean, have a look here : http://www.contextures.com/xlfaqApp.html#Unused
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Dean" wrote in message
...
my spreadsheet data goes down to row 297 yet if i scroll alll the way
down
to the bottom it goes to row 690. How do i get rid of all empty rows ?
--

thanks
Dean