Hi, I have two issues that I've run into with Excel that have me stumped.

1) I am trying to mirror a row of values (via formulas) from one sheet to
another. I do not want to simply cut and paste b/c I am udating the sheets.
Typically I copy one cell and then drag it across the row to fill in the
remaining cells. Right now, however, the worksheet is simply repeating the
same value instead of inputting 'value + 1 (column)'.

Ex. I want to have a mirror of cells B2-B6 so I input on the new sheet, C5
= 'Orig. Sheet'B2. I then drag the corner of C5 across the row to try to
fill in with B3, B4, B5, B6 from the original sheet....Instead what I'm
getting is B2, B2, B2, B2.....

Any idea what setting might have changed or how to get it back to the way I
would prefer?

That leads me to my second question which is more of a general Excel
question...

2) Excel seems to sometimes change settings when I open and close it. For
instance, I always prefer to "edit directly in cell", however, many times I
will have to click this check box each time I open a file (even the same one
that's been saved the other way). I am confused as to why it keeps
defaulting back to a setting and forces me to manually change it. Is it
possible that there is a bug in my version of the program?

Thanks for any ideas.