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.

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.

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.