Create Keyboard Shortcuts to Insert Symbols in Word and Excel

BY STANLEY ZAROWIN

Q I’m beginning to handle international business, which means I need to be able to use foreign currency symbols in both Word and Excel. How do I create a shortcut for various symbols?

 

A Let’s start with Word, which is the easiest. In Word 2003, press Insert, Symbol, which engages the Symbol screen (see screenshot below). In Word 2007, press Insert on the Ribbon and then click on Symbol, More Symbols.

 

 

In the Subset dropdown box, go to Currency Symbols, click on the symbol of your choice and click on Shortcut Key to open the Customize Keyboard screen (see screenshot below). Create a shortcut code by pressing the code and clicking Assign and then Close.

 

In Excel, it’s a bit more complicated because you cannot assign a keyboard shortcut the way you can in Word. As you saw above, each symbol has a Microsoft-assigned shortcut code, but short of preparing a “cheat sheet,” there’s little chance you can remember the long code for several symbols. But there is a neat workaround, using Excel’s AutoCorrect feature, to create an easy-to-remember keyboard shortcut.

 

Begin by inserting a copy of the target symbol in a blank cell and press F2 to edit the cell, selecting just the symbol. Then press Ctrl+C to copy it to the Clipboard. In Excel 2003, press Tools and select the AutoCorrect Options. In Excel 2007, click the Office button and Excel Options. Then click on Proofing on the left of the dialog box and click on AutoCorrect Options.

 

Under Replace in the AutoCorrect Options dialog box, type a mnemonic (but not a real word) for the symbol; I selected GB for the British pound symbol (see screenshot above). Then, in the With box, press Ctrl+V to paste the symbol from the Clipboard and click on Add.

 

SPONSORED REPORT

Click-through nexus: Pushing the boundaries of sales tax compliance

Sales and use tax compliance has been complicated by nexus expansion. In this report, we provide an overview of this issue and include a handy state-by-state summary of click-through nexus or notification requirements.

QUIZ

News quiz: Making allowances for the kids and the economy

Recent news gives CPAs insight into Americans’ attitudes about children and money and gauges outlook on the economy. See how much you know about recent news and reports with this quiz.

CHECKLIST

Auditing risks in culture

Cultural flaws can seriously damage an organization. Here’s how internal auditors can reduce risks by embedding culture audits into existing audit programs.