How do I remove a delay on excel between cells

[Margaret]

when I paste in a cell in excel and then move to the next cell there is a 2
second delay. How do I get rid of the delay

 

[Dave]

Hi Margaret,
My guess is that the sheet contains a lot of formulas, and the 2 seconds is
the time XL takes to re-calculate them all.
Lokk down at the bottom left corner of XL next time you paste, and see if it
says:
Calculating...
Regards - Dave.

 

[Bill Sharpe]

Hi Margaret,
My guess is that the sheet contains a lot of formulas, and the 2 seconds is
the time XL takes to re-calculate them all.
Lokk down at the bottom left corner of XL next time you paste, and see if it
says:
Calculating...
Regards - Dave.

You can turn off automatic calculating, but be sure to turn it back on
or calculate manually before you print or quit the program.

Bill