*This tutorial is for Excel 2019/Microsoft 365 (for Windows). Open up a new workbook and let’s get started! Then we’ll go over a few different ways you can add those characters to your spreadsheet. The two are almost exactly the same, but Excel treats them slightly differently. Some of them include text.īut if you want to customize what’s in your spreadsheet and open up some neat possibilities, you can also include symbols and special characters.
Written by co-founder Kasper Langmann, Microsoft Office Specialist. Share your views and comments in the comment section below. Note this code somewhere and in the future, just enter this code there and click Insert to insert it quickly.Ī pictorial demonstration to insert the symbol using the character code: Search for the symbol to insert from the list, click it, and check its code. It is visible on the bottom right section of this dialog box. In order to get rid of this tiresome task, you can use the character code of the symbol. However, searching for a symbol that you want to use frequently and inserting it using the above method is not worthy to do. Select the character that you want to insert and click the ‘Insert’ button as shown in the image below:Īs we saw in the previous sections, to insert a symbol, you need to scroll down a lot and search for the required symbol. You can find these in the tab named ‘Special Characters’ (shown below). You can insert tick marks, cross marks using the Wingdings font. For example, ‘Currency Symbol’ subset groups all the currencies and so on.Įven you can change the font to Wingdings, Webdings, to get a whole range of exciting symbols. To mitigate this, you can use the options in the ‘Subset’ drop-down button which logically groups the symbols. If you click ‘Insert’ twice, then excel would insert two symbols in the same cell.Īs you can see, the list of symbols is quite large, and searching for your symbol using the scroll bar is not an easy task. Alternatively, you can press the ‘Enter’ key on your keyboard instead of using the ‘Insert’ button. Then select it and then click on the ‘Insert’ button once.
To insert any symbol, search for the symbol from the list. The next section is for ‘Recently used symbols’ and the last one is ‘Symbol Unicode Character’. The first section provides a list of hundreds of symbols.
There are basically, three sections in this dialog box. As you can see, there are two tabs, one for ‘Symbols’ and another for ‘Special Characters’. Now, select the cell, and then navigate to the ‘Symbol’ option, as shown in the above section, and click on the ‘Symbol’ button.Īs a result, the ‘Symbol’ dialog box would appear. ‘Insert’ Tab > ‘Symbols’ group > ‘Symbol’ button Insert Symbols Using ‘Symbols’ OptionsĮven though the name of the option is given as ‘Symbols’, however, you can use the same option to insert any special character in Excel. To navigate to the in-built excel symbols option, follow the below path. In the upcoming section, we would learn to insert the symbols or the special characters using these in-built options. However, unlike the above method, excel has an in-built symbol option from where you can insert the symbols in Excel. To paste the symbol such that it matches the formatting of your cell, use Ctrl + Shift + V instead of simple Ctrl + V. The easiest way to insert a symbol or a special character in Excel is to search for that symbol in the search engine, copy it (Ctrl+C), and finally paste it (Ctrl+V) in the cell to which you want it.
0 kommentar(er)
