Delete rows takes forever
Hi,
Am Tue, 19 Nov 2013 11:06:15 -0800 (PST) schrieb GWC:
a1.a188000 contain values.
I type =if(a2=a1,"dupl","") in b2
I copy that formula and paste it in B2.B188000
I select col b
I do FIND ALL dupl
It finds 12000 cells.
I press the Shift key and click on the first and last cells in the box
I do DELETE rows
Why does it take HOURS to delete the 12,000 rows?
before deleting set calculation to manuell
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|