To add a circle bullet in Excel for Microsoft 365 on Windows, select a cell, choose Insert > Symbol > Symbol, and insert a hollow circle (○) or filled bullet (•). For a reusable list, you can also put the circle character in a formula before each cell’s text, or type it directly into a cell. Excel does not create Word-style bulleted lists automatically, so the best method depends on whether you need one bullet, several lines in a cell, or a formatted column.
What Excel means by a circle bullet
A circle bullet is a character used to mark an item in a list. The filled round bullet is • (Unicode U+2022); the open or hollow circle is ○ (Unicode U+25CB). Excel treats either one as ordinary text in a cell, rather than as a special list setting. This distinction matters: you can insert, copy, format, or remove the character like other text, but Excel will not automatically add a new bullet when you press Enter as a word processor might.
Choose the appearance that suits the list. A filled bullet is prominent and familiar in task lists; an open circle is lighter and can work well as a sub-bullet. The two symbols are different characters, not just different formatting of the same character. A font can affect their appearance, so check that the symbol looks right in the font used by your worksheet.
Choose the right method for your list
- One label or a few cells: insert or paste the character directly into each cell.
- Several lines within one cell: put a bullet at the start of each line and add line breaks within the cell.
- A long list based on another column: use a formula to place a circle before each source value.
- A decorative callout rather than cell text: use a text box or shape, which can be positioned independently of the grid.
Direct entry is simple when the list is short. A formula is easier to update when the item text changes or when many rows need the same bullet. A text box is useful for a presentation-style sheet, but its contents are not as convenient to sort and filter as ordinary worksheet cells.
Insert a circle with the Symbol command
In desktop Excel for Windows, click the cell where the bullet should go, then select Insert > Symbol > Symbol. In the Symbol dialog, choose a font that contains the desired character, such as a standard text font, and look for the filled bullet or open circle. Select the symbol and click Insert, then close the dialog. You can type the rest of the cell’s text after the symbol, adding a space if you want a gap.
For example, insert ○, type a space, and then enter “Review forecast.” The cell will display ○ Review forecast. To put the bullet before text already in a cell, edit the cell, place the insertion point at the beginning, insert the character, and add a space. Double-clicking the cell or pressing F2 lets you edit its contents without replacing the whole cell.
The Symbol dialog can contain many characters, and its layout may vary with the selected font. If you cannot find the symbol quickly, copy one of these characters and paste it into Excel: ○ •. Pasting is also a practical option in Excel for the web, where desktop symbol-insertion controls may not be available in the same form. If a pasted character becomes a square or looks unlike the example, try changing the cell’s font.
Type a bullet with a keyboard shortcut
For a filled bullet on Windows, click the cell or position the cursor while editing it, hold Alt, type 0149 on the numeric keypad, and release Alt. This produces • on typical Windows setups. Use the numeric keypad rather than the number row; laptops without a separate keypad may require a supported embedded keypad or make this method inconvenient. The shortcut is for the filled bullet, not the hollow-circle character.
On a Mac, Option+8 types a filled bullet (•) in many standard keyboard layouts. Keyboard layouts and input settings can affect character shortcuts, so if it produces a different character, use the Symbol command where available or copy and paste the symbol. For an open circle, inserting or pasting ○ is generally the straightforward approach on either platform.
To put the symbol at the start of existing text, enter the cell-editing mode first, move the cursor to the beginning, type the bullet, and add a space. If you simply type while a cell is selected, Excel replaces the cell contents; that behavior is separate from inserting a character into existing text.
Make several bullets inside one cell
When one cell needs to contain a short checklist, add a bullet at the start of each line. On Windows, edit the cell, type the first bullet and item, then press Alt+Enter to start another line in the same cell. Type the next bullet and item, and repeat as needed. On Mac, the in-cell line-break shortcut is commonly Control+Option+Return; keyboard behavior can vary, so use the shortcut supported by your Excel version and keyboard.
For example, one cell could contain three lines: “○ Confirm date,” “○ Check quantities,” and “○ Send summary,” with a line break between each. The quotes here show the text only; do not type them unless you want quotation marks in the cell. Turn on Home > Wrap Text if the lines are not fully visible, and adjust the row height if necessary. Excel may expand a row automatically, but manual row-height settings can prevent that.
A multi-line cell is convenient for a compact note, but it has trade-offs. Sorting treats the whole cell as one value, and you cannot easily filter for one checklist item as if each line were its own record. If the items need to be sorted, counted, or filtered individually, put each item in a separate row and add the bullet to that row instead.
Build a bullet column with a formula
A formula can add the same circle to text in another cell. This keeps the original item separate and lets the displayed list update when the source text changes. With item text in A2 and the display formula in B2, enter:
=UNICHAR(9675)&" "&A2
The formula returns a hollow circle, a space, and the value from A2. For instance, if A2 contains Apples, B2 displays ○ Apples. Fill the formula down to apply it to more rows. The UNICHAR function returns the character identified by its Unicode number; 9675 is the decimal code for the open circle.
To use a filled bullet instead, with the same layout of source text in A2 and the formula in B2, use:
=UNICHAR(8226)&" "&A2
Here 8226 is the Unicode number for •, so if A2 contains Apples the result is • Apples. These formulas add display text; they do not alter the source value in column A. If you need a static list rather than a live formula, copy the formula results and use Paste Special > Values to replace the formulas with their displayed text.
Format and align the bullets
Once a symbol is in a cell, use the usual cell formatting controls. Select the cells and choose a font size, font color, or alignment from the Home tab. Use Home > Wrap Text for longer items, and adjust column width and row height so the text is readable. A narrow column can make a bullet list appear cramped even when the symbol itself is inserted correctly.
Excel aligns cell contents within the cell, not as a hanging-indented list by default. If wrapped lines should start under the item text rather than under the bullet, a formula with spaces may look acceptable in some fonts, but spaces do not create a reliable hanging indent. For a polished layout, consider using a separate narrow column for the bullet and a neighboring column for the item text. You can then align the bullet column centrally and wrap the item text in the wider column.
Changing a cell’s font size can also change the bullet’s apparent size and spacing. If a bullet looks too small beside the words, select only the bullet while editing the cell and apply a larger font size, or use a different circle character. Character-level formatting is possible for manually entered text, but a formula-generated bullet generally shares the cell’s formatting with the rest of the formula result.
Common problems and fixes
- The bullet appears as a box: change to a font that supports the character, or insert and test a different circle symbol.
- The shortcut types numbers or replaces text: make sure you are editing the cell, use the numeric keypad for the Windows Alt code, and place the cursor where the symbol belongs.
- Only one line appears: turn on Wrap Text, widen the column, or increase the row height.
- The formula shows an error: confirm that the source cell reference is valid and that the formula begins with an equals sign; check that quotation marks are straight quotes.
- The list does not sort as expected: remember that a multi-line checklist inside one cell is a single cell value. Use separate rows for separate list items.
Also check whether the cell is formatted as text before entering a formula. If Excel displays the formula characters instead of calculating them, change the cell format to General and re-enter the formula. A leading apostrophe can also make an entry display as text instead of being evaluated.
When a text box or another layout is better
A text box is useful when you need a visually arranged list for a dashboard, handout, or worksheet cover. In desktop Excel, use Insert > Text Box, draw the box, and type or paste the circle characters and text. A text box can be moved without changing cell contents, but it is a floating object: it does not behave like a normal table of records and may not follow sorting the way worksheet data does.
For data that people will analyze, keep each list item in its own row and use a dedicated bullet column or a formula-generated display column. For a short note, a single cell with line breaks is usually simpler. The key question is whether the list is meant to be decorative text or structured worksheet data; choose the layout based on how readers will use it later.
Frequently Asked Questions
How do I insert a hollow circle bullet in Excel?
Use Insert > Symbol > Symbol in desktop Excel and insert ○, or copy and paste the character. The Windows Alt+0149 shortcut produces a filled bullet, not a hollow circle.
Can I make Excel add a bullet automatically when I start a new row?
Excel cells do not have Word’s automatic bulleted-list behavior. Insert or paste the character, use a formula for a bullet column, or set up a text box for a decorative list.
How do I put multiple bullets in one Excel cell?
Edit the cell, type a bullet and its item, add an in-cell line break with Alt+Enter on Windows, then type the next bullet and item. Enable Wrap Text so the lines can be seen.
Can I use a formula to add bullets to many cells?
Yes. Put the source text in one column and use a formula such as UNICHAR(9675) followed by a space and the source-cell reference in another column. Fill the formula down to create the rest of the displayed list.
Why does my circle bullet display as a square?
The selected font may not contain or display that character correctly. Try a standard text font, paste the character again, or choose another circle symbol from the Symbol dialog.
Related
- Excel Solver: Setup, Optimization Models, and Fixes
- Solver in Excel: Where to Find It and How to Enable It
- Excel Solver Parameters: How to Set Them Correctly
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Why Did My Excel File Get Corrupted?Your Excel file most likely became corrupted because something interrupted a save, damaged the file while it was…
- Excel Conditional Formatting for Dates Coming DueTo highlight Excel dates coming due, select the date cells, choose Home > Conditional Formatting > New Rule…
- Excel Slicer Colors: How to Change and Customize ThemTo change Excel slicer colors in Microsoft 365 for Windows, select the slicer, open the contextual Slicer tab,…
- How to Highlight Color in Excel: Cells, Rules, and MoreTo highlight cells in Excel, select the cells, open Home > Fill Color, and choose a color. For…
- Q-Q Plot in Excel: How to Make and Read OneTo make a normal Q-Q plot in Microsoft Excel for Microsoft 365, sort your observations, calculate matching standard-normal…
- How to Delete a Whole Row in Excel Safely and CleanlyTo delete a whole row in Excel for Microsoft 365 on Windows, click its numbered row header, right-click,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.