ExcelBanter - How do I update a formula automatically without hitting button F9

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How do I update a formula automatically without hitting button F9 (https://www.excelbanter.com/new-users-excel/181541-how-do-i-update-formula-automatically-without-hitting-button-f9.html)

Duma

How do I update a formula automatically without hitting button F9

excel version 2003

If I change a number in a column that I have totaled, how do I update the
total value without haveing to click on the total and then hit the F9 button

Gary''s Student

How do I update a formula automatically without hitting button F9

Tools Options Calculation Automatic
--
Gary''s Student - gsnu200776

"Duma" wrote:

excel version 2003

If I change a number in a column that I have totaled, how do I update the
total value without haveing to click on the total and then hit the F9 button

All times are GMT +1. The time now is 08:12 PM.