Thread: Data Entry
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Data Entry

go to Tools - Options - Calculation. Change to Manual.

You can then enter everything you need.

You can tap F9 to refresh all formulas.

You can go back and change back to Automatic once you've done all of your
work.

"Giles" wrote:

When I exit a cell after entering data, the worksheet "save"hourglass
displays for 30 seconds or so. Can I delay that step until all data has been
entered?