I want to Delete blank row (fast)
Example : I have data 2 Rows but I press CTRL+shift+end ----> It show 100,000 rows (It make big size file excel)
I want to delete blank row.
Please guide me about it.
It would be great if it you suggest solution by macro