Delete blank rows and columns

[khurramfarooqpk]

HELLO to all

I have large data base and want to delete blank rows and columns without using macro.

thanks in advance

[zbor]

Select (for example) Column A
Click F5
Click Spetial...
Select Blanks
OK

Now carefully right click on some blank selected cell
Right click delete
Entire row