Tutorial :How should I format my cell to have a bulleted list of items



Question:

How should I format my cell to have a bulleted list of items. Currently I create the bulleted text in word and paste it in the excel cell, but when I try to add a new item using the enter button it takes me to the next cell but doesn't add a new bullet item. How should I do this?


Solution:1

Mike Alexander had a post about this last year. His method uses custom "number" formatting on the cells.

  • Paste in your bullet (he chooses one by using Insert->Symbol)
  • copy the symbol to the clipboard
  • format the range/column needing the bullets and use bullet + Space + @ as the formatter.

Note that this only works on items in individual cells (it will only put a single bullet at the beginning of the cell.) If you need to add bullets into a single cell, Use Alt+Enter to add a new line character, and copy 'n' paste your bullet character.


Solution:2

One way would be to dedicate a column for the bullets, say column A for the bullet and column B for the data, and make the bullet appear conditionally on available data in B. e.g. for cell A1 I would use something like:

=IF(ISBLANK(B1),"","●")  

You can then make column A narrow so it will fit in width to the bullet. Also you can copy this formula to a far off row so that any time you write in column B, you'll already have this formula ready in the cell next to it in column A.

Also, if you want to change the bullet's style - go to any empty cell, click on Inset\Symbol, choose your bullet, then you can copy paste it into the equation above.


Solution:3

Shortcuts:

To quickly add a bullet symbol to a cell, double click in the cell where you want to add your bullet symbol, and then press ALT+7 or ALT+9 using the numeric keypad on your keyboard.

Ref: Insert bullets in a worksheet


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »