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.

How to set up a keyboard shortcut for specific symbol in MS Excel? Let's say euro sign wanted on Ctrl+Alt+e.

share|improve this question
add comment

2 Answers

up vote 2 down vote accepted

There isn't a straightforward way to do this (like there is in Word).

You can, however define a macro:1

  1. (might not be needed) Click the Office button and select Options. Activate Show Developer Options. Close the popup.

  2. Go to the Developer tab and click Macros.

  3. Type in a name (e.g., Euro) and click Create.

  4. Change the code to

    Sub Euro()
        Selection.Value = "€"
    End Sub
    

    and close the window.

  5. Click options and select a keystroke sequence.

    As far as I know, you cannot choose Ctrl + Alt + E.

    You could, however, choose Ctrl + Shift + E.

1 The instructions are for Excel 2007. They're also translated from Spanish.

share|improve this answer
add comment

An AutoHotKey script can be used to do this. See the following guide.

http://www.howtogeek.com/howto/21187/insert-any-special-character-with-a-single-keystroke/

The euro sign is one of the examples:

!e::
{
SendInput {€}
}
return
share|improve this answer
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.