Skip to content

Excel: Quickly remove blank cells

This article was been published more than 6months ago. The information contained herein may be outdated.

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.

Be First to Comment

Leave a Reply