Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,058
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why doesnt my formula cell update automatically ? Wozza Excel Discussion (Misc queries) 7 January 6th 09 01:49 PM
Automatically update formula (sum) when inserting row Cheri D. Excel Discussion (Misc queries) 2 October 19th 06 07:53 PM
How can a formula in a cell automatically update when inserting a. stbookkeeper Excel Worksheet Functions 1 June 23rd 05 08:14 PM
Can I set up the formula to update automatically? pugsly8422 Excel Worksheet Functions 1 March 23rd 05 04:43 PM
how to insert row automatically after hitting enter at the end of. Ali Excel Worksheet Functions 1 November 11th 04 07:24 AM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"