Unlike Microsoft Word, Excel lacks a dedicated bullet button on the ribbon. Need bulleted lists in your spreadsheets? As an Excel expert with years of experience optimizing workflows, I've relied on these seven practical methods to add them efficiently.
Let's dive in.
Keyboard shortcuts are a time-saver in Excel. Check out our guide on 35 Everyday Microsoft Excel Keyboard Shortcuts for Windows and Mac to boost your productivity further.
Select a cell and press Alt + 7 or Alt + 0149 (using the numpad) for a solid bullet, or Alt + 9 for a hollow one. Laptops without a numpad? Enable Num Lock via Fn + Num Lock or Shift + Num Lock to use embedded keys.
No numpad available? The next methods have you covered.
On the Insert tab, click Symbols > Symbol (or directly if visible). Calibri is default, but choose any font.
Pick your bullet, click Insert, then Close. For quick access, set from to Unicode (hex) and enter codes like those shown below.
Add spaces after the bullet, copy to other cells, or use the fill handle for speed.
For long lists, custom formats streamline the process. First, insert and copy a bullet to an unused cell.
Select target cells (empty or with text), right-click > Format Cells (Ctrl + 1).
On the Number tab, choose Custom. In Type, paste bullet + space(s) + @. Click OK.
Reuse by selecting cells, Ctrl + 1 > Custom, and picking your format.
Double-click a cell. Insert a bullet (shortcut or Symbol), add spaces and text. Press Alt + Enter for new lines. Repeat, ending with Enter.
Format lists in Word first—see our guide on How to Format and Manage Lists in Microsoft Word. Copy and paste into Excel.
For one cell: Double-click and Ctrl + V; adjust spacing. For separate cells: Paste into starting cell and tweak as needed.
Excel's text functions shine here—explore more in our Tips for Working with Text and Text Functions in Excel.
For Windows, select cells, type in formula bar: =CHAR(149), then Ctrl + Enter for solid bullets.
Place text in adjacent column.
For prefixed lists: In a cell, use =CHAR(149)&" "&C3 (adjust reference). Autofill down.
Convert to values: Copy (Ctrl + C), Home > Paste dropdown > Paste Values.
Windows symbol fonts offer variety. Select cells, set font to Wingdings on Home tab.
Type l (lowercase L) for large solid bullet, w for small, or others as shown. Adjust column width.
Combine with CHAR: Enter formula first, then switch font. See codes below.
That's it! For more list options, check 3 Types of Excel Lists to Ease Data Entry.
