There are times, however, when you need to enter a symbol into a worksheet. Some typical symbols are fractions, mathematical symbols, trademark or copyright symbols, and so on. Learn how to insert symbols in this video.
- [Instructor] Most of the data you enter into an Excel worksheet will either be plain text or numbers. There will be times, however, where you need to enter a symbol into a worksheet. In this movie, I will show you how to insert those special objects into your worksheets. My sample file is the Symbols workbook, and you can find it in the chapter three folder of your exercise files collection. Let's say that there are three symbols that I want to insert. The first is the key sequence to copy a cell; on the Mac that would be command "C".
Then, the playing card needed to attend the party, and then finally the registered trademark symbol. I'll start in cell D2, which I already have selected, and that will display the key sequence to copy a cell using the command buttons icon. With D2 selected, I will go to the "Insert" tab of the ribbon and then at the far right edge of the ribbon, I will click the symbol button. That displays the symbol dialogue box and there are a couple things that you'll notice immediately.
The first is that there's a frequently-used area, and those contain the symbols I'm going to use so, we'll ignore that for now, but understand that it's there. The second item is that, yes, we have the emojis in Excel 2019 for Mac. So you can see your have your smilies and then animals, sports, and so on. In this case, I want to display a technical symbol, so I will click the double right pointing arrow, which is the "show next categories" button. And I will click the technical symbols category.
And you can see the first symbol is in fact the command button icon. It is displayed or indicated as a "place of interest" sign but you and I know what it really is. So I'll double click that, and it goes into the worksheet cell. Now, I will type a hyphen, followed by a capital "C". And return, and we get our keyboard shortcut. Now, say you want to enter a playing card. Those are also available in the symbols dialogue. So with cell D4 selected, I'll click symbol again on the "Insert" tab of the ribbon.
Now within the symbols box I can scroll up, until I find a club playing card, and I see here. Great, so we have the playing card, the six of clubs, I'll click that. Press return, and there we have it. You also noticed that there is a club icon, so if I wanted to type the number "six" followed by the club suit marker instead of the card, I could do that as well. Now finally let's look for the registered trademark symbol, and that is an "R" in a circle.
So I'll click cell D6. And then click the symbol button again. And then, let me see, I have letter-like symbols so I'll scroll up to that. And I see the first one is the "R" in the circle, that is the registered trademark. So I'll click that, and it appears in the cell. And I'll press return. One thing to note about the registered trademark symbol, is that it is typically displayed as a superscript, as you can see here. So you might have the name of a company, such as Microsoft, and then because that's a registered trademark, it would have the "R" in the circle beside it.
The ability to add symbols to your worksheets greatly enhances your ability to communicate information beyond the basic words and numbers found in Excel documents. As long as you don't use too many of them, you'll find that symbols add a lot of impact to your message.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.