anything in Excel...

It's Excel-o-lozy...

Tip - How to delete blank cells/rows quickly?

Quickly?

Apply Filter Quickly;
filter blank cells Quickly;
select blank cells Quickly; and
delete Rows Quickly.

Not quick enough??

Use this Super Quick Tip:
Ctrl+Space > F5 > Special > Blanks > Ok > Ctrl+- > Alt+r > Ok

Quite Quick??

lemme explain the funda:
Ctrl+Space i.e. Select the whole column;
press F5 > click Special > check Blanks > Ok;
Ctrl+- i.e. to delete cells/rows
Alt+r i.e. to delete entire row > Ok

Buttt...
Multiple cells can't be selected if data is huge say in 00,000s.

Butt...
there is a Quick solution to it too...
not now...
wait for my next tip...

0 comments: