Microsoft Excel – Removing blank cells in a spreadsheet

In todays post we will go through removing blank cells within a spreadsheet, to achieve this you will need to carry out the steps listed below:

  1. Start by highlighting the range of cells where you are wanting to remove the blanks.
  2. Within the ‘Home‘ tab click on ‘Find & Select‘ and then click ‘Go to special…‘ within the dropdown menu.
  3. In the new window that appears tick ‘Blanks‘ and then click ‘OK‘.
  4. This will highlight all the blank cells in the range. Whilst highlighted, within the ‘Home‘ tab click on the ‘Delete‘ button.

Leave a Reply