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:
- Start by highlighting the range of cells where you are wanting to remove the blanks.
- Within the ‘Home‘ tab click on ‘Find & Select‘ and then click ‘Go to special…‘ within the dropdown menu.
- In the new window that appears tick ‘Blanks‘ and then click ‘OK‘.
- This will highlight all the blank cells in the range. Whilst highlighted, within the ‘Home‘ tab click on the ‘Delete‘ button.