How To Add Bullet Points In Microsoft Excel?

To add bullet points in Microsoft Excel, you can use the following methods:

1. Using the CHAR Function:
   • Select the cell where you want to add a bullet point.
   • Press Alt + Enter to start a new line within the cell.
   • Type =CHAR(149) to insert a bullet point (•).
   • Press Enter. Repeat this process for additional bullet points on new lines.

Example:

• =CHAR(149) Bullet Point 1
• =CHAR(149) Bullet Point 2
• =CHAR(149) Bullet Point 3

2. Using Keyboard Shortcuts:

   • Select the cell where you want to add a bullet point.
   • Use the following numeric keypad combinations:
     • For solid bullets: Alt + 7 or Alt + 0149
     • For empty bullets: Alt + 9
   • Drag the fill handle (a small square) to copy the bullet to adjacent cells.

3. Using Custom Formats:

   • Right-click on the cells you want to apply bullets to and click on Format Cells.
   • Under the Number tab, select Custom.
   • For solid bullets, use the format code ● @ or • @. For unfilled bullets, use ○ @ or • @.
   • Click OK.
   • You can also use Alt + 7 (solid) or Alt + 9 (unfilled) to apply the bullet format in a single cell.

4. Copying from Word:

   • Create a bulleted list in Microsoft Word.
   • Copy and paste the bulleted list into Excel. By default, each bullet will be in its own cell.

Remember, Excel doesn't have a dedicated bulleted list feature like Microsoft Word, so these methods provide an alternative approach. You can adjust the formatting of the bullets and text using Excel formatting options. The Alt + Enter method is useful when you have a multi-line bullet point list within a single cell, while the CHAR function is efficient for adding bullets to multiple cells together.