Remove blank rows from an Excel spreadsheet

OK, since I’m tired of forgetting how to do this and then having to use a search engine to find the information again and again, I’m making a post on my blog for quick reference.

If you can use it, too… AWESOME! 🙂

To find and remove blank rows from an Excel spreadsheet:

  1. Press F5 at the top of your keyboard.
  2. In the dialogue box that pops up, click on Special.excel-go-to
  3. Click the radio button next to Blanks.excel-blank
  4. Click OK.excel-ok

The blank rows will be found, and you can delete them.

Yay!

Leave a Reply