Excel Guides

Defining Shortcut Keys for Symbols in Excel

In Excel, shortcut keys are very important for quickly entering symbols. For example, the shortcut key for the division symbol is "/". To create a shortcut key for a symbol, follow these steps:

  1. Open the Symbol dialog box by doing one of the following:
    • On the Insert tab, in the Symbols group, click Symbol.
    • Press CTRL+SHIFT+S.
  2. Click the symbol that you want to insert.
  3. Click Shortcut Key.
  4. In the Customize Keyboard dialog box, select the key combination that you want to use as a shortcut key. For example, to use CTRL+ALT+D as a shortcut key for the division symbol, do the following:
    • In the Press new shortcut key box, type CTRL+ALT+D.


  5. Click Assign.



You can also create a shortcut key for a symbol by using AutoCorrect. For example, if you frequently use the division symbol in your worksheets, you can set up AutoCorrect so that it corrects "div" to the division symbol. To do this, follow these steps:



  1. On the File tab, click Options.

  2. In the Proofing category, click AutoCorrect Options.

  3. In the Replace text as you type section, select or clear the Replace text as you type check box.

  4. If you selected the Replace text as you type check box in step 3b, do any of the following:

    • To replace specific text with other text as you type it in your worksheet, click Add.

      In the With box, type or paste replacement text.
      In the Replace box, type or paste text that will be replaced by replacement text.
      Note:: If you want AutoCorrect to replace only specific capitalization of specific text with other capitalization (for example,"Internet" with "internet"), select or clear one or both ofthe First letter and Other letters check boxes.
      Tip: : If you want AutoCorrect to automatically correct spelling errors as well as specific capitalization of specific words (for example,"teh" with "the"), select boththe First letter and Other letters check boxes.
      Note: : If you want AutoCorrect to automatically correct spelling errors but not specific capitalization of words (for example,"teh" with "the"), clear boththe First letter and Other letters check boxes.< li >< p > To prevent AutoCorrect from correcting specific words or phrases as you type them , click Exceptions . < br / > In either of Exceptions lists , do one or more ofthe following : < br / > To add an exception , click Add . In either of Exceptions lists , do one or more ofthe following : < br / > To add an exception , click Add . In either of Exceptions lists , do one or more ofthe following : < br / > To add an exception , click Add . In either of Exceptions lists , do one or more ofthe following : < br / > To add an exception , click Add . In either of Exceptions lists , do one or more ofthe following : < br / > To add an exception , click Add . In either of Exceptions lists , do one or more ofthe following : < br / > To add an exception , click Add . In either of Exceptions lists , do one or more ofthe following : < br / > To add an exception , click Add . In eitherofExceptionslistsdooneormoreofthefollowingtoaddanexceptionclickAddintheWithboxtypeorpastetextthatwillnotbecorrectedbyAutoCorrectintheReplaceboxtypeorpastetextthatwillbecorrectedbyAutoCorrectinsteadclickOKtwice < li >< p > Click OK three times . < li >< p > Close all open programs . < li >< p > Restart your computer . < ol >< p > Now when you type "div", it will automatically be replaced by the division symbol!

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.