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 


Rigid Box said...

Information from this blog is very useful for me, am very happy to read this blog Kindly visit us @ Coimbatore Christmas Gift boxes | Wallet Box

ahmed said...

مكافحة الفئران مع الطائف.

رش العثة في الطائف

قتال الصراصير في الطائف.

مضادات النمل الأبيض في الطائف.

مكافحة الحمل مع الطائف.شركة رش مبيدات بالمدينة المنورة
كيفية صنع مبيد للنمل بالمنزل
شركة الانوار لرش المبيدات