If you wish to impart your Excel Spreadsheet a clean look, delete or remove the extra blank cells, rows, spaces, columns, from Excel sheet.

Protected and unprotected cells look the same in a spreadsheet. To delete all unprotected cells, you must select all of them at once, which can be easily done by using the Find and Replace feature.

1. How to highlight blank cells in Excel Blank cells are easy to miss if you’re working with a lot of data, so you might want to highlight them. The best way to do so is with a conditional format.

Luckily, Microsoft Excel and other popular spreadsheet programs make it easy to delete or hide unused rows and columns.

Susan Harkins shows you how to restrict users to the working spreadsheet by disabling, or appearing to disable, empty cells.

However, the problem starts when you go to count the empty cells of a large spreadsheet. That is when you can use this trick to get the exact number of blank cells in Google Sheets or Excel.