ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   F2 Key not working in Excel 2007 (https://www.excelbanter.com/excel-discussion-misc-queries/179545-f2-key-not-working-excel-2007-a.html)

JodieM

F2 Key not working in Excel 2007
 
Why would My F2 key not be working in Excel 2007?
Each time I hit the F2 key it just does nothing. I'm so used to typing
F2 and then the text to append to the cell, but it just overwrites
because F2 won't open the cell for editing.
I've tried with both "Allow Editing in Cells" option turned on and off
and it makes no difference.
I'm sure it's just a simple setting but I'm not sure what it is...
does anyone know?

Thanks

JodieM

Niek Otten

F2 Key not working in Excel 2007
 
Hi Jodie,

Are you sure Function keys are enabled on your keyboard?
Many keyboards have double-function function keys and use as F keys has to be enabled with another key. On my keyboard that is the
F Lock key

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JodieM" wrote in message ...
| Why would My F2 key not be working in Excel 2007?
| Each time I hit the F2 key it just does nothing. I'm so used to typing
| F2 and then the text to append to the cell, but it just overwrites
| because F2 won't open the cell for editing.
| I've tried with both "Allow Editing in Cells" option turned on and off
| and it makes no difference.
| I'm sure it's just a simple setting but I'm not sure what it is...
| does anyone know?
|
| Thanks
|
| JodieM



SensibleSarah

Thank You! That was driving me nuts.


[quote=Niek Otten;637704]Hi Jodie,

Are you sure Function keys are enabled on your keyboard?
Many keyboards have double-function function keys and use as F keys has to be enabled with another key. On my keyboard that is the
F Lock key

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com