Buzz
Drafting text using Microsoft Excel is quite common. While composing a short document poses no issue, writing a lengthy one consumes a significant amount of time. In long documents, repetition of words, phrases, and combinations thereof is frequent. To save time in composing documents faster, Microsoft Excel has introduced a feature allowing users to create shortcuts.
Quick Guide: Creating Shortcuts in Excel
Step 1: Open the dialog box to create shortcuts
- Navigate to File --> Options menu.
- Open Excel Options window, select Proofing --> AutoCorrect Options....
Step 2: In the AutoCorrect window: under English, input the words, phrases, or combinations to create shortcuts in the 'With' field. In the 'Replace' field, input the shortcut keys to replace the words entered in the 'With' field.
Thus, you have efficiently created shortcuts.
Now instead of typing a long string of words like 'Guide to creating shortcuts in Excel,' you only need to type 'h' and you're good to go.
