How to Remove Blank Lines from an Excel Spreadsheet

I’ve downloaded a spreadsheet of email addresses that contains a lot of blank lines. I’d like to get rid of them. How do I do it?

• First, select all your lines (Ctrl+A).
• Then go to “Home”->”Find & Select” right click and choose “Go To Special”.

• You’ll get a popup, choose “Blanks”.
• Hit “OK”.

• You’ll now see your spreadsheet with only the blank lines selected.
• You can delete these by going to “Home”->“Delete”->“Delete Sheet Rows”.
• All your black lines will be deleted. Hurray!

Now I just need to get rid of my duplicate lines in Excel…

Qlockwork is an activity tracking add-in for Microsoft Outlook and an alternative to Microsoft Journal. Companies worldwide use Qlockwork to automatically record their activities on all applications for accurate billing and increased productivity.

Please try our free trial.