Contents Copying

  • Thread starter Thread starter Peter Dennis
  • Start date Start date
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.
 
Hi Peters

go to 'Tools - Options'. In the tab 'EDIT' is an entry to autofill
formulas (checkbox in the upper right corner). I would give you the
correct name for this checkbox but i use a non-english version :-(

Frank
 
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
 
Hi Peter
Just disable this feature / checkbox and the autofill of formulas will
stop :-)

Frank
 
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.

:-(((
 
OK. i'm using Excel 2003, not sure there this option is located in
Excel 2000. Sorry
Frank
 
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.
 
Back
Top