That is not the normal behavior of F2 in any version of Excel.
Perhaps you have a macro attached to that key. You can restore F2
to its default action with the following macro:
Sub AAA()
Application.OnKey "{F2}"
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"DJustin" wrote in message
...
I recently upgraded from Excel 2000 to Excel 2003. Now, when I
press F2 to
edit a cell, the background of the cell turns blue, and
pressing enter will
insert a new line within the cell instead of submitting the
change. This is
very different from Excel 2000, and it is causing some
frustrations for me.
I noticed that if I hit F2 twice, the background of the cell
turns yellow,
and I can edit it like in 2000.
Hitting F2 a third time returns it to blue.
There must be an option to have it use the "yellow mode" by
default instead
of the "blue mode". But I can find absolutely *nothing* in any
documentation
about what these different modes actually mean. Could anyone
fill me in?
Please do not suggest that I simply press F2 twice every time I
want to edit
a cell. :)
Thanks,
DJustin