Forum Discussion
Remove extra rows and columns from Excel
Hello there...
I wanna remove all blank/unused rows and columns, leaving only rows with data.
There is a sheet in my Google Drive that i can easily do this but i do not know how to do it in excel.
Image below to make the understanding of what i need better:
Thanks everyone!
3 Replies
Check these out, might be helpful!
BTW Pernille-Eskebo why is this so difficult? It is obvious this is an issue, its been an issue for years. I have lost so many excel books due to corruption and crashes for exactly this reason. And its hard to tell me its any other reason considering every time I manage to get rid of the excess I have no problems. The question comes up often in google when you search it as well. And not every solution works the same way either, which makes this more painful. Excel seems to like to automatically do all kinds of stuff without me asking, why can this not be fixed? This is a big miss on the devs part.
You cannot really remove unused rows and columns, but you can select them and then hide them.
