

This Formula concatenates a solid bulled character, one space, and the value of the referenced cell(A2). If you want to add the name of the fruit after the bullet, you can type this formula (=CHAR (149)&” “&A2).In B2, we will put formula (=CHAR(149)), adding a bullet to the column. We will convert the above list of fruits to the bulleted list in Column B using CHAR Formula.Let’s say we have a list of fruits in Column A of the excel sheet.
#Shortcut for bullet points in excel how to#
We will show you an example of how to use this function. It takes a character code and displays the character that corresponds to that code in the cell. It is useful when you want to add bullets to multiple cells at a time to use the CHAR function. For any List or Worksheet, you can use it in a similar way. So, this way, the bullets are added using the Symbol tab.
#Shortcut for bullet points in excel update#
This way, you can add a bullet in another column and update the name, or you can copy-paste by using (CTRL+C) for copying and (CTRL +V) for pasting the bullet in other columns till where you want to update the data.

We will show you this step by step and with an example. You can use Symbol Dial Box if you don’t have a number pad on your keyboard or forget Keyboard shortcuts.
