I also hope you found this Itechguide helpful. In this guide, I discussed 4 ways you can insert bullet points in Excel. To include all the words in column C, drag the formula from B3 down.įor a list of CHAR numbers and their symbols, click Windows-1252 (for Windows). If you have a list of words in excel and wish to create a bullet list with those words, use the formula: =CHAR(149)&' '&C3 To create a solid bullet list, use this formula: =CHAR(149) Each number will insert a special symbol in Excel. Syntax of the CHAR function CHAR (number) The CHAR function is used to insert bullet points and other special characters. In the last section of this guide I will discuss how to insert bullet points using formula. Method 4: Insert Bullet Points in Excel Using Excel Formula You can repeat the above steps to copy a bullet point from a web page. To close the Symbols options, click Close (See the second image below). Then click on the bullet point you want to use and click Insert. When the Symbol options opens, from the Subset drop-down, select General Punctuation.Next, click the drop-down below Symbols menu and select Symbol.Open Excel and click the cell you wish to insert bullet points.To add bullet point using this method, follow the steps below: Method 1: Insert Bullet Points in Excel From the Symbols Menu By Copying Bullet Points from Word or a Web page.Add Bullet Points in Excel Using Keyboard shortcuts.Insert Bullet Points in Excel from the Symbol Menu.This guide demonstrates 4 easy ways you can insert bullet points in excel.īelow are the methods for Inserting bullet points in excel discussed in this guide: Inserting bullet points in excel is not as straightforward as adding bullet points in Word. Method 4: Insert Bullet Points in Excel Using Excel Formula.Method 3: Insert Bullet Points in Excel By Copying Bullet Points from Word or a Web page.How to Use On-screen Keyboard for Excel Shortcuts.Method 2: Insert Bullet Points in Excel Using Keyboard shortcuts.Method 1: Insert Bullet Points in Excel From the Symbols Menu.

Mac key command for bullets