This article looks at the multiple ways you’re able to add bullet points in Excel.
Then, jot down the item you’d like to follow the bullet.
Different keyboard shortcuts will insert different style bullets.
The bullet point will only appear after you release the keys.
If you prefer to include multiple bullets in a single cell, pressAlt+Enterafter each Alt+7 bullet entry.
This will insert a line break into the cell.
Continue this process until you’ve entered the number of bullets you need in the cell.
PressEnter(without pressing theAltkey) to finish editing the cell.
The row height will automatically adjust to accommodate the number of bullet points you’ve entered into the cell.
pick the cell where you want to insert a bullet point, then selectInsert>Symbol.
Scroll down and go for the bullet point symbol.
You don’t necessarily have to use the standard bullet symbol.
As you scroll through the list of symbols you may notice many others that make good bullets as well.
Finally, place the cursor between each bullet in the cell and pressAlt+Enterto add a line break between bullets.
TheASCIIcharacter code for a solid bullet point is 149.
PressEnterand the formula will turn into a bullet point.
When you pressEnter, you’ll see the bullet points on each line.
You may need to adjust the height of the row to see them all.
You’ll see a drop-down list of all of the available shapes you have to choose from.
pick the shape you’d like to use as your bullet, and it will appear on the spreadsheet.
pick the shape, then resize it appropriately to fit inside each row.
Drag the icon into the first row.
Then, select, copy, and paste copies of it into the rows below it.
Combine each cell that contains a bullet icon with the second cell that contains the text.
Using Bullets in Text Boxes
Excel provides bullet-formatting functionality buried within specific tools such as Text Box.
Text box bullet lists work as they do in a Word document.
SelectInsert>SmartArtto open theChoose a SmartArt Graphicdialog box.
SelectListfrom the left menu.
Select any one of these and selectOKto finish.
This will insert the graphic into your spreadsheet in design mode.
Enter the text for your list into each header and line item.
When you’re finished, select anywhere in the sheet to finish.
you’re free to also select and move the graphic to place it wherever you like.
When creating your list, first type1in the first row where you want to start the numbered list.
Then, type2in the row just below it.
The mouse icon will change to a small crosshair.
When you release the mouse button, all cells will automatically fill with the numbered list.
Now you could complete your list by filling in the cells to the right of your numbered list.
Using the example above, delete all of the numbers in the left column.
Select inside the first cell, then selectInsert>Symbols>Symbol.
