Sunday, 13 March 2016

How to Delete Multiple Blank Cells at a time in MS Excel (Excel 2003-2016)

Sometime we leave lot of empty rows and columns while working in excel, if we try to delete one by one it took lot of time and energy, in this post I will show you how to delete all multiple empty cells in excel in one time, this method will work all the version of Microsoft Excel 2003, 2007, 2010, 2013 and 2016.

1.       Select the column or row click on “Find & Select” click on “Go to special” check on “Blanks” and “ok” this will select all blank cell.

2.       Right click on cell, select “Delete” select “Entire Row” or “Entire Column” and “Ok”


Please like, share & subscribe 

No comments:

Popular Posts