Adding a bulleted list to an Excel worksheet isn't easy, but it is possible. Unlike Microsoft Word – or even PowerPoint – there's no way to do it automatically. Instead, we'll try a few tricks, which you can see below.
Insert Bullet Points from the Symbols Menu
First, select any empty cell in the Excel workbook.
Make sure you have the “Insert” tab open and click on “Symbol” under the “Symbols” icon.
In the dialog box, type 2022 in the “Character code” box.
Click "Insert" and then "Close".
If you want to add more bullets to the lines below, press ALT + Enter on the keyboard and repeat the previous steps.
Insert Bullet Points in a Text Box
If you want to skip the functionality of a worksheet and just place a text box on top, it's a simpler process than the above, although you will lose some of the functionality of the worksheet as it will function more like a Word.
Go to the “Insert” tab and click on “Text Box” under the “Text” menu.
Click anywhere on the worksheet to add the text box. To resize, grab any of the corners, drag it to the desired size, and then release the mouse button.
Type the list items into the text box.
Highlight the items you want to add bullets to. To add the bullets, right-click the list, then click “Bullets” from the list of options.
Choose the style of your bullets.
Insert Bullet Points using keyboard shortcuts
Click the cell where you want to start the bulleted list.
For a standard bullet, press Alt + 7 on your keyboard. You can also use Alt + 9 if you prefer a circular bullet.
To add more bullets, simply click the square in the lower right corner, hold down the mouse button, and drag the mouse down (or left or right) to fill in additional cells.
Alternatively, if you want to add your bullets to a non-adjacent cell, simply highlight the bullets and press Ctrl + C to copy, then Ctrl + P to paste it into a new area.
Excel, like most Microsoft Office products, has multiple ways to do the same thing. Just choose the way that works best for you and what you're trying to accomplish.
Source: howtogeek.com
