ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   bullet points (https://www.excelbanter.com/excel-worksheet-functions/21715-bullet-points.html)

Shooter

bullet points
 
Could you please advise how to insert a bullet point (solid black dot) in
excel. Thank you.
--
Shooter

Ron Coderre

Depends on the font you want to use. Here's an example using Arial:

1)Set the font for a cell to Arial.
2)InsertSymbol
3)Font: Arial
4)In the 8th row of the grid, on the far left, is a bullet point.
5)Select it.
Note that the Character Code at the bottom of the screen is 149.
6)Cancel

Now, select the formula bar then:
Hold down the [Alt] key and type 0149
Release the [Alt] key and the bullet point will appear.
Note: the zero is significant in the 0149.

I hope that helps.

Regards,
Ron


"Shooter" wrote:

Could you please advise how to insert a bullet point (solid black dot) in
excel. Thank you.
--
Shooter



All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com