LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function syntax to compare cell contents ES Excel Worksheet Functions 2 May 18th 05 03:53 PM
Cell addressing using the content of another cell. De Jandon Excel Worksheet Functions 5 April 1st 05 10:59 PM
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? g wills New Users to Excel 3 February 17th 05 10:23 PM
Edit cell value Sumit New Users to Excel 2 February 15th 05 12:45 PM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM


All times are GMT +1. The time now is 05:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"