Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to create specific keyboard shortcuts with only one key in Excel 2007. For example:

  • when I press Enter I want to move one cell left and then one cell down

  • and when I press * to move one cell right

I'm trying to do this with macros, but Excel only lets me use keyboard combinations -- e.g., Ctrl+T, Ctrl+Shift+H. Is it posible to create these shortcuts with only one key in Excel 2007?

share|improve this question
    
If you want to move one cell to the right and 'Enter' is an option for one of your 'hot' keys, is there any reason not just to change your Editing options? –  pnuts Jul 20 '12 at 17:45
add comment

1 Answer

up vote 4 down vote accepted

You will need to use Autohotkey to achieve this.
It's a free automation and scripting utility for windows and you can get it from here:
http://www.autohotkey.com/download/

You can combine IfWinActive with a hotkey to achieve your requirements.
I am writing the script for you but I would encourage you to explore and learn the tool so that you can use for other purposes as well.

This is the script:

Enter::
IfWinActive Microsoft Excel
    Send {Enter}{Left}
return

P.S. I would recommend against assigning * as hotkey.
That way, you will not be able type * in Excel

share|improve this answer
    
it is weird, I know :), but I need it for my work...I will try the up solution.Thanks –  DiscreteMath'sFan Jul 21 '12 at 5:17
    
tumchaaditya your solution works like a charm. THANKS!!! –  DiscreteMath'sFan Jul 21 '12 at 5:27
    
happy to help.. :) –  tumchaaditya Jul 21 '12 at 18:34
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.