View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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)