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 / Methods | Description |
|---|---|
| Symbol Name | Select ‘Latin-1 Supplement’ in the sub-set drop-down, find and insert the |
| Symbol | ® |
| Keyboard Shortcut | ALT + 0174 |
| Formula | =CHAR(174) |
| Symbol Dialog Box | Select ‘Latin-1 Supplement’ in the sub-set drop-down, find and insert the registered trademark symbol. |
| Character Map | Use 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 ®
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:
- Select the cell where you want the registered trademark symbol.
- Hold down the ALT key.
- While holding the ALT key, press 0, 1, 7, and 4 in sequence.
- 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)
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:
- Select the cell where you want the symbol.
- Click on the Insert tab in the ribbon.
- Click the Symbol icon to open the Symbol dialog box.
- Choose ‘Latin-1 Supplement’ from the Subset dropdown.
- Find the registered trademark symbol and double-click it (or select it and click on the Insert button).
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:
- Search for Character Map in the Windows search bar.
- Open the Character Map application.
- Enable the Advanced View option for more options.
- In the Search field, enter ‘Registered’ and hit enter.
- Locate and double-click on the registered trademark symbol.
- Click on the Copy button to copy it.
- 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:
| Feature | Trademark (™) | Registered Trademark (®) |
|---|---|---|
| Symbol | ™ | ® |
| Registration | Not registered with a government authority. | Registered with a government authority, such as the USPTO. |
| Legal Protection | Protection is limited. | Stronger legal protection under trademark law |
| Geographic Scope | Generally limited to the area where the mark is used. | Nationwide protection in the country of registration. |
| Use | Can be used without registration to assert rights in a trademark. | Can only be used after the trademark has been officially registered. |
| Duration | As 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:
