SOS - My formulas aren't computing down my rows but copying same
 

When I copy a formula down my spreadsheet, it returns the same results as the
top row even though it isn't justified anywhere. The only way I can get it
to work is F2 enter on each line!! Please Help! I have lengthy files and
this happens on and off for no reason that I know of.

Thanks!

Check Tools - Options - Calculation tab, make sure calculation is
"Automatic"


Sharon S Wrote:
When I copy a formula down my spreadsheet, it returns the same results
as the
top row even though it isn't justified anywhere. The only way I can
get it
to work is F2 enter on each line!! Please Help! I have lengthy files
and
this happens on and off for no reason that I know of.

Thanks!


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=469581

Sharon,

Try setting your calculation mode to automatic: Tools / Options... Calculation tab, check
"Automatic"

HTH,
Bernie
MS Excel MVP


"Sharon S" <Sharon wrote in message
...
When I copy a formula down my spreadsheet, it returns the same results as the
top row even though it isn't justified anywhere. The only way I can get it
to work is F2 enter on each line!! Please Help! I have lengthy files and
this happens on and off for no reason that I know of.

Thanks!

Thank you so much! I don't know how that got changed. You made it so
simple. Do you know how difficult it is to find such a simple answer from
Microsoft's website and/or Help functions?

Thanks again!

Sharon

"Bernie Deitrick" wrote:

Sharon,

Try setting your calculation mode to automatic: Tools / Options... Calculation tab, check
"Automatic"

HTH,
Bernie
MS Excel MVP


"Sharon S" <Sharon wrote in message
...
When I copy a formula down my spreadsheet, it returns the same results as the
top row even though it isn't justified anywhere. The only way I can get it
to work is F2 enter on each line!! Please Help! I have lengthy files and
this happens on and off for no reason that I know of.

Thanks!

Sharon,

That setting gets set by the first workbook that you open.

HTH,
Bernie
MS Excel MVP


"Sharon S" wrote in message
...
Thank you so much! I don't know how that got changed. You made it so
simple. Do you know how difficult it is to find such a simple answer from
Microsoft's website and/or Help functions?

Thanks again!

Sharon

"Bernie Deitrick" wrote:

Sharon,

Try setting your calculation mode to automatic: Tools / Options... Calculation tab, check
"Automatic"

HTH,
Bernie
MS Excel MVP


"Sharon S" <Sharon wrote in message
...
When I copy a formula down my spreadsheet, it returns the same results as the
top row even though it isn't justified anywhere. The only way I can get it
to work is F2 enter on each line!! Please Help! I have lengthy files and
this happens on and off for no reason that I know of.

Thanks!