Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Fill properties
I have a typical table of numbers, rows and columns. Then i total on column and then use fill right to copy the function to th eother columns, the cell contents shows the formula changing cell references, but the total numer itself remains that of the first cell. I have done this with correct results hundreds of times before. IS there a fill property that I may have inadvertantly changed? Vfalzone -- vfalzone ------------------------------------------------------------------------ vfalzone's Profile: http://www.excelforum.com/member.php...o&userid=16395 View this thread: http://www.excelforum.com/showthread...hreadid=277668 |
#2
|
|||
|
|||
Hi
check tools / options /calculation and set to automatic cheers julied "vfalzone" wrote in message ... I have a typical table of numbers, rows and columns. Then i total on column and then use fill right to copy the function to th eother columns, the cell contents shows the formula changing cell references, but the total numer itself remains that of the first cell. I have done this with correct results hundreds of times before. IS there a fill property that I may have inadvertantly changed? Vfalzone -- vfalzone ------------------------------------------------------------------------ vfalzone's Profile: http://www.excelforum.com/member.php...o&userid=16395 View this thread: http://www.excelforum.com/showthread...hreadid=277668 |
#3
|
|||
|
|||
Hi
mae sure automatic re-calculation is enabled ('Tools - Options - calculation' "vfalzone" wrote: I have a typical table of numbers, rows and columns. Then i total on column and then use fill right to copy the function to th eother columns, the cell contents shows the formula changing cell references, but the total numer itself remains that of the first cell. I have done this with correct results hundreds of times before. IS there a fill property that I may have inadvertantly changed? Vfalzone -- vfalzone ------------------------------------------------------------------------ vfalzone's Profile: http://www.excelforum.com/member.php...o&userid=16395 View this thread: http://www.excelforum.com/showthread...hreadid=277668 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions |