View Single Post
  #1   Report Post  
DJustin
 
Posts: n/a
Default Using F2 to edit a cell

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