FC Community

Discussion Boards => Off-Topic => Topic started by: mnyjkspm on April 24, 2014, 03:51:08 pm

Title: Dealing with large excel files - Helpful tip
Post 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 :-)