Note: Once you have the bullet in a cell, you can copy it like any other character. For example, if you are building a list in a cell, enter the bullet followed by the item name, press Alt + Enter to insert a line break, and then insert the bullet again (as shown below): If you want to insert more bullet points in the same cell, in the case of having a list in a single cell, repeat the same steps. If you do not have a numeric Keyboard (like my laptop), activate the NumLock first and then repeat the above steps (or try with ALT + FUNCTION + 7)
As soon as you leave the ALT key, a bullet would appear.ĪLT + 7 and ALT + 9 both inserts a different kind of bullet (see below):.Hold the ALT key, press 7 or 9, leave the ALT key.Either double click on the cell or press F2 – to get into edit mode.Select the cell in which you want to insert the bullet.If you have a numeric keypad on your keyboard: You can quickly insert bullet points in Excel using the following keyboard shortcuts. While all these methods are quite simple, you only need to know a couple to get your work done. In this tutorial, you’ll learn various ways to insert bullet points in Excel. Copy Pasting a list from MS Word or PowerPoint.
0 kommentar(er)
