FC Community
Discussion Boards => Off-Topic => Topic started by: mnyjkspm on April 24, 2014, 03:51:08 pm
-
I have been battling a large excel file all day and finally conquered. I wanted to post so none of you have to waste time figuring it out.
->->Never remove empty rows by selecting blank cells, Remove blank rows using the key column, Delete blank rows if your table does not have a key column
->->-> Fastest way to remove all empty rows:Quick Tools Add-in for Excel
Add Duplicate Remover add-in to your Excel and dedupe your worksheets quickly and easily :-)