How to Type a Centered Dot Character in Excel
Question details
The user needs to learn how to input a centered dot (middle dot) special character into a cell within an Excel worksheet.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Formatting text or entering mathematical notation that requires a middle dot separator.
- Observed behavior
- The user requires the specific keyboard shortcuts or menu navigation steps to successfully insert the character.
Ensure your keyboard has a dedicated numeric keypad if you plan to use the Alt code shortcut, and verify that the Num Lock key is activated.
Use the Alt Code Keyboard Shortcut
The fastest method to insert a centered dot is by using a specific combination of keys on your numeric keypad.
This method requires a standard keyboard with a separate numeric keypad. The numbers located in the top row above the alphabet keys will not work for Alt codes.
Double-click the specific cell where you want to insert the centered dot, or press F2 to enter edit mode.
Press the Num Lock key on your keyboard to ensure the numeric keypad is active.
Press and hold the Alt key, then type 0183 sequentially on the numeric keypad.
Release the Alt key, and the centered dot character will immediately appear in the cell.
Insert Using the Symbol Dialog Box
Use Excel's built-in Symbol menu to find and insert the centered dot visually without needing a numeric keypad.
Insert Special Characters Easily in WPS Spreadsheet
WPS Office offers a fully featured, lightweight spreadsheet tool that makes formatting and inserting special symbols like the centered dot incredibly straightforward. You can achieve professional-looking spreadsheets with 100% compatibility with Microsoft Excel formats.
- 1. Open your document in WPS Office: Launch WPS Spreadsheet and open your existing workbook or create a new one.
- 2. Select your cell: Double-click the cell where the centered dot should be placed.
- 3. Access the Symbol menu: Go to the Insert tab on the top menu and select Symbol.
- 4. Insert the dot: Choose the middle dot character from the list and click Insert.

Frequently Asked Questions
Why isn't the Alt+0183 shortcut working on my laptop?
The Alt code method specifically requires a numeric keypad. Most modern compact laptops lack this keypad. The standard number keys at the top of your keyboard will not trigger the symbol. Instead, use the Insert > Symbol menu or utilize the on-screen keyboard.
Can I use an Excel formula to insert a centered dot?
Yes, you can use the CHAR function. Typing =CHAR(183) in an empty cell will return a centered dot character. You can also combine this with other text using the ampersand, such as ="Word1" & CHAR(183) & "Word2".
How do I type a centered dot on a Mac?
If you are using Excel on a Mac device, the Alt code method does not apply. Instead, you can simply press Option + Shift + 9 on your Mac keyboard to insert a middle dot.




