asked on

Cannot Delete Many Extra Rows

Hi Experts --

I have an Excel Macro that I took over. The file size is much greater than it should be because there are many extra rows and columns. I tried going to the first unused row and then'CTRL-SHIFT-DOWN' to select all unused rows, and then choosing 'Delete Entire Row'. It does not seem to do anything. I tried deleting one row and still there are the same number of rows. Is there many more rows than it is showing? Is there any way to delete them, and the same for the columns (I imagine the same method)?

Thanks for your help.

wander

Saqib Husain

Once you delete the rows then save the file, close it and then open it again.

wander4heat19

ASKER

Thanks for the reply. I tried that and when I re-opened, it was as it was, with the set of rows still highlighted...

Saqib Husain

Can you delete your data and post the file?

wander4heat19

ASKER

Actually, when I tried to delete the columns, I think it worked because the color disappeared but the column letters are still there. I think I can HIDE those to remove them. As far as the rows though, the color still stays on those row numbers which leads me to believe that the deletion is not occurring. I am trying to delete all rows that are below the turquoise and to the right of it, I believe starting at column G for column, and row 30 for row. I want to suppress the row letters and column headers too but I think that is just a HIDE.
test.xlsm

ASKER CERTIFIED SOLUTION

jmac01

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial