In this Excel 2016 Tutorial video, you will learn to find and remove only the empty cells, columns and rows within from your worksheet. This short command can help you sometimes, when your only concern is finding and removing empty cells from the given data range.
We are using Go To Special - Blanks command for this scenario and later we will use Delete Sheet Rows and Delete Sheet Columns commands to remove the selected empty cells.
Information also applies to the following versions of Microsoft Excel : Excel 2003 Excel 2007 Excel 2010 Excel 2013
Subscribe Us http://www.youtube.com/theteacher
Circle Us on Google Plus http://www.google.com/+theteacher
Visit Us http://www.theteacherpoint.blogspot.com
Follow Us on Facebook http://www.facebook.com/bemyteacher
Presented By: Rajiv Kohli as The Teacher