Hi Lena,
I personally like having F1 and SHIFT+F1

I would not recommend trying the following at home (or at work)
as it will disable the F1 key.

The following would go into ThisWorkbook

Sub Workbook_Open()
Application.OnKey "{F1}", ""
End Sub

As far as the CAPS Lock goes physical removal (on non laptops)
works best. For laptop a bit of poster putty under left side of key
works for awhile..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


"Lena" wrote in message ...
I pretty often hit F1 accidently instead of F2 when I want to edit the data
in a cell. I want to change the Help key (F1) to something different, so I
won't have this problem anymore, but I can't find a way. Could it be that it
is impossible to change the function keys?