Deleting blank rows in excel after spreadsheet

[mvictory1]

I've been using excel for years and thought I had seen a lot. I've tried every trick I know and all that Google shows too. I can't delete the rows after my 541 rows in my spreadsheet. The file size says it's only about 541 rows and 22 columns, since it has 175K total size but when you open the file it shows 125000 lines (the vertical drag bar shows it to be an extremely big spreadsheet). Any guru ever see this occur before and know how I can remedy this situation? Thanks


Due to confidential info I can't share the spreadsheet. Sorry.

 

[mvictory1]

What do comments have to do with providing a sample file? I thought the problem was about a file always thinking there were more rows than you think there should be?


What I was suggesting about deleting the majority of data etc was simply to resolve your problem of thinking that you could not share a sample file because of confidential data.

I'm sorry but I can't do as you're requesting. Obviously there is something that is causing this issue and I can't afford the risk of having data (even if it's hidden or partially deleted) on a public forum. Thank you and I'm sure you understand. I believe it definitely has something to do with how many comments are imbedded into the spreadsheet.