Contents Copying

P

Peter Dennis

I have a speadsheet with a Two lists of figures, One for
debits and another for credits. I have several columns to
the right of these figures that represent departments. I
have formulai in the department columns that add the Two
figures mentioned together. The formula is only entered
for some of the cells in eack department depending on a
code in column A. When I enter a figure in my credits
column and I have a few entries already for that
department, and want to go on to the next department, the
figure is being calculated into both the next department
column and also the next row in the previous department
even though there is no formula in this field. I am
copying the formulas into the cells manually and not using
Macros or lookups and am at a loss as to why this is
hapening. Any help would be appreciated. Thanks in advance.
 
G

Guest

Thanks Frank for replying but this solution is for adding
auto-fill and I want to stop it happening. If you have
any other solutions I would appreciate it.

Peter
 
F

Frank Kabel

Hi Peter
Just disable this feature / checkbox and the autofill of formulas will
stop :)

Frank
 
P

Peter Dennis

Hi Frank

I must be using a different version of Excel than you
because I do not have a checkbox for disabling this
function. I am using Excel from Office 2000. It may be
that this checkbox is located elsewhere but I cant find it.

:-(((
 
F

Frank Kabel

OK. i'm using Excel 2003, not sure there this option is located in
Excel 2000. Sorry
Frank
 
P

Peter Dennis

I have found the flag you mean. It was in the Tools menu
in my version. All is fine and hunkydorey. Thanks for
your help.
 
Top