From time to time, Excel worksheets fill up with blank cells interspersed among the content. While the judicious use of whitespace can be useful, it may also make reading the worksheet somewhat challenging. Luckily, Excel has a tool to help us get rid of the blank cells. Here’s how:
- Open the worksheet in question
- Press F5 to open the Go To menu
- Click Special
- Select Blanks, and click OK
This will highlight all blank cells, and let you delete them.