Modify Keyboard Shortcuts? Excel 2007

[DougG]

I've been searching for a way to modify Excel 2007's keyboard shortcuts. So
far, no luck here or elsewhere.

Specific example: when I press CTRL+F, I want to go directly the REPLACE
tab of find + replace window (currently ctrl+H does this, while ctrl+F goes
to the FIND tab).

Thanks,
Doug

 

[Sheeloo]

If you know how to add macros to personal.xls then add the following
Sub findReplace()
Application.SendKeys ("^h")
End Sub

and assign the CTRL-f key to it.

 

[Chirag]

Look at Shortcut Manager for Excel at
http://officeone.mvps.org/xlsctmgr/xlsctmgr.html - it allows you to define
your own keyboart shortcuts to Excel menu items and macros. To define Ctrl+F
for Replace, do the following:
1. Download and install Shortcut Manager for Excel.
2. Start Excel and select "Add-Ins" tab, click "Customize Shortcuts" item.
3. Select "Edit" category.
4. Locate and select "Replace..." command.
5. Assign Ctrl+F shortcut to it.
6. Click OK button.

- Chirag

PowerShow - View multiple PowerPoint slide shows simultaneously
http://officeone.mvps.org/powershow/powershow.html

 

[DougG]

I didn't before, but I do now. Thanks - that worked perfectly. Pretty weird
that there's no simple way to change the shortcut keys though.

The Shortcut Manager mentioned in Chirag's reply looked good until I saw
that it costs $30 after the trial period...

 

[Lozzaw]

Hi

I'm also interested in this. What would be the code for both increasing and
decreasing the number of decimal places?

Thanks