As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Add Bullet Points in Excel

Bullet points are an effective way to organize and present information in Excel. Whether you're creating lists, highlighting key points, or making your data more readable, adding bullet points can enhance the visual appeal of your spreadsheet. Here's how you can add and customize bullet points in Excel.

Adding a Single Bullet Point:

  • Type an Asterisk and Space:
  • To add a single bullet point, type an asterisk (*) followed by a space, and then enter your text.
  • * Item 1
    * Item 2
    * Item 3

Adding Multiple Bullet Points:

  • Use Symbol Dialog Box:
  • Click the Insert tab.
  • Click Symbol to open the Symbol dialog box.
  • In the Symbol dialog box, select the Wingdings font.
  • Scroll down to find the desired bullet point symbol (e.g., Wingdings 2).
  • Click the symbol to insert it.
  • plaintextCopy code
  •  Item 1
     Item 2
     Item 3

Changing the Bullet Point Symbol:

  • Format Cells:
  • Select the cell containing the bullet point.
  • Press Ctrl+1 to open the Format Cells dialog box.
  • Go to the Bullet tab.
  • Choose a different bullet point symbol.

Adding Bullet Points to a Range of Cells:

  • Select the Cells:
  • Highlight the range of cells where you want to add bullet points.
  • Shortcut Key:
  • Press Ctrl+Shift+L to add bullet points to the selected range.

Removing Bullet Points:

  • Select the Cells:
  • Highlight the cells with bullet points.
  • Shortcut Key:
  • Press Ctrl+Shift+L to remove the bullet points.

Using these steps, you can easily add, customize, and remove bullet points in Excel to create well-organized and visually appealing spreadsheets.