Delete blank row (fast)?

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

Duplicate of

1 Like