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.