Thanks for your reply.
But my problem is that i have to copy the formula more than thousand cells.
If i use this method, it means i have to copy+paste the formula more than
thousand (because i have to copy the formula one after other cell )times and
it will consume much time.

Please let me know if any other method to do that so that i can save my times.


"Max" wrote:

Copy the formula cell, then select the destination cell, right-click on it
Paste Special check "Formulas" Ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nad" wrote:
Hi Every One,
How can I copy a formula after(Leaving) one cell?
Because by default when i double click the fill handle it copies the formula
in continuous cell. But i want to copy the formula leaving one cell.

Best Regards,