![Shortcut for bullet points in excel](https://loka.nahovitsyn.com/18.jpg)
![shortcut for bullet points in excel shortcut for bullet points in excel](https://www.excel-easy.com/examples/images/bullet-points/insert-bullet-point.png)
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.
![shortcut for bullet points in excel shortcut for bullet points in excel](https://cdn-amgoo.nitrocdn.com/qJvQlgGQEOwNXyhUqNwiAWOQgCDvoMdJ/assets/static/optimized/rev-c714b43/wp-content/uploads/2016/04/Use-Text-Box-To-Insert-Bullet-point-In-Excel.png)
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.
![Shortcut for bullet points in excel](https://loka.nahovitsyn.com/18.jpg)