Thread: Is there a way to force Excel 2007 to recalculate just one cell?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Prof Wonmug Prof Wonmug is offline
external usenet poster
  
Posts: 61
Default Is there a way to force Excel 2007 to recalculate just one cell?
On Wed, 6 May 2009 23:10:38 +0200, "Niek Otten"
wrote:

Set Calculation to Manual. Select the cell and press F2, ENTER.

Is there a way to set a keyboard shortcut to toggle this setting
between automatic and manual? It doesn't appear that one already
exists.
Reply With QuoteReply With Quote