How do I remove a delay on excel between cells

  • Thread starter Thread starter Margaret
  • Start date Start date
M

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
 
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.
 
Dave said:
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.
Click to expand...
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
 
Back
Top