I'm using Excel v10 for Mac for a mailing list. I have 6,000 names on the list but have, by mistake, copied a formula for removing duplicates into a column which now runs to 24,000 plus rows. This is making the worksheet almost impossible to work on, it takes 15 mins to open. I have been trying to cut and paste the address list in small batches to a new worksheet but even in batches of hundreds it is taking forever. Has anyone a better way of getting myself out of this self inflicted pickle? or should I just copy and paste all the addresses in one go and leave for a few hours. the actual file size is 3.4mb.
Thanks
Bridget