Insert Registered Trademark Symbol in Excel

The Registered Trademark symbol (®) is used to signify that a word, phrase, symbol, or design is registered as a trademark.

You must have seen it many times with many brand names indicating that the brand name is a legally registered trademark.

In some cases, you may also need to insert the registered trademark symbol in Excel.

Let me show you some easy ways to get the Registered Trademark symbol in your Excel spreadsheet.

Insert Registered Trademark Symbol in Excel

Below are some details about the Registered Trademark symbol in Excel. Detailed steps for each method to insert the symbol in Excel are covered after the table.

Details / MethodsDescription
Symbol NameSelect ‘Latin-1 Supplement’ in the sub-set drop-down, find and insert the
Symbol®
Keyboard ShortcutALT + 0174
Formula=CHAR(174)
Symbol Dialog BoxSelect ‘Latin-1 Supplement’ in the sub-set drop-down, find and insert the registered trademark symbol.
Character MapUse Windows Character Map to copy and paste the registered trademark symbol.

Manually Type the Registered Trademark Symbol in a Cell in Excel

The easiest way to get the Registered Trademark Symbol in Excel is by typing it.

Although you do not have a dedicated key to insert the registered trademarks below the short code that you can enter in a cell followed by a space character to get it

(r)

To use this, manually type (r) in a cell and then press the space bar key or hit the enter key. As soon as you do that, (r) will be converted into ®

Type registered trademark symbol in Excel

If you want to get the Trademark symbol instead, you can manually enter ™ in a cell and press the Space or Enter key.

Also read: Insert Copyright Symbol in Excel

Copy and Paste the Registered Trademark Symbol into Excel

Another super easy way to get the registered trademark symbol is to copy it from some other Excel file or any other document or any web page on the internet and paste it into a cell in Excel.

You can copy it from below:

®

Keyboard Shortcut to Insert Registered Trademark Symbol in Excel

You can also use the below keyboard shortcut to get the register trademark symbol in a cell in Excel

ALT + 0174

Here are the steps on how to use this shortcut:

  1. Select the cell where you want the registered trademark symbol.
  2. Hold down the ALT key.
  3. While holding the ALT key, press 0, 1, 7, and 4 in sequence.
  4. Release the ALT key.

As soon as you release the ALT key, the registered trademark symbol will appear in the cell.

Note that the shortcut can only be used if you have a numeric keypad on your keyboard and the Num lock needs to be ON

Pro Tip: To insert the registered trademark symbol in MS Word, type 00AE, hold the ALT key, and then press the X key.

Formula to Get the Registered Trademark Symbol

You can also use the below CHAR Formula to get the registered trademark symbol in a cell in Excel.

=CHAR(174)
Formula to get the registered trademark symbol in Excel

This formula can also be used in Google Sheets to get this symbol

Inserting Registered Trademark Symbol Using the Symbol Dialog Box

Below are the steps you can use to insert the ® symbol using the Symbol dialog box:

  1. Select the cell where you want the symbol.
  2. Click on the Insert tab in the ribbon.
Click on the insert tab in the ribbon
  1. Click the Symbol icon to open the Symbol dialog box.
Click on the symbol icon in Excel Ribbon
  1. Choose ‘Latin-1 Supplement’ from the Subset dropdown.
Select the Latin 1 Supplement Option in the subset drop down
  1. Find the registered trademark symbol and double-click it (or select it and click on the Insert button).
Select and insert the registered trademark symbol

Using the Character Map App in Windows

The final method I want to show you is to use the character map app in Windows to get the registered symbol in Excel.

Note that this is independent of Excel, and you can use this method to get the symbol in any app in Windows.

Below are the steps to do this:

  1. Search for Character Map in the Windows search bar.
  2. Open the Character Map application.
  3. Enable the Advanced View option for more options.
Click the Advanced View option in Character Map dialog box
  1. In the Search field, enter ‘Registered’ and hit enter.
Search for registered in the character map dialog box
  1. Locate and double-click on the registered trademark symbol.
  2. Click on the Copy button to copy it.
Copy the registered trademark symbol by clicking on the copy button
  1. Paste it into an Excel cell or any desired location.

These are some of the methods you can use to easily get the registered trademark symbol in a cell in Excel.

Also read: Insert Infinity Symbol in Excel

Trademark vs Registered Trademark

Trademarks are used by businesses to protect their brand identity in commerce.

A Trademark that is not registered with a government authority is typically denoted with the ™ symbol, which signifies that the mark is being claimed as a trademark; however, it does not necessarily mean that the mark has legal protection under trademark law.

A Registered Trademark, on the other hand, is a trademark that has been officially registered with a government authority, such as the United States Patent and Trademark Office (USPTO) in the United States.

The ® symbol denotes a registered trademark and signifies that the mark has been legally registered and has certain legal protections. Only trademarks that have been officially registered can use the ® symbol.

Here is a table summarizing the key differences:

FeatureTrademark (™)Registered Trademark (®)
Symbol®
RegistrationNot registered with a government authority.Registered with a government authority, such as the USPTO.
Legal ProtectionProtection is limited.Stronger legal protection under trademark law
Geographic ScopeGenerally limited to the area where the mark is used.Nationwide protection in the country of registration.
UseCan be used without registration to assert rights in a trademark.Can only be used after the trademark has been officially registered.
DurationAs long as it’s in use and can be enforced under common law.Must be renewed periodically (usually every 10 years in the U.S.) to maintain registration.

I hope you found this Excel article helpful.

If you know of any other method to insert the Registered Trademark symbol in Excel or you have any feedback on any of the methods I have written, do let me know in the comments section.

Other Excel articles you may also like:

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.
Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster