Deleting Blank Rows at Bottom of Worksheet

[Hobolord]

I am running Excel 365 on Windows 10. I recently created a workbook that has a summary page for about 100 sheets. Each sheet has a link to this summary page.

I hid all rows at the bottom of the summary page for aesthetic purposes, and noticed that it increased the size of my file by about 2mb. I went in and un-hid the rows and tried to delete them all, but as soon as I delete them, they just come right back, even after saving, closing, and re-opening the file. I've tried "Clearing All" as well. I've never seen this before. I don't want to give up and make a new summary page because all of my other 100 sheets are linked to this one.

Does anyone know how to get rid of the empty rows at the bottom of the page that are causing my file to be so large?

Thank you in advance.

 

[Fluff]

The OP is saying that the used range still extends down to the last row, even after deleting the blank rows.
That is not the same as having 1,048,576 rows.

 

[Hobolord]

Hi RoryA, I followed your instructions, and it does not seem to make a difference. The file remains at the bloated size.

 

[Hobolord]

Fluff - this file does not have any macros yet

My Answer is This - I see what you're saying, but my file is actually using all of the 1048576 rows, and I can tell because of the scroll bar on the side and the size of the file.

 

[RoryA]

Try setting the row height for all rows to say 15, then save it again.

 

[Hobolord]

RoryA - THAT WORKED! THANK YOU! This was driving me insane.

 

[My Aswer Is This]

So what did that do?

Are you saying now you have less then 1048576 rows ?

RoryA - THAT WORKED! THANK YOU! This was driving me insane.

 

[RoryA]

Glad to help.

 

[My Aswer Is This]

In your original post you said:

I hid all rows at the bottom of the summary page for aesthetic purposes

I believe this is what caused your file size to bloat.

Doing what Roy said by changing row height on all rows unhid all those rows.
​