Won't delete my empty rows!

Closed
Sam - May 20, 2010 at 11:35 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 21, 2010 at 05:55 AM
Hello,

After I used the filter on my spreadsheet that only contained 650 rows, suddenely there were 65,000! But they won't delete. I've tried clearing the cells, right clicking and clicking delete then entire row, it just won't work!

Help

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 21, 2010 at 05:55 AM
pre excel 2007, a worksheet contain 65536 rows always. You can hide rows by using hide feature or formatting is such a way that row seem not to be there. So nothing is wrong with what you are seeing
-4