Remove extra rows and columns from Excel

Occasional Visitor

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!


1 Reply


You cannot really remove unused rows and columns, but you can select them and then hide them.