How to Delete Blank Cells in a Microsoft Excel 2013 or 2016

Printer Friendly
Text Size: A A A A

http://www.groovypost.com

If you work with a large data set in an Excel workbook, there are times you might need to delete a blank cell or set of blank cells. The process can become time consuming; if you have a lot of data. Instead of going through the workbook, and deleting each blank cell individually, you can make multiple selections and let Excel do the work for you. Using this method is a real time saver, compared to performing the same action manually.

Delete Blank Cells within an Excel Workbook

 

The screenshot below displays a workbook with data in multiple columns. Between each column, there are blank cells; those are the cells I want to delete. To do so, highlight just the range of data containing the blank cells.

Under the Home tab > Editing group click Find & Select and then click Go To Special.

Choose the Blanks radio box and click OK.

You’ll see that Excel made a non-adjacent selection of all the blank cells in the spreadsheet. This makes it easy to delete the cells you don’t want.

From the Home tab, under the Cells group, click Delete and then choose whether you want  to delete the blank cells in rows or columns. In my case, I just want the empty columns removed.

That’s it! Now your workbook looks better.

Using Excel 2016 for Mac

 

If you are using the Mac version of Excel, you can find this function under Edit > Find > Go to.

Now, in the Go To screen, click the Special button.

Then select the Blanks radio box and click OK.

That’s all there is to it! This makes it much easier to create cleaner spreadsheets and workbooks for your boss. 


For more information and to view an archive of previous Tech Tips, please visit us here.

Do you have specific topics you would like to see covered in Tech Tips? Email any suggestions to communications@ficpa.org.