Any way to remap "Edit the active cell" from CONTROL+U to F2?

[JerryJ]

I just bought Office 2008, but am still using Excel 2002 (under VMWare) for my workbooks that have VB :-( My Excel 2002 brain thinks CONTROL+U means underline and F2 means edit a cell. I tried to remap the edit action to F2, but couldn't find it listed in Tools->Customize Keyboard->All Commands.

Any suggestions?

 

[JE McGimpsey]

I just bought Office 2008, but am still using Excel 2002 (under VMWare) for
my workbooks that have VB :-( My Excel 2002 brain thinks CONTROL+U means
underline and F2 means edit a cell. I tried to remap the edit action to F2,
but couldn't find it listed in Tools->Customize Keyboard->All Commands.

Any suggestions?

AFAIK, F2 is not mappable to Edit Cell. I have provided a VBA solution
for XL04:

http://www.mcgimpsey.com/macoffice/excel/f2.html

I know how difficult it is, because I had to develop a bifurcated
understanding of XL when it was ported from Mac to Windows back in the
late 80's, and the WinXL team changed all the shortcuts.

 

[Jamie]

Real shame about this.

I fed back to Microsoft after Office X and again in 2004 about this and other shortcuts, but clearly nothing has been done to rectify it. It is a real shame when power users have to learn two sets of shortcuts to work effectively between a PC and Mac. It really slows you down.

Sorry, MS, but this is a big oversight.

 

[Bob Greenblatt]

Real shame about this.

I fed back to Microsoft after Office X and again in 2004 about this and other
shortcuts, but clearly nothing has been done to rectify it. It is a real shame
when power users have to learn two sets of shortcuts to work effectively
between a PC and Mac. It really slows you down.

Sorry, MS, but this is a big oversight.

Yea, but Jamie, it is the windows version that is the problem by assigning
the "wrong" keys in the first place. You just happened to learn Windows
first, many of us who started on the Mac have a similar gripe about the
windows version. You'll just have to get used to the differences, or
customize your shortcut keys.

 

[Jamie]

Bob, fair point about order of learning, but I point out the following:

1) Microsoft produced both packages. Why couldn't they have the same keys?
2) You cannot fully customize shortcuts on a Mac. i.e. some keys (like F2) are off limits and cannot be assigned a new command.
3) I believe PC keys are fully customizable, therefore PC users must 'conform' to the Mac, not vice versa.

Anyway, having read some these forums, I'm finding little reason to upgrade to 08, especially with the omission of macros/VBA. What is that all about? I thought new releases were about enhancing the product, not taking away highly useful functionality.

Cheers

Jamie

 

[Charles]

OK, this makes life hard no F2 to edit in Excel.

So what about others like F4 (absolute in a formula)?

Is there a complete list of CONTROL+ whatever keys?

 

[Bob Greenblatt]

OK, this makes life hard no F2 to edit in Excel.

So what about others like F4 (absolute in a formula)?

Is there a complete list of CONTROL+ whatever keys?

Search help for shortcut keys.

 

[JE McGimpsey]

OK, this makes life hard no F2 to edit in Excel.

Yup - I was *pissed* when XL was ported from Mac to Windows and they
didn't use the original shortcut. Made life hard then, but I adapted
pretty quickly. Still occasionally use CRTL-u in WinXL - I use an event
macro to remove underlining...

So what about others like F4 (absolute in a formula)?

This one's easier to remember for me, since CMD-t uses the CMD key. The
"new guy" doesn't have one, and so resorted to the harder-to-type F4.

Of course, for this and most other commands (though unfortunately not
CTRL-u), you can assign whatever shortcut you want using Tools/Customize
Keyboard...

Is there a complete list of CONTROL+ whatever keys?

Did you try to look in Help (say, for "Excel keyboard shortcuts")?