I've been using bullet points inside Excel A LOT as of late and I thought I would share the many different ways you can insert those nifty little bullets. I have mainly been inserting bullet points inside text box objects within my "Instructions" pages (tabs), but I will list out some ways you can insert bullet points directly into your spreadsheet as well.
Within A Cell
1. Keyboard Shortcut: Alt + 7 (number must be from your number pad)
2. Keyboard Shortcut: Alt + 0149
3. Copy and paste the below bullet point into your spreadsheet:
5. Use a Cell Format rule (copy the following into the Type field: "• @" ). You can add spaces before the bullet point in the format rule to add an indentation.
Inside A Text Box Object
Within a text box, you have a more straight-forward option to add bullet points. Here are the steps to get them inserted.
- Right-click in textbox
- Select Bullets
- Take your pick of any of the presets or customize your bullet points further by clicking Bullets and Numbering
Now You Can Stay Organized!
Bullet points are a great way to make your lists and steps easier to read. My favorite out of the bunch is definitely the Alt+7 keyboard shortcut and it will definitely impress your co-workers when you magically make bullet points appear on the fly.
If there are any other good ways to insert bullet points, feel free to let me know in the comments section below. I would love to continue to add to this list and make it more comprehensive.