delete unused rows

  • Thread starter Thread starter VT
  • Start date Start date
V

VT

Hi All,

I have a worksheet that only contain data up to about row 100, but for some
reason (I can't remember exactly what I did), all the rows up to 65536 are
now shown in the sheet. I want to delete them all. What do I need to do?

Thanks,

VT
 
Those are blank rows. They will be there, you can't delete them. Bu
they won't print.
NYBo
 
VT, you can not delete them but you can hide them, select the rows and
format row hide
--
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 2000 & 2003
 
Back
Top