The copyright ©, trademark ™, and registered trademark ®, symbols can be inserted quickly in Office applications using the Autocorrect feature. Typing (c), ™, or (r) will accomplish this. The other way to enter special symbols in Excel is by going to Insert > Symbol.

You can actually create your own keyboard shortcuts for inserting other special symbols in Excel such as the micro symbol (µ), delta symbol (∆), degree sign (°), plus-minus sign (±), common superscripts such as ² or ³, common fractions such as ¼, ½, ¾, dot sign (·), partial differential (∂), infinity (∞), etc.

To do this in Excel, Click on the File menu and then select Options from the drop down menu.

When the Excel Options window appears, click on the Proofing option on the left. Then click on the AutoCorrect Options button.

Add_Special_Symbols_In_Excel

Add the entries in the table listed below. Because the Autocorrect options apply to the other Office applications, you’ll find that after you add these using Excel, you can use the same shortcuts in Word, PowerPoint, Outlook, etc.

Replace:   With:
(micro)      µ
(delta)      ∆
(deg)        °
(degree)     °
(+/-)        ±
(^2)         ²
(^3)         ³
(1/4)        ¼
(1/2)        ½
(3/4)        ¾
(dot)        ·
(part)       ∂
(partial)    ∂
(inf)        ∞
(infinity)   ∞

Note that not all of the unicode characters will be displayed correctly on other computers.

By the way! If you ever want to undo when Autocorrect makes an unwanted change, such as when you really want to use (c) for the copyright symbol and not ©, right after Autocorrect changes the text, press Ctrl+z to undo and go on typing.

Leave a Reply

Your email address will not be published. Required fields are marked *

nineteen − 2 =

This site uses Akismet to reduce spam. Learn how your comment data is processed.