The Diameter symbol (⌀) is commonly used in engineering, mathematics, and science to denote the diameter of a circle or a circular object.
It’s a straightforward yet essential symbol in technical fields, particularly in mechanical design and drafting.
It is also called the ‘O with stroke’ symbol or ‘Slashed O’ symbol, as it looks as if there is an O that is slashed by a line.
In this article, I will show you some simple ways to insert the Diameter symbol in Excel
Keyboard Shortcut to Insert Diameter Symbol in Excel
Below are the keyboard shortcuts to insert the Diameter symbol in Excel:
ALT + 0216
Below are the steps to use this shortcut to get the diameter symbol in the cell:
- Ensure the Num Lock is On in your keyboard.
- Hold the Alt key (and keep holding it).
- Type 0216 on the numeric keypad (one after the other).
- Release the Alt key to insert the diameter symbol.
When you use this shortcut once, it will insert one diameter symbol in the cell. If you want multiple of those, you can use the shortcut multiple times (or use it to insert once and then copy-paste it).
Note: You can also use this shortcut in Microsoft Word, PowerPoint as well as in MS Outlook
Inserting Diameter using the Symbol Dialog Box
To insert the Diameter symbol in Excel using the Symbol Dialog Box, follow these steps:
- Click on the cell where you want to insert the symbol.
- Navigate to the Insert tab on the ribbon.
- Click on Symbol in the Symbols group.
- In the Symbol dialog box, look for the diameter symbol (⌀). You will have to scroll a bit.
- Select the symbol, click Insert, and then close the Symbol dialog box.
Clicking the Insert button is going to insert one diameter symbol in the selected cell. If you want more than one simple, you can click the insert button multiple times.
Inserting Diameter Symbol using Formula
You can use the below formula to insert the Diameter symbol in a cell in Excel:
Note: This formula also works in Google Sheets to get the diameter symbol
Copy and Paste the Diameter Symbol into Excel
One of the easiest ways is to simply copy the diameter symbol from an external source, such as this web page or any other document, and then paste it into the cell in Excel.
Below, I have provided the diameter symbol that you can copy:
Below is a table that summarizes all the methods to insert the Diameter symbol in Excel:
|Name of Symbol
|Shortcut for Windows
|ALT + 0216
|Shortcut for Mac
|Not available; use Symbol Dialog Box
|Inserting using Symbol Dialog Box
|Find ⌀ in Symbol dialog box and click on Insert
|Inserting using Formula
In this article, I have covered methods you can use to insert the diameter symbol in Excel. You can use a simple keyboard shortcut, a formula, or the regular Symbol dialog box to get the symbol in a cell in Excel.
I have also provided the diameter symbol in multiple places in this article in case you wish to simply copy it from here.
Other Excel articles you may also like:
- How to Insert Symbols in Excel?
- Insert Delta Symbol in Excel?
- Insert Degree Symbol in Excel?
- Insert Envelope / Mail Symbol in Excel?
- Insert Registered Trademark Symbol in Excel?
- Insert Average (X-Bar) Symbol in Excel?
- Insert Alpha Symbol (α) in Excel?
- Insert Heart Symbol in Excel
- Insert Sigma Symbol in Excel