Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you recalculate an individual excel cell in isolation?
I know you can manually recalculate a workbook by pressing f9, or an
individual sheet by pressing shift f9, but can you recalculate specific cells and leave other cells on the same sheet unchanged, where they do not refer to one another? (This is in Excel 2003) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you recalculate an individual excel cell in isolation?
Tools|Options|Calculation, and check "Manual" Then you can re-enter the
individual formulas that you want recalculated (select the cell, put the cursor into the formula bar and press Enter [or Ctrl-Shift-Enter if it is an array formula]). Jerry Dobey Kweeg wrote: I know you can manually recalculate a workbook by pressing f9, or an individual sheet by pressing shift f9, but can you recalculate specific cells and leave other cells on the same sheet unchanged, where they do not refer to one another? (This is in Excel 2003) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you recalculate an individual excel cell in isolation?
Yes. Select Manual mode. Update data cells and the formula results will not
change. TO update only a specific cell: 1. select it 2. click in the formula bar 3. touch enter Only that selected cell will be updated. -- Gary's Student "Dobey Kweeg" wrote: I know you can manually recalculate a workbook by pressing f9, or an individual sheet by pressing shift f9, but can you recalculate specific cells and leave other cells on the same sheet unchanged, where they do not refer to one another? (This is in Excel 2003) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell on one page equals cell on another page in excel? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |