PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

ADDING COPYRIGHT SYMBOL IN EXCEL

INTRODUCTION

Let us start another exciting session of Excel Tricks with gyankosh.net
This article will let you know how to insert different symbols or specifically copyright, divide and checkmark symbol in your excel sheet.
These symbols are handy while making many reports but we find hard to find these symbols as these are not available on the keyboard. The symbols present on the keyboard can be easily found but not these.
So we’ll take up one by one all the symbols and check the main and easy methods only to insert them.
The methods, which are easy and you won’t forget easily.
Let us start.

 

ADD A COPYRIGHT SYMBOL IN EXCEL

  1. There can be different ways of creating a copyright symbol in your sheet in Excel.
We’ll go through each of the method one by one to search out the options for finding out the ways to add copyright symbol.

DIFFERENT METHODS OF ADDING A COPYRIGHT SYMBOL

  1. USING GOOGLE
  2. USING SYMBOL
  3. USING FUNCTION
  4. USING KEYBOARD

1.INSERT COPYRIGHT SYMBOL IN EXCEL USING GOOGLE

We all have such a vast knowledge of our work area, we all do. But what happens when we don’t use some special knowledge for a long time, we start forgetting it. This is a case with each one of us.

So it is quite possible that we forget the procedures of symbol insertion by the time of the need. So this method is for those friends who have forgot the symbol insertion methods.

Here are the steps.

  •  Open google.com in your browser.
  • Type in the searchbox copyright symbol. (no need to ask for the procedure)
  • The following picture will appear on tahe screen. There can be a bit difference too due to region etc.
insert copyright symbol in excel easiest way
EXCEL:OPEN GOOGLE AND TYPE COPYRIGHT SYMBOL
  •  Now look at the page and search for a COPYRIGHT SYMBOL but mind it, we don’t want an image.
  • Most of the bigger pictures are images, we want text, so select the one which is shown in the picture as selected and copy it. [For copying select the symbol and press CTRL+C or use RIGHT CLICK and choose COPY]
  • Paste it anywhere in the sheet. [Select the cell and press CTRL+V or RIGHT CLICK and choose PASTE]
  • The copied symbol will respond to font size as well as to font.
NOTE: Don’t copy the image by change. Image is tough to handle and won’t respond to the font and text size.
copyright symbol excel
EXCEL: PASTING THE COPYRIGHT SYMBOL IN THE EXCEL SHEET

2.INSERT COPYRIGHT SYMBOL IN EXCEL USING SYMBOLS

  • The other method of inserting a copyright symbol is using the SYMBOL INSERTION FACILITY.

There is a complete table in the MICROSOFT EXCEL having a full fledged list of a big number of symbols from where we can choose the symbols we like. Follow the following steps to insert the symbol in the Excel using symbol dialog box.

STEPS

  • Open the Excel software.
  • Go to INSERT TAB and CLICK SYMBOL or Press ALT+N+U to open the SYMBOL DIALOG BOX directly.
insert copyright link easily in excel
EXCEL:OPEN SYMBOL DIALOG BOX
  • Select the COPYRIGHT SYMBOL from the list and click INSERT.
  • The copyright symbol will get inserted in the selected cell.
  • We can also select the symbols from the second tab called SPECIAL CHARACTERS shown below.
special character choosing copyright symbol image
EXCEL: CHOOSING COPYRIGHT SYMBOL FROM SPECIAL CHARACTERS
  • Click INSERT and the copyright symbol will be inserted.
inserted copyright symbol in excel
EXCEL: INSERTED COPYRIGHT SYMBOL

3.INSERT COPYRIGHT SYMBOL IN EXCEL USING FUNCTION

We already learnt to insert a COPYRIGHT SYMBOL using the google and symbol dialog box. Now if we remember the ASCII code for the COPYRIGHT SYMBOL, we have an option of inserting the symbol directly into the spreadsheet. This is the fastest method as it is directly applied in the sheet. Let us learn this.

STEPS

  • Open the Excel software.
  • Select the cell where you want to insert the copyright symbol.
  • Enter the following function
     =CHAR(169) and press ENTER. The symbol will be inserted.
insert copyright using function
EXCEL:INSERTING COPYRIGHT CHARACTER USING FUNCTION

Now we have inserted the copyright symbol. But you must be wondering where to get the code 169.

These are ASCII codes given to different characters. It is a one time job and we can find it from the SYMBOLS DIALOG BOX itself. Here are the steps to find out the ASCII codes of the characters.

STEPS TO KNOW THE ASCII CODES OF SPECIAL CHARACTERS:

  •  Go to INSERT TAB and click symbols.
  • The following screen will open.
insert copyright link easily in excel
EXCEL: OPENING SYMBOL CHOOSE BOX IN EXCEL
  • Now select the character whose ASCII CODE or CHARACTER CODE you want to know.
  • The character code window is shown below.
finding ASCII code of a character
EXCEL: CHARACTER CODE OR ASCII CODE IS SHOWN IN THE PICTURE

4.INSERT COPYRIGHT SYMBOL IN EXCEL USING KEYBOARD

There is another very fast method of inserting any character or to be specific COPYRIGHT SYMBOL in our case, in the sheet instantly.
The method is to press ALT and press the CHARACTER CODE WHILE THE ALT KEY IS PRESSED.
But for our case, we need to first select the font and then press ALT and press 0169 WHILE ALT IS PRESSED.

 

INSERT COPYRIGHT SYMBOL THROUGH KEYBOARD EASILY
EXCEL:COPYRIGHT SYMBOL USING KEYBOARD
So these were a few methods of inserting check mark symbol in excel.
Although there can be a few more too but these are the most easiest and useful ones. Because after all, the main aim is to the work fast and efficiently.

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

gyankosh060309@gmail.com

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: