Skip to content

Excel: Quickly remove blank cells

This article was been published more than a year ago. The information 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

By posting a comment, you consent to our collecting the information you enter. See privacy policy for more information.

This site uses Akismet to reduce spam. Learn how your comment data is processed.