hey guys, so sometimes on my multi year old worksheets that are regularly updated i end up over time adding an insane amount of blank rows at the bottom - not sure how this happens but it does
on some sheets i'm able to highlight and delete them, on others that doesn't seem to work and I'm unable to find solutions to this via google
imagine you have a worksheet where you only use the top 200 or so rows but there's 100k blank ones underneath
I'd ideally prefer to be able to remove the blank ones cause they slow it down like crazy rather than copy the good part to a new sheet because there are so many connections to other sheets it'd be a nightmare to go through and change them all
appreciate any input - if i highlight the columns they won't delete as they normally do in other occasions
https://support.microsoft.com/en-us/...rs=en-us&ad=us
edit: nvm, after realizing i wrote columns here instead of rows and edited it for clarity, resumed google search but used rows instead
Last edited by rickroll; 08-27-2020 at 05:00 AM.