How do I insert an angle symbol

Enter unusual special characters in Excel

Heinrich Puju

In tables, special characters are sometimes required for units of measurement, currencies, logical operations and arithmetic symbols. However, if the character is rarely used, it can be entered with the help of the symbol function. If you need it more often, you probably prefer to use the keyboard key in Excel.

EnlargeExcel special characters can be called up via the "Insert -> Symbol" tab.

Select symbol: The whole range of available special characters opens up in Excel if you click on "Insert ➞ Symbol" and select "Unicode (hex)" at the bottom of the dialog window next to the character code in the "from" field. The dialog window then shows that Excel has a comprehensive range of letters and numbers, divided into subgroups of various symbols.

To quickly find a currency symbol, a Greek letter, an arrow or even a mathematical operand, click on the “Subset” list field and mark the corresponding entry. This makes it easier to orientate yourself in the characters displayed than if you let the content scroll past by dragging the position field in the scroll bar.

A double click on the symbol you are looking for inserts it directly into the active cell of the table. At the same time, the inserted character is included in the "Last used symbols" row so that you do not have to search for it when you open the dialog window again, but can double-click it to insert it in the dialog window.

You can also enter the first 224 characters that are displayed in the character table without going through the symbol window. The sequence of numbers that you need for direct entry can be found in the "Character code" field if you switch to "ASCII (decimal)" in the "From" field next to it. For example, the sequence of numbers for the yen symbol is 165. And if you press the Alt key in a cell in the table and then type 0165 (i.e. with a leading zero) on the numeric keypad, after you press the Alt key have released in the cell ¥.

Eight tips to keep in mind with Excel spreadsheets

EnlargeSpecial characters that you often need can be combined in the auto-correction options with a character combination that then serves as an input abbreviation in the table cell.

Automatic symbols: Users who want it to be even more convenient or who need characters for which no decimal code is displayed can use the symbol dialog window to add the desired character - for example the Omega Ω - with the appropriate "subset" - in this case "Greek and Coptic" - in a cell and click on "Close". Then mark the character Ω by pressing the shift key and at the same time pressing the left arrow key. Now press the Ctrl key and the C key together to copy it.

After copying the character, click Tools ➞ AutoCorrect Options in Excel 2003, click the Office icon in Excel 2007, then click Excel Options ➞ Document Review ➞ AutoCorrect Options, and in Excel 2010 click File ➞ Options ➞ Document Review ➞ AutoCorrect Options ".

Then click in the “Through” field and press the Ctrl key and the V key at the same time to insert the Ω. Now click in the "Replace" field and enter a combination of characters that normally does not appear in texts, for example the degree symbol ° followed by an o, i.e. ° o. Such a combination has the advantage that you can later use the introduction by the degree symbol for other special characters that you need, for example ° z for the sigma ∑ as a summation symbol.

Confirm your entry with "Add" and close the opened dialog window with "OK". Whenever you enter ° o in a cell, the string is automatically replaced by the omega Ω. The only prerequisite for this is that the character string is just like a word separate, that is, either alone in a cell or separated from preceding or following entries in the cell by spaces, punctuation marks or brackets.