While Excel has a number of special characters for you to work with, they require a number of menu choices to insert them. You can speed up data entry by creating a button or shortcut key for inserting frequently used special characters. For example, suppose the Sales Journal worksheet requires the user to enter a check mark in column D for each transaction posted to the Sales account in the General Ledger. To create a shortcut key, follow these steps:
- Go to Tools | Macro | Record New Macro.
- Enter Check Mark in the Macro name box.
- Enter K in the [Ctrl] box.
- Click OK.
- Go to Insert | Symbols.
- Click the Symbols tab and scroll to and select Wingdings from the Font drop-down menu.
- Scroll to and select the ✓ symbol.
- Click Close.
- Go to Tools | Macro | Stop Recording.
To enter the Check Mark into the Sales Journal worksheet column D cell, press [Ctrl]K. You can also create a button for the Formatting toolbar that will enter the Check Mark. Follow these steps:
- Go to Tools | Customize.
- Click the Commands tab and select Macros under Categories.
- Under the Commands list, click and drag the Custom button to the Formatting toolbar.
- Click the Close button.
- Right-click the Custom button, move to Change button image, and click the picture of the pencil.
- Right-click the Custom button and select Assign Macro.
- Click Check Mark and then click OK.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.