Today I learned Excel tips: Delete empty rows: 1. Highlight column A 2. Press F5, Select special 3. Select Blanks 4. Hit Ok and 1st cell of each blank row will be selected 5. Delete -> Delete Sheet Rows (note: column A is used as other cells may have merged contents) Find duplicate cells: 1. highlight column 2. Conditional formatting 3. Highlight Cell Rules -> Duplicate Values... 4. Select a color and Ok download file now