Auto Calculating Formula

This will be an easy question for someone who knows it i'm sure........I have created a very simple excel spreadsheet to deal with my bank accounts running balances with debits and credits. At present I cut/paste the formula into each of the balance totals fields, is there anyway to make excel auto calculate each line to save me the cut/pasting. The simple formula looks a bit like this:- =SUM(D339,F338,-E339). This deals with debits and credits from the account and gives me the total.

Many thanks

Neil

Hi,

This from excel help::

Copy formulas when an external data range expands
Enter a formula in a cell adjacent to the first row of data in the external data range.
Note The first row of data might be the first or second row in the external data range, depending on whether the first row contains headers.

Select the cell and double-click the fill handle to copy the formula to all rows in the external data range.
Click a cell in the external data range, and then click Data Range Properties on the External Data toolbar.
In the External Data Range Properties dialog box, select the Fill down formulas in columns adjacent to data check box.
Note If the external data range expands when you refresh, Microsoft Excel copies only those formulas that are immediately adjacent to or within the external data range.


HTH

dave