To add a bullet in an Excel cell, edit the cell, type a bullet using Alt+0149 on the Windows numeric keypad, press Alt+Enter to start another line in the same cell, and repeat. You can also use Insert > Symbol to insert the bullet character, then turn on Wrap Text if the list needs multiple lines.
How bullets work in Excel
Excel does not provide a dedicated bullet-list button like Word does. A bullet is simply a text character placed in a cell, so you can type, paste, or generate it just as you would other text. This gives you flexibility, but it also means Excel does not automatically create a new bulleted item when you press Enter. Enter normally confirms the cell and moves the selection.
There are two common ways to use bullets:
- One bullet per row: Put each item in its own cell, usually in one column. This is easier to sort, filter, count, and use in formulas.
- Several bullets in one cell: Put each item on a separate line inside a cell. This can make a compact note or checklist, but the individual items are harder to sort and analyze.
Choose the layout based on what the data is for. A short set of instructions in a report may be clearer as a multi-line cell. A list of products or tasks that you need to filter is usually better as separate rows, with the bullet added only for presentation if needed.
Type a bullet with a Windows keyboard shortcut
In Excel for Microsoft 365 on Windows, select a cell and begin editing it by double-clicking or pressing F2. Hold Alt and type 0149 on the numeric keypad, then release Alt. The character • should appear. The number row above the letters is not a substitute for the numeric keypad in the standard Alt-code method. On a laptop without a separate keypad, you may need to use a built-in numeric keypad mode or choose another method below.
To make a list within the same cell, type the first item after the bullet, press Alt+Enter to insert a line break, and type the next bullet and item. Repeat for each line. For example, a cell could contain “• Confirm the order”, then a line break, then “• Send the receipt”. Press Enter when the whole cell is complete.
On a Mac, Option+8 inserts a bullet character in many Mac applications, including Excel. To start a new line within a cell in Excel for Mac, use Control+Option+Return. Keyboard behavior can depend on the keyboard and macOS settings, so if a shortcut does not work, use Insert > Symbol where available or copy and paste the character.
Insert a bullet from the Symbol dialog
If the Alt code is inconvenient, Excel’s desktop Symbol dialog offers a point-and-click method. Select the cell and place the insertion point where the bullet should go. On the ribbon, choose Insert > Symbol > Symbol. In the dialog, locate the • character, select it, and choose Insert. Close the dialog when finished, then type the item text. The exact symbols shown can vary with the selected font; common text fonts include a standard bullet character.
You can repeat the insertion for each item, or insert one bullet and copy it to reuse elsewhere. Another quick option is to copy this character—•—from here or another document and paste it into the cell. Pasting is often the simplest choice in Excel for the web, where desktop keyboard shortcuts and symbol-insertion options may not be available in the same way. After pasting, check that the character displays in the cell’s font.
Build a multi-line bullet list in one cell
For several bullets in one cell, first make sure you are editing the cell rather than just selecting it. Type a bullet, add a space, and enter the first item. Use Alt+Enter on Windows—or Control+Option+Return on Mac—to add a line break without leaving the cell. Add another bullet and item on the new line. When the content is complete, turn on Home > Wrap Text so Excel displays the lines rather than letting the text run across neighboring empty cells or appear clipped.
Excel may not automatically adjust the row height to show every line in every situation. If part of the list is hidden, select the row and use Home > Format > AutoFit Row Height, or drag the row boundary to increase its height. You can also widen the column, though a wider column may make the sheet harder to read on screen or when printed.
For a tidy result, keep the list short, use consistent wording, and avoid mixing manually inserted line breaks with wrapped paragraphs unless you intend to. A multi-line cell is still one cell: copying, deleting, or filtering it acts on the whole list, not on an individual bullet.
Use a formula to add bullet characters
A formula can place a bullet before text stored in another cell, which is useful when the source text should remain unbulleted. With the item “Confirm the order” in A2, enter this in B2 to display the same text with a bullet:
=UNICHAR(8226)&" "&A2
With the item in A2, the result is “• Confirm the order”. UNICHAR(8226) returns the Unicode bullet character, and the ampersands join it, a space, and the cell value. Copy the formula down to apply it to other rows. The formula does not change A2; B2 displays a result based on it. UNICHAR is available in current Microsoft 365 Excel.
You can also combine several known cells into a single cell with line breaks. With “Confirm the order” in A2, “Send the receipt” in A3, and “File the invoice” in A4, enter this formula in B2:
=UNICHAR(8226)&" "&A2&CHAR(10)&UNICHAR(8226)&" "&A3&CHAR(10)&UNICHAR(8226)&" "&A4
The result is a three-line list with one bullet per line. Turn on Wrap Text for B2 to display the line breaks. This example is deliberately explicit: if you add or remove source items, you must adjust the formula. For lists that change frequently, keeping each item in its own row is usually easier to maintain than building one large formula.
Format bullets for readability
A bullet takes the formatting of the text around it, so you can select the character or the whole cell and change the font, size, color, or alignment. To emphasize a particular bullet, edit the cell, select just that line’s text, and apply formatting. If the bullet and text are in different formatting runs, Excel may preserve that formatting when you edit the cell, but copying or replacing the cell can change it.
Indentation can help a list stand out from nearby values. Use the Increase Indent or Decrease Indent controls on the Home tab, or add a small number of spaces after the bullet. Indent controls affect the cell’s alignment, not the structure of the list. Avoid using long strings of spaces to align bullets: proportional fonts and column resizing can make the spacing look uneven.
Before printing, check the page layout and print preview. A narrow column or a short row can cut off a multi-line list, and a line that fits on screen may wrap differently on paper. Adjust the column width, row height, margins, or scaling as appropriate. If the bullet is decorative rather than meaningful, also ensure the text itself makes sense when read without relying on the symbol.
Choose bullets or a more data-friendly layout
Bullets improve the appearance of notes, but they are not always the best way to store information. If each item needs its own status, owner, date, or category, use a separate row for each item and put those details in their own columns. Excel can then sort and filter the list, calculate totals, and summarize it with tools such as a PivotTable. Putting multiple tasks inside one cell makes those operations much less convenient.
For a simple checklist, a separate row per task is often a better starting point than a bulleted paragraph. You can keep a task description in one column and a completion value in another. A bullet character is a visual marker; it does not create an interactive checkbox, record completion, or carry special meaning for Excel’s calculations.
Use a bullet character when the goal is readable presentation. Use separate rows and columns when the goal is tracking or analysis. If you need both, maintain clean structured data in one area of the workbook and create a formatted summary elsewhere.
Common problems and how to fix them
- The Alt code does nothing: Confirm that you are editing the cell, hold Alt while typing, and use the numeric keypad. Try Alt+0149 rather than the number row. If your keyboard lacks a keypad, paste • or use the Symbol dialog.
- The bullet appears as a square or question mark: The selected font may not contain the character, or text may have been copied through an application that changed it. Try a common font such as Calibri or Arial, or insert the symbol again from Excel.
- The second bullet appears in another cell: You likely pressed Enter instead of the in-cell line-break shortcut. Edit the original cell and use Alt+Enter on Windows or Control+Option+Return on Mac.
- Only the first line is visible: Turn on Home > Wrap Text and increase or autofit the row height. Also check that the text is not being hidden by a fixed row height.
- The formula shows the formula text instead of a bullet: Check that the cell is not formatted as Text, and that the formula begins with an equals sign. If needed, change the format to General, edit the cell, and press Enter.
One common misconception is that inserting a bullet turns a cell into a list object. It does not: Excel stores the bullet and item as text. That distinction matters if you later want to search for items, count them, or rearrange them. For frequently updated lists, one item per row avoids many of the limits of formatted text.
Frequently Asked Questions
Is there a bullet button in Excel?
Excel for Microsoft 365 does not have Word’s dedicated bullet-list button for cell contents. Insert the bullet as a character with an Alt code, the Symbol dialog, copy and paste, or a formula.
How do I put multiple bullets in one Excel cell?
Edit the cell, type a bullet and the first item, then press Alt+Enter on Windows or Control+Option+Return on Mac. Repeat for each line and enable Wrap Text to show the list clearly.
Can I add a bullet to many rows at once?
Yes. Put the source text in one column and use a formula such as =UNICHAR(8226)&" "&A2 in the next column, then fill it down. The source text stays separate from the displayed bullet version.
Can I use bullets in Excel for the web?
Yes. You can paste a bullet character into a cell and add line breaks while editing, though desktop keyboard shortcuts and dialog options may differ. For a reliable starting point, copy • and paste it into the cell.
Will Excel treat each bullet as a separate item?
No. Several bullets in one cell remain one text value. If you need to sort, filter, count, or track individual items, store each item in its own row instead.
Related
- Attendance Excel Template: Free Options and Setup
- Attendance Log Excel Template: Build One That Works
- Attendance and Payroll Excel Template: Setup Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- AI Budget Spreadsheet: Build and Check a Budget in ExcelAn AI budget spreadsheet is a workbook where an AI assistant helps plan categories, organize spending, or explain…
- Excel Conditional Formatting for Drop-Down ListsTo color an Excel drop-down selection automatically, create the list with Data Validation, then add a conditional-formatting rule…
- Power Query to Compare Two Excel Sheets Step by StepTo compare two Excel sheets with Power Query in Microsoft 365 for Windows, turn each data range into…
- Excel File Password: What It Means and How to Set OneAn Excel file does not have a universal password: the person who protects it chooses one. In Excel…
- Excel Print Area Lines: How to View, Set, and Hide ThemYes. In Excel for Microsoft 365 on Windows, the clearest way to see your print area is to…
- Google Sheets Count If Not Blank: Formulas and FixesTo count cells that are not blank in Google Sheets, use =COUNTA(A2:A100), replacing the range with your own.…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.