How to Assign Keyboard Shortcut to Symbol in Excel 2013?

Microsoft Office 2013 brings the feature of keyboard shortcuts to the symbols in all of its applications. Every person know that some standard keyboard shortcuts not only increase the outcome but also enhance the typing speed overall. These shortcuts make our work easier and we insert symbols in spreadsheet by using shortcut keys. Like Word 2013 we also add keyboard shortcuts to symbols in Excel by using AutoCorrect feature. It is an easy method for assigning and remembering keyboard shortcuts for symbols.

In Excel 2013 when we want to insert any symbol and click > Insert tab, Go to > Symbol section and Select > Symbol, there is no down arrow which shows the symbols menu such as Word. No shortcut key and code present in the Symbol dialog box. If we want to customize the ribbon there is also no button of customization below the list of command in the Excel Option dialogue box.

With the help of this article we will assign the shortcut key to a symbol in Excel with some limitation by following these steps.

Assign Keyboard Shortcut to Symbol:

To do work with this restriction in Excel and assign a shortcut key to a symbol, put the pointer in a cell and use the Symbol button in the Symbols section of the Insert tab to select and insert a symbol, such as the British Pound sign.

• Select> Symbol which is present in cell and Copy to clipboard.

• Click > File tab.

• Go to > Options from left side of menu at bottom.

• Excel Option dialog box will open, Click > Proofing from the list.

• Click> AutoCorrect option from the Proofing screen.

• AutoCorrect window will appear.
• Mark a tick on the check box of Replace text as you type.
• In the Replace edit box, type the shortcut key from keyboard and In With edit box enters the Symbol.
• We enter BP in Replace and with £ symbol.
• Press Add button, this pair will add in our list.

• Finally Click > OK button.