How to: Create a bulleted list in Excel
Unlike Word, Excel doesn't have a similar option to insert a bulleted list.
However, you can easily create a similar list in Excel by using a so called "custom number format".
That might sound a bit difficult but it really isn't.
- Just select the list and right-click on any cell in your selection:
Then choose "Format Cells..."
- Now choose "Custom" in the number tab.
In the Type box, enter the symbol or character that you want, followed by a space and the at sign (@)
To insert the bullet points you can use Alt+0149 (type 0149 on the numeric keypad)
or copy it from here: • @
This is an example:
- Any text that you type in cells that are formatted with this new custom format will have the bullet applied to them:
Alternative, edit all cells at once
If you don't want to use the customer number formatting but really insert the bullet or any other character into the cells, then you can use the following tool to quickly do this on all cells at once:
ASAP Utilities » Fill » Insert before and/or after each cell in your selection...
Download example workbook
Example workbook: Example bulleted list.xls
More information and resources
http://support.microsoft.com/kb/323567
http://blogs.office.com/b/microsoft-excel/archive/2010/10/19/create-a-bulleted-list-in-a-cell.aspx
Filed under: General, How to on March 9th, 2012 by Bastien | 3 Comments »
Bullet lists in Excel?! Wow -I totally did not know you could do this, but of course it will be very handy. Thanks for a great tip!
Great tip indeed.
You can also add a bullet to your paragraph. I would store the bullet symbol and the paragraph on a different sheet, say one titled "ASAP" with the bullet in A1 and paragraph in B1, and then on your main sheet where you want the bullet and the paragraph:
=ASAP!A1&" "&B1
That would put a space between the bullet and the first word of the paragraph text. Remove one of the &'s and the " " if you don't want a space.
That's a very interesting use of the custom format option!