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'