Extend data range format and formulas

L

Larry F

Even after checking this box under Tool-Options-Edit the formulas will not
automatically copy down my formulas when adding news rows. The formulas are
in the precedding 25 rows. Any ideas why this is not working?

Thanks
Larry
 
A

Aladin Akyurek

That option has nothing to do with formula copying. If you are not o
Excel 2003, you have to copy down/across the formulas either manuall
or by means of code in VBA.

If you are on Excel 2003, change the area with data and formulas into
list by invoking Data|List|Create List. Excel will copy down th
formulas automatically when appropriate.
 
L

Larry F

Thanks Aladin...that worked!

Larry

Aladin Akyurek said:
That option has nothing to do with formula copying. If you are not on
Excel 2003, you have to copy down/across the formulas either manually
or by means of code in VBA.

If you are on Excel 2003, change the area with data and formulas into a
list by invoking Data|List|Create List. Excel will copy down the
formulas automatically when appropriate.
Click to expand...
 
D

denise

I have a question maybe you can help aladin. I am trying to copy a formula
down a column and the formula copies fine but when I hit the enter key the
cells don't show the totals, they show a dash sign or minus sign. Are you
familiar with this problem? Thank you, denise
 
W

windsurferLA

denise said:
I have a question maybe you can help aladin. I am trying to copy a formula
down a column and the formula copies fine but when I hit the enter key the
cells don't show the totals, they show a dash sign or minus sign. Are you
familiar with this problem? Thank you, denise

:
Click to expand...
Are you certain that the result of each formula is something other than
zero? The cell may be formatted to display a "-" when the value is zero.
 
Top