Bullet points can make an Excel spreadsheet much easier to read, especially when you’re creating lists, instructions, notes, tasks, or summaries.

Unlike Microsoft Word, Excel does not have a simple Bullets button on the Home tab. However, there are several ways to insert bullet points into an Excel cell.

In this guide, you’ll learn how to insert bullet points in Excel using keyboard shortcuts, symbols, formulas, and multiple lines within a single cell.

How to Insert a Bullet Point in Excel

The easiest way to add a bullet point is to copy and paste the bullet symbol directly into a cell.

You can copy this one:

•

Then:

Select the Excel cell where you want the bullet.
Paste the bullet symbol.
Type your text after the bullet.

For example:

• Complete the assignment

This method works on both Windows and Mac and is useful when you only need to add a few bullet points.

1. Insert a Bullet Point Using Alt + 7

If you’re using Excel on a Windows computer with a numeric keypad, you can insert a bullet using a keyboard shortcut.

Steps:

Select the cell.
Press F2 or double-click the cell to edit it.
Place your cursor where you want the bullet.
Hold down Alt.
Type 7 using the numeric keypad.
Release Alt.

The bullet • should appear in the cell.

You can then type your text.

Example:

• Submit the application

Important

The Alt + 7 shortcut generally requires a numeric keypad. If you’re using a laptop without one, use the copy-and-paste method or another method below.

2. Insert a Bullet Using the Symbol Menu

Excel also allows you to insert special characters through its Symbol menu.

On Windows:

Open your Excel worksheet.
Select the cell where you want the bullet.
Go to Insert.
Select Symbol.
Find the bullet symbol.
Click Insert.
Close the Symbol window.
Type your text.

You can use this method if you want to choose from different bullet styles rather than using the standard round bullet.

3. Copy and Paste a Bullet Point

If you don’t want to use keyboard shortcuts, copying a bullet is one of the simplest options.

Copy:

•

Then paste it into your Excel cell and add your text.

For example:

• Mathematics

You can also use other symbols, such as:

• Round bullet
○ Open circle
▪ Square
– Dash

This method is particularly useful when you’re working with a small number of cells.

4. Add Multiple Bullet Points in One Excel Cell

You can put an entire bullet list inside one Excel cell.

For example:

• Mathematics
• English
• Biology

How to do it:

Double-click the cell.
Insert your first bullet and type your text.
Press Alt + Enter to start a new line within the same cell.
Insert another bullet.
Type the next item.
Repeat as necessary.

For example:

• Mathematics
• English
• Biology

Turn on Wrap Text

If the text doesn’t display correctly, select the cell and go to:

Home → Wrap Text

This allows Excel to display multiple lines inside the same cell.

5. Use a Formula to Add Bullet Points

If you already have a list of information in Excel, you can use a formula to automatically add bullets.

Suppose A1 contains:

Mathematics

In another cell, enter:

="• "&A1

The result will be:

• Mathematics

You can then drag the formula down to apply it to other rows.

For example:

Subject	Bulleted list
Mathematics	• Mathematics
English	• English
Biology	• Biology

This is particularly useful when you have a large list and don’t want to insert each bullet manually.

6. Use CHAR to Create a Bullet Point

You can also use Excel’s CHAR function to create a bullet.

For example:

=CHAR(149)&" "&A1

If A1 contains:

Complete registration

the result can appear as:

• Complete registration

This approach can be useful when you’re building a spreadsheet that automatically generates formatted lists.

However, the character produced by CHAR can vary depending on the character set or Excel environment. If it doesn’t produce the expected bullet, use the actual • character in the formula instead:

="• "&A1

7. Create Multiple Bullet Points With a Formula

You can also combine several cells into one cell and place a bullet before each item.

Suppose you have:

A1: Mathematics
A2: English
A3: Biology

You can use:

="• "&A1&CHAR(10)&"• "&A2&CHAR(10)&"• "&A3

The result will be:

• Mathematics
• English
• Biology

Make sure Wrap Text is turned on for the cell.

This method is useful when you want Excel to automatically create a formatted list from information stored in separate cells.

How to Make Bullet Points Look Better in Excel

Simply adding a bullet isn’t always enough. You can make your list easier to read by adjusting the formatting.

Use Wrap Text

Select the cell and choose:

Home → Wrap Text

This is especially important when you have multiple bullet points in one cell.

Adjust the Row Height

If your bullet list contains several lines, Excel may not automatically give you enough space.

You can adjust the row height manually or use:

Home → Format → AutoFit Row Height

Use Consistent Formatting

If you are creating several bullet lists, use the same:

Font
Font size
Bullet style
Line spacing
Alignment

Consistency makes your spreadsheet look more professional.

How to Indent Bullet Points in Excel

Excel doesn’t have exactly the same bullet-list formatting tools as Word, but you can create the appearance of an indented list.

Select the cell and use:

Home → Increase Indent

You can also add spaces after the bullet.

For example:

•    Mathematics
•    English
•    Biology

Avoid using excessive spaces because they can make your formatting inconsistent when the column width changes.

How to Add a Bullet Point Before Existing Text

If you already have text in a column, you don’t have to retype everything.

Suppose A1 contains:

Apply before Friday

Use:

="• "&A1

Excel will produce:

• Apply before Friday

You can drag the formula down for the entire list.

If you want to replace the original text with the bulleted version, copy the formula results and use Paste Special → Values.

How to Add Bullet Points on a Mac

Mac users can also insert bullet characters into Excel.

One simple option is to copy and paste:

•

You can also use the Mac’s character viewer:

Select the cell.
Place the cursor where you want the bullet.
Open the Emoji & Symbols viewer.
Search for bullet.
Select the bullet character.

The exact keyboard shortcut for opening the character viewer can vary depending on your macOS settings and keyboard.

Why Use Bullet Points in Excel?

Bullet points can be useful when your spreadsheet contains information that would otherwise be difficult to scan.

For example, you could use them for:

Task lists

Submit application
Pay registration fee
Upload documents

Meeting notes

Discuss budget
Review deadlines
Assign responsibilities

Product descriptions

Lightweight
Waterproof
Portable

Student information

Mathematics
English
Biology

Bullet points help break large blocks of information into smaller, easier-to-read pieces.

Bullet Points vs. Separate Rows in Excel

Sometimes putting several bullet points into one cell is not the best solution.

If you need to sort, filter, calculate, or analyze the information, it is usually better to put each item in its own row.

For example, instead of:

Tasks
• Write report• Send email• Attend meeting

You could use:

Tasks
Write report
Send email
Attend meeting

Use bullet points when your goal is presentation and readability. Use separate rows when your goal is data management and analysis.

Frequently Asked Questions

How do I insert a bullet point in Excel?

You can copy and paste the • symbol, use Alt + 7 on a Windows keyboard with a numeric keypad, or insert a bullet through Insert → Symbol.

How do I put multiple bullet points in one Excel cell?

Type the first bullet and text, press Alt + Enter to create a new line, and then add the next bullet. Turn on Wrap Text if necessary.

What is the shortcut for a bullet point in Excel?

On many Windows keyboards with a numeric keypad, Alt + 7 inserts a bullet point.

Can I automatically add bullets to a list in Excel?

Yes. If your text is in A1, you can use:

="• "&A1

Then drag the formula down to apply it to additional rows.

Can I use bullet points in Excel on a Mac?

Yes. You can copy and paste the • symbol or use the Mac character viewer to find and insert a bullet.

Why aren’t my bullet points displaying correctly?

Check that the cell is formatted correctly and that Wrap Text is enabled when you’re using multiple lines. If you’re using an Alt code, make sure you’re using the numeric keypad where required.

Final Thoughts

Learning how to insert bullet points in Excel is useful when you want to make notes, task lists, descriptions, and other information easier to read.

For a quick list, simply copy and paste •. If you’re working with many rows, a formula such as ="• "&A1 can save time. And if you want several bullets inside one cell, use Alt + Enter to create separate lines and turn on Wrap Text.

The best method depends on what you’re trying to accomplish: use bullets for presentation, but keep separate rows when you need to sort, filter, or analyze your data.