How to add bullet points in excel

Answer

To add bullet points in Excel, you can use keyboard shortcuts, the Symbol dialog box, custom formatting, or formulas depending on your needs.

Method 1: Using Keyboard Shortcuts

Windows: Press Alt + 7 on the numeric keypad to insert a standard bullet point (•). Press Alt + 9 for a hollow bullet (○).

Mac: Press Option + 8 to insert a bullet point (•).

Method 2: Using the Symbol Dialog Box

1. Click the cell where you want the bullet point
2. Navigate to Insert tab on the ribbon
3. Click Symbol in the Symbols group
4. Select the bullet character (•) from the list
5. Click Insert
6. Click Close

Mac: The Symbol option is located under Insert > Advanced Symbol > Symbols tab.

Method 3: Adding Bullets Within a Cell

1. Double-click the cell to enter edit mode
2. Type your first item of text
3. Press Alt + Enter (Windows) or Control + Option + Return (Mac) to create a new line within the same cell
4. Insert a bullet point using Alt + 7 (Windows) or Option + 8 (Mac)
5. Type your next item
6. Repeat steps 3-5 for additional items

Method 4: Using Custom Number Format

1. Select the cells where you want bullet points
2. Right-click and choose Format Cells
3. Click the Number tab
4. Select Custom from the Category list
5. Type the following in the Type field: • @
6. Click OK

This method adds a bullet point before any text you enter in the selected cells.

Method 5: Using a Formula

Enter this formula in a cell to combine a bullet point with text from another cell:

=CHAR(149)&" "&A1

Replace A1 with the cell reference containing your text. The CHAR(149) function generates a bullet point character.

Method 6: Copy and Paste

1. Copy a bullet point from another source (• or this one)
2. Paste it into your Excel cell
3. Type your text after the bullet

Creating Bulleted Lists Across Multiple Cells

1. Enter a bullet point in the first cell using any method above
2. Type your text after the bullet
3. Press Enter to move to the next cell
4. Repeat the process for each list item

Using AutoCorrect for Automatic Bullets

1. Go to File > Options (Windows) or Excel > Preferences (Mac)
2. Click Proofing
3. Click AutoCorrect Options
4. In the Replace field, type a shortcut like "blt"
5. In the With field, paste a bullet point (•)
6. Click Add
7. Click OK

Now typing "blt" followed by a space will automatically insert a bullet point.

Applying Bullets to Multiple Lines in One Cell

1. Click the cell
2. Press Alt + 7 (Windows) or Option + 8 (Mac) to add a bullet
3. Type your first point
4. Press Alt + Enter (Windows) or Control + Option + Return (Mac)
5. Add another bullet and type the next point
6. Repeat as needed

What Are the Different Bullet Styles Available?

Excel provides access to various bullet styles through the Symbol dialog box. Common bullet characters include:

• Standard bullet (•) - Character code 149
• Hollow bullet (○) - Character code 9
• Square bullet (■)
• Checkmark (✓)
• Arrow (→)
• Diamond (◆)

Access these through Insert > Symbol > Symbols tab, then browse the available characters in different fonts like Wingdings, Webdings, or Symbol.

How to Remove Bullet Points

1. Select the cells containing bullets
2. Press Ctrl + H (Windows) or Command + H (Mac) to open Find and Replace
3. In the Find what field, enter the bullet character (copy and paste •)
4. Leave the Replace with field empty
5. Click Replace All

Alternative method: Clear custom formatting by selecting the cells, right-clicking, choosing Format Cells, selecting General under Number tab, and clicking OK.

Yes · 0 No · 0 Add Comment · 0

Add ·

Report