Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Entry
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Entry
You can set the calculation to manual (toolsoptionscalculation) and set it
to save when you close the workbook or when you press F9, shift + F9, ctrl + alt + F9, ctrl + shift + alt + F9 You can go to help and type in calculation in the search box, the above all do different things. Also note that when you have calculation set to manual and you put a formula in a cell and drag that formula down to copy to other cells it will stay the same until you calculate the sheet. It certainly speeds up the spreadsheet if you have many calculations -- Regards, Peo Sjoblom "Giles" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control Data Entry - push entry to next cell | Excel Discussion (Misc queries) | |||
Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
format data displayed on Excel data entry form | Setting up and Configuration of Excel |