How To Microsoft Excel Tips & Tricks

Excel: Quickly remove blank cells

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.

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.