If you find any post useful then, please do share with others. Thanks!

Popular Posts

Contact

Email me

Need help and that also free? I like to learn this way, in case of any question or for a small task, please feel free to email me with details and example data, if required.

Friday, April 18, 2014

Deleting Blank rows, a simple technique

Deleting Blank rows, a simple technique

Suppose our data is like below, and we want to delete the blank rows, then no need to do this one by one, use the below technique.





Select the data where in between there are blank rows.

Press F5 button, the below window will appear, now click on Special





Now select the box of Blanks and press ok.





Now blanks are selected so to delete them press Ctrl – and shift the cells up, now data like below.