Using the Concatenate feature in Excel, you can join both the CHAR function and the year in one cell. What if you don’t want only the Copyright symbol in the cell? Maybe you want the symbol to prefix the year, say © 2020.

After typing this formula, press Enter for the results.

The complete formula should look like this: =CHAR(0169) OR =CHAR(169).

Next step, type =CHAR( and then add the Copyright symbol alt code.

In the first step, click to activate the cell that will contain the © symbol.

Obey the following instructions to use the CHAR function to insert this sign in Excel: It involved the use of the CHAR() function. There is a different method that also uses the alt code to get the Copyright symbol in Excel. You can use the alt code method to type this symbol in Excel too. If you need this symbol in a different document other than Microsoft Word, you can use the Alt Code method, or the copy and paste method. Note: This copyright symbol shortcut works only in Microsoft Word for Windows. Alternatively, type (c) and Word will use the AutoCorrect feature to insert the copyright symbol © for you.

To type the copyright symbol in Word, press Ctrl+Alt+C shortcut on your keyboard. To type this symbol on your Mac computer, press and hold the Option key whilst you hit on the g key once on the keyboard.

The copyright symbol shortcut on Mac is Option+g. This is how you may use the Alt Code method to type the Copyright symbol anywhere on your Windows PC including Microsoft Word, Excel, One Note, Sticky Note, PowerPoint or even somewhere on your browser like Docs or Word online. If you are using a Laptop that does not have the numeric keypad, you can press Fn+NmLk keys simultaneously to turn on the hidden numeric keypad for laptops with smaller keyboards. You must also turn on your NumLock key to be able to use the numeric keypad. There, check the Replace text as you type option.Note that you must use the numeric keypad to type the alt code (0169). Bring up the Symbols window as shown before and click Autocorrect. If Word doesn’t create the symbols when you close the parenthesis, you should take a look at the AutoCorrect settings. MS Word automatically creates the symbol. Alternatively, type an open parenthesis - type r and close the parenthesis. Alternatively, type an open parenthesis - type tm and close the parenthesis.

Alternatively, type an open parenthesis - type c and close the parenthesis. Related: How to Draw Using Pen Tools in Microsoft Wordīut to save time, applying the symbols with keystrokes is always better. The copyright, registered, and trademark symbols are listed in the Special Characters list. There is a faster way than searching through the numerous subsets. There is a chance you will not find the symbol you are looking for, especially if haven’t used it before as Word doesn’t display it below Recently used symbols.

Copyright symbol on keyboard pc