Page History

...

1. Remove any images or graphs.
2. Remove formatting and highlighting, as they won't be usable in the upload and they can take up space in your file. 
3. Check for formatting on unused cells. Remove unneeded columns. If you have extra columns on your file that you don't need imported in to Targeter, removing those columns can greatly reduce the size of the file.
4. Remove unneeded rows. By deleting all unused rows to the bottom of the document on each worksheet, you can greatly reduce the file size.
5. To see if there is hidden formatting in unused cells, use CTRL + END on each worksheet to reach the farthest and lowest cell with formatting. 
   1. Excel saves only the part of each worksheet that is in use, meaning the section that contains data or formatting. Sometimes the last cell of a worksheet may be beyond the range of your actual used data. Clearing the excess rows and columns to reset the last cell can help to resolve these issues.
   2. To find what Excel considers to be the last cell of the active worksheet use the keyboard shortcut CTRL+END. Sometimes, the end cell may be many rows and columns from the genuine final cell.
   3. This may be resolved by firstly, ensuring there is nothing to be retained in the additional columns / rows, secondly deleting these additional cells and thirdly, re-saving the file, preferably with a new filename.

...