Add Bullet Points in Excel With Shortcut Keys
One of the easiest ways to add bullet points in Excel is using keyboard shortcut keys.
Add Bullet Points in Excel Using Symbols
If you prefer using your mouse rather than the keyboard to add bullet points in Excel, then Symbols is a great way to go. Using symbols to add bullet points in Excel is ideal if you don’t want to have to remember which shortcuts let you insert specific bullet styles.
Insert a Bullet in Excel Using a Formula
One way to insert bullets in Excel without having to use the menu or remember any keyboard shortcuts is to use Excel’s CHAR function. The CHAR function will display any character you want, if you provide it with the correct numeric character code. The ASCII character code for a solid bullet point is 149.
Add Bullets to Excel With Shapes
Inserting shapes as bullet points is a creative way to use images of different shapes or colors as bullet points.
Using Bullets in Text Boxes
Excel provides bullet-formatting functionality buried within specific tools such as Text Box. Text box bullet lists work as they do in a Word document.
Adding SmartArt Bullet Lists in Excel
Hidden deep inside Excel’s SmartArt Graphic list are several graphical bullet lists that you can insert into any spreadsheet.
Adding Numbered Lists in Excel
Adding a numbered list in Excel is very easy using the fill feature.
How to Make Numbered Symbol Lists in Excel
You can also use symbols to create numbered lists in Excel. This method creates much more stylistic numbered lists, but it can be a bit more tedious than the autofill option.
