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?


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:

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:

IfWinActive Microsoft Excel
    Send {Enter}{Left}

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

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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