Unfortunately, there is no just-as-easy way to do the same thing using the keyboard. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.Word includes a handy-dandy tool (available on the Home tab of the ribbon, in the Paragraph group) that allows you to add bullets to a paragraph in a jiffy and just as easily remove them. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. Output: Insert a bullet before a word Instant Connection to an Excel Expert As a result, a solid bullet is inserted before the word Define.įigure 9. We press F2 and place the cursor before the word “Define”, then press Alt + 7 on the numeric keypad. Then we place the cursor on the part of the text string where we want to add a bullet point, then insert the bullet point. In order to add a bullet point to a cell that already contains a text, we enter the Edit mode by pressing F2 or double-clicking the cell.
#Keyboard shortcut bullet point code
The character code for the solid bullet is 2022, as shown below.īelow table shows a list of character codes for some common bullet points. It is very helpful to remember the code for our favorite bullets and just type the code into the Character code box at the lower portion of the Symbols dialog box. Sometimes it is hard to find the bullet point among all the available symbols. Output: Insert bullet point in Symbol menu
The bullet will be instantly inserted into the cell.įigure 6. Click on the solid bullet, whose Unicode name is Bullet as shown below.In the Symbols tab, we look for the bullet point that we want to add.įor example, we want to add the solid bullet.Select the cell where we want to add a bullet point.Fortunately, Excel allows us to insert bullets through menu options. It is highly probable that we will forget the shortcut for bullets discussed above. Drag and fill to copy bullets Insert symbol method There is no need to insert the bullet point one by one per cell.įigure 4. In order to copy a bullet point, just drag the fill handle to the selected cells. Output: Shortcut for bullet pointĬonsequently, the solid bullet, being probably the most widely used bullet point, has another keyboard shortcut: Alt + 0149. The solid bullet will be instantly inserted into the selected cell.įigure 3. Select a cell and press Alt + 7 simultaneously. Bullet shortcuts in numeric keypad Example:
We can refer to below list of bullet shortcuts that can be easily applied using the numeric keypad.įigure 2. However, Excel allows us to insert bullet points through keyboard shortcuts. Unlike MS Word where bullet points can be directly inserted and are readily available on the ribbon, Microsoft Excel does not have a built-in feature for bullet points. There are two easy methods that we can apply to insert bullet points:
#Keyboard shortcut bullet point how to
Final result: Insert bullet points How to insert bullet points ? This article assists all levels of Excel users on how to insert bullet points.įigure 1.
Although Excel is used mostly for numbers and formulas, it can also be used for lists that require bullet points for better presentation and easier understanding.