We’ve formerly revealed you exactly how to include key-board shortcuts to signs in Word 2013 to make it much easier to insert them right into your documents. Key-board faster ways can be contributed to signs in Excel also, but there’s no direct approach.
We’ll reveal you a workaround making use of the AutoCorrect feature in Excel to create an easy-to-remember keyboard faster way for an icon.
When you click Symbol in the Symbols area of the Insert tab, you’ll discover that there’s no down arrowhead suggesting a drop-down menu like there remains in Word.
Also, there is no Shortcut Key button or code offered on the Symbol dialog box.
Also when you right-click on a tab on the Ribbon and also choose Customize the Ribbon from the popup menu …
… there is no Customize button listed below the list of commands on the left side of the Options dialog box.
To work around this constraint in Excel and appoint a faster way key to a sign, put the cursor in a cell as well as make use of the Symbol switch in the Symbols area of the Insert tab to select and also put a sign, such as the British Pound indicator.
KEEP IN MIND: Inserting a sign in Excel is done the same way as in Word.
Select the icon in the cell as well as duplicate it to the clipboard.
Click the FILE tab.
Click Options in the list on the left side of the Info display.
On the Excel Options dialog box, click Proofing in the listing left wing.
On the Proofing screen, click AutoCorrect Options.
The AutoCorrect tab of the AutoCorrect dialog box is setup with a default listing of common misspellings and signs that will be instantly fixed or put when typing the misspelled word or set of characters related to the sign.
This checklist can be modified, so you can use it to add easy-to-remember acronyms (but not real words) to represent icons that you type commonly. As an example, we got in BP right into the edit box listed below Replace and also pasted the British Pound icon into the edit box listed below With as well as clicked Add to include our pair to the listing.
Click OK to shut the AutoCorrect dialog box and also click okay again to close the Excel Options dialog box.
Currently, anytime we intend to put a British Pound symbol right into a cell, we can type BP as well as a space and also the sign will certainly be automatically put.
Comply with the very same treatment to add any other abbreviations for often-used signs to the AutoCorrect listing for simple insertion of signs right into your Excel worksheets.