Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Extend data range format and formulas
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 |
#2
|
|||
|
|||
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. Larry F Wrote: 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 -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=278061 |
#3
|
|||
|
|||
Thanks Aladin...that worked!
Larry "Aladin Akyurek" wrote: 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. Larry F Wrote: 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 -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=278061 |
#4
|
|||
|
|||
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 "Larry F" wrote: Thanks Aladin...that worked! Larry "Aladin Akyurek" wrote: 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. Larry F Wrote: 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 -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=278061 |
#5
|
|||
|
|||
denise wrote:
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 "Larry F" wrote: Thanks Aladin...that worked! Larry "Aladin Akyurek" wrote: 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. Larry F Wrote: 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 -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=278061 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) |