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.

Between each column, there are blank cells; those are the cells I want to delete.

Youll see that Excel made a non-adjacent selection of all the blank cells in the spreadsheet.

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.

Excel 2016 Flash Fill Mac If You

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

Thats all there is to it This makes it much easier to create cleaner spreadsheets and workbooks for your boss.

Excel 2016 Flash Fill How To Remove Empty

Also, youre running an older version of Excel, be sure to read our previous article on how to remove empty cells in Excel 2010 or 2007.

Thats what comes up, and when you click OK nothing happens as a result.

Please advise. Reply Leave a Reply Cancel reply Your email address will not be published.

For more details, please read our Privacy Policy and Terms of Service.