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.
3. Click the radio button next to Blanks.
4. Click OK.

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

Yay!