Formatting Issues

How to Type a Centered Dot Character in Excel

Algirdas JasaitisAlgirdas Jasaitis Oct 22, 2026 873 views

Question details

The user needs to learn how to input a centered dot (middle dot) special character into a cell within an Excel worksheet.

How to Type a Centered Dot Character in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Double-click the cell

Double-click the specific cell where you want to insert the centered dot, or press F2 to enter edit mode.

2
Enable Num Lock

Press the Num Lock key on your keyboard to ensure the numeric keypad is active.

3
Type the Alt Code

Press and hold the Alt key, then type 0183 sequentially on the numeric keypad.

4
Release the Alt key

Release the Alt key, and the centered dot character will immediately appear in the cell.

Tip: If you are on a laptop without a numeric keypad, you may need to use the 'Fn' key in combination with other keys to simulate a numpad, or use the Symbol dialog method instead.

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. 1. Open your document in WPS Office: Launch WPS Spreadsheet and open your existing workbook or create a new one.
  2. 2. Select your cell: Double-click the cell where the centered dot should be placed.
  3. 3. Access the Symbol menu: Go to the Insert tab on the top menu and select Symbol.
  4. 4. Insert the dot: Choose the middle dot character from the list and click Insert.
Intuitive Symbol dialog box for fast character insertion.Seamless compatibility with Microsoft Excel (.xlsx) files.Free to use with a clean, familiar user interface.Lightweight software that runs smoothly on both older and modern devices.
microsoft office alternative - wps office

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.