{"id":34139,"date":"2024-01-23T04:48:26","date_gmt":"2024-01-23T03:48:26","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=34139"},"modified":"2024-03-22T20:28:36","modified_gmt":"2024-03-22T19:28:36","slug":"add-bullet-points-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/","title":{"rendered":"How to Add Bullet Points in Excel &#8211; Top 7 Ways"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-bullet-points-in-Excel-20.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-34281 size-large\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-bullet-points-in-Excel-20-1024x576.png\" alt=\"Add bullet points in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-bullet-points-in-Excel-20-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-bullet-points-in-Excel-20-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-bullet-points-in-Excel-20-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-bullet-points-in-Excel-20.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Microsoft Excel<\/strong><\/a> is a powerful tool widely used for data analysis, calculations, and organizing information. But, it is also a versatile tool for presenting and organizing<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/text\/\" target=\"_blank\" rel=\"noopener\"><strong> textual information<\/strong><\/a>.<\/p>\n<p>You might encounter a situation where you must <strong>add a list, make key points, highlight milestones, or provide a step-by-step guide<\/strong>. In all such situations, you must <strong>add bullet points<\/strong> in Excel to <strong>enhance the readability and organization of information<\/strong>.<\/p>\n<p>There are no in-built features in Microsoft Excel to add bullet points. But in this comprehensive guide, we&#8217;ll <strong>explore and understand 7 different methods<\/strong> on how to add bullet points in Excel &#8211;<\/p>\n<p>Let us look at each of these points in detail.<\/p>\n<h4>Download the Excel Workbook below to follow along and understand How to Add Bullet Points in Excel \u2013 <a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Add-Bullet-Points-in-Excel.xlsx<\/span><\/a><\/h4>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/#Method_1_%E2%80%93_Keyboard_Shortcut\" title=\"Method 1 &#8211; Keyboard Shortcut\">Method 1 &#8211; Keyboard Shortcut<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/#Method_2_%E2%80%93_Insert_Symbol\" title=\"Method 2 &#8211; Insert Symbol\">Method 2 &#8211; Insert Symbol<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/#Method_3_%E2%80%93_CHAR_Function\" title=\"Method 3 &#8211; CHAR Function\">Method 3 &#8211; CHAR Function<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/#Method_4_%E2%80%93_Special_Font\" title=\"Method 4 &#8211; Special Font\">Method 4 &#8211; Special Font<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/#Method_5_%E2%80%93_Custom_Format\" title=\"Method 5 &#8211; Custom Format\">Method 5 &#8211; Custom Format<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/#Method_6_%E2%80%93_Text_Box\" title=\"Method 6 &#8211; Text Box\">Method 6 &#8211; Text Box<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/#Method_7_%E2%80%93_SmartArt\" title=\"Method 7 &#8211; SmartArt\">Method 7 &#8211; SmartArt<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/add-bullet-points-in-excel\/#Conclusion\" title=\"Conclusion\">Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_%E2%80%93_Keyboard_Shortcut\"><\/span><strong><span id=\"1\" style=\"color: #ff0000;\">Method 1 &#8211; Keyboard Shortcut<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The quickest way to add bullet points in Excel is to use <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/005-my-top-10-excel-keyboard-shortcuts-excel-podcast\/\" target=\"_blank\" rel=\"noopener\"><strong>keyboard shortcuts<\/strong><\/a>. Follow these steps &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Click on the cell where you want to insert the bullet point.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34196 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png\" alt=\"Add bullet points in Excel\" width=\"672\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1-300x146.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Press <strong>Alt + 7<\/strong> to insert a <strong>solid<\/strong> bullet or press <strong>Alt + 9<\/strong> to insert an <strong>empty<\/strong> bullet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34197 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-2.png\" alt=\"Add bullet points in Excel\" width=\"581\" height=\"265\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-2.png 581w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-2-300x137.png 300w\" sizes=\"(max-width: 581px) 100vw, 581px\" \/><\/a><\/p>\n<p>You need to keep in mind the following points &#8211;<\/p>\n<ul>\n<li>To insert bullets in other cells, press <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-shift-arrows-movehighlight-cells\/\" target=\"_blank\" rel=\"noopener\">Ctrl +<\/a> C to copy it and press Ctrl + V to paste<\/strong> the copied bullet in other cells.<\/li>\n<li>To insert <strong>multiple bullets<\/strong> in the same cell &#8211;\n<ul>\n<li>Press Alt + 7 to insert a bullet.<\/li>\n<li>Press Alt + Enter to insert a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/break-line-on-worksheet\/\" target=\"_blank\" rel=\"noopener\"><strong>line break<\/strong><\/a>.<\/li>\n<li>Press Alt + 7 to insert another bullet; and so on.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34198 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-3.png\" alt=\"Add bullet points in Excel\" width=\"668\" height=\"301\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-3.png 668w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-3-300x135.png 300w\" sizes=\"(max-width: 668px) 100vw, 668px\" \/><\/a><\/p>\n<p>This straightforward method is efficient for quickly adding bullet points without delving into complex methods.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_%E2%80%93_Insert_Symbol\"><\/span><strong><span id=\"2\" style=\"color: #ff0000;\">Method 2 &#8211; Insert Symbol<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel provides an Insert Symbol dialog box that allows you to insert various symbols, including bullet points. Here&#8217;s how &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> <strong>Select the cell<\/strong> where you want to insert a bullet point.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34196 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png\" alt=\"Add bullet points in Excel\" width=\"672\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1-300x146.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Go to <strong>Insert<\/strong> &gt; <strong>Symbol<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34199 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-4.png\" alt=\"Add bullet points in Excel\" width=\"1917\" height=\"167\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-4.png 1917w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-4-300x26.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-4-1024x89.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-4-768x67.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-4-1536x134.png 1536w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Select the <strong>Wingding<\/strong> font and then click on the <strong>small black bullet icon<\/strong>. Press Insert.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34200 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-5.png\" alt=\"Add bullet points in Excel\" width=\"656\" height=\"474\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-5.png 656w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-5-300x217.png 300w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span>Close<\/strong> the\u00a0Symbol\u00a0dialog box<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-20.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34211 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-20.png\" alt=\"Add bullet points in Excel\" width=\"661\" height=\"475\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-20.png 661w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-20-300x216.png 300w\" sizes=\"(max-width: 661px) 100vw, 661px\" \/><\/a><\/p>\n<p>The bullet point will appear in the cell.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34202 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-7.png\" alt=\"Add bullet points in Excel\" width=\"585\" height=\"187\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-7.png 585w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-7-300x96.png 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><\/p>\n<p>If you are <strong>unable to find the symbol<\/strong> in the list, you can <strong>type the character code &#8211; 159.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34201 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-6.png\" alt=\"Add bullet points in Excel\" width=\"660\" height=\"471\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-6.png 660w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-6-300x214.png 300w\" sizes=\"(max-width: 660px) 100vw, 660px\" \/><\/a><\/p>\n<p>This method provides flexibility in choosing different bullet point styles from various fonts.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_3_%E2%80%93_CHAR_Function\"><\/span><strong><span id=\"3\" style=\"color: #ff0000;\">Method 3 &#8211; CHAR Function<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/concatenate-with-a-line-break-excel\/#:~:text=CHAR%20function%20returns%20a%20character,can%20enter%20a%20line%20break.\" target=\"_blank\" rel=\"noopener\"><strong>CHAR<\/strong><\/a> function<strong> returns a character based on a specified number ranging from 1 to 255<\/strong>. For instance, if you input <strong>CHAR(149)<\/strong>, it will produce a <strong>bullet point<\/strong>; <strong>CHAR(10)<\/strong> will yield a<strong> <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/break-line-on-worksheet\/\" target=\"_blank\" rel=\"noopener\">line break<\/a><\/strong>, and <strong>CHAR(64)<\/strong> will result in <strong>@<\/strong>, and so forth.<\/p>\n<p>In this example, the milestones of a project are mentioned in column A and you want to add bullet points in front of each milestone. Follow these <strong>steps<\/strong> to understand how to insert bullet points in Excel using the CHAR function &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Enter the <strong>CHAR <\/strong>Function.<\/p>\n<p><strong>=CHAR<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34203 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-8.png\" alt=\"Add bullet points in Excel\" width=\"791\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-8.png 791w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-8-300x117.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-8-768x299.png 768w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Enter the number that will return a bullet point i.e. 149. The number 149 represents the ASCII code for a bullet point character.<\/p>\n<p><strong>=CHAR(149)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34204 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-9.png\" alt=\"Add bullet points in Excel\" width=\"782\" height=\"312\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-9.png 782w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-9-300x120.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-9-768x306.png 768w\" sizes=\"(max-width: 782px) 100vw, 782px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Enter the <strong>Ampersand (&amp;) sign\u00a0<\/strong>to combine this bullet point with the milestone mentioned in column A.<\/p>\n<p><strong>=CHAR(149)&amp;<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34205 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-10.png\" alt=\"Add bullet points in Excel\" width=\"793\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-10.png 793w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-10-300x117.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-10-768x298.png 768w\" sizes=\"(max-width: 793px) 100vw, 793px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> Select the cell containing the milestone i.e. A2.<\/p>\n<p><strong>=CHAR(149)&amp;A2<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34207 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-12.png\" alt=\"Add bullet points in Excel\" width=\"794\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-12.png 794w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-12-300x116.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-12-768x298.png 768w\" sizes=\"(max-width: 794px) 100vw, 794px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5:<\/span><\/strong> Select the range and <strong>press Ctrl + D to copy the formula down<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34208 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-13.png\" alt=\"Add bullet points in Excel\" width=\"709\" height=\"342\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-13.png 709w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-13-300x145.png 300w\" sizes=\"(max-width: 709px) 100vw, 709px\" \/><\/a><\/p>\n<p>Your bulleted list is now ready. You can also experiment with different ASCII codes for alternative bullet point styles.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_4_%E2%80%93_Special_Font\"><\/span><strong><span id=\"4\" style=\"color: #ff0000;\">Method 4 &#8211; Special Font<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Certain default fonts within Microsoft Excel come with built-in bullet symbols. Using those fonts, you can<strong> directly add bullet points in the cell<\/strong>. Here is how you can do it &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> <strong>Select the cell<\/strong> where you want to insert a bullet point.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34196 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png\" alt=\"Add bullet points in Excel\" width=\"672\" height=\"328\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1.png 672w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-1-300x146.png 300w\" sizes=\"(max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Go to the <strong>Home<\/strong> tab and select <strong>Wingdings<\/strong> font.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34210 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-15.png\" alt=\"Add bullet points in Excel\" width=\"753\" height=\"857\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-15.png 753w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-15-264x300.png 264w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Type <strong>l (small l)<\/strong> to insert a solid circle bullet.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-7.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34202 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-7.png\" alt=\"Add bullet points in Excel\" width=\"585\" height=\"187\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-7.png 585w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-7-300x96.png 300w\" sizes=\"(max-width: 585px) 100vw, 585px\" \/><\/a><\/p>\n<p>You can type <strong>o<\/strong> to get an <strong>empty square bullet<\/strong>, <strong>n for a solid square bullet<\/strong>, <strong>m for an empty circle bullet<\/strong>, etc.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_5_%E2%80%93_Custom_Format\"><\/span><strong><span id=\"5\" style=\"color: #ff0000;\">Method 5 &#8211; Custom Format<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you wish to include bullet points in every cell, you can modify the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/format-cells-special-numbers-excel\/\" target=\"_blank\" rel=\"noopener\">cell format<\/a> to automatically insert them. Follow the steps below &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> <strong>Select the cell range<\/strong> where you want to insert bullet points.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-21.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34212 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-21.png\" alt=\"Add bullet points in Excel\" width=\"667\" height=\"361\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-21.png 667w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-21-300x162.png 300w\" sizes=\"(max-width: 667px) 100vw, 667px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> Press <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/ctrl-1-format-cells\/\" target=\"_blank\" rel=\"noopener\">Ctrl + 1<\/a><\/strong> to open the <strong>Format Cells<\/strong> dialog box<strong>.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-22.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34213 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-22.png\" alt=\"Add bullet points in Excel\" width=\"669\" height=\"624\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-22.png 669w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-22-300x280.png 300w\" sizes=\"(max-width: 669px) 100vw, 669px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Go to the <strong>Number<\/strong> tab and under category, select <strong>Custom<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-23.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34214 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-23.png\" alt=\"Add bullet points in Excel\" width=\"674\" height=\"622\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-23.png 674w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-23-300x277.png 300w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>In the type box, enter &#8211; &#8220;\u25cf @&#8221;. Press Alt + 7, then type space, and then type @.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-24.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34215 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-24.png\" alt=\"Add bullet points in Excel\" width=\"671\" height=\"626\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-24.png 671w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-24-300x280.png 300w\" sizes=\"(max-width: 671px) 100vw, 671px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5: <\/span><\/strong>Click <strong>OK<\/strong>.<\/p>\n<p>Now, when you type any text in the selected range, a bullet point will be added automatically.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-25.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34216 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-25.png\" alt=\"Add bullet points in Excel\" width=\"582\" height=\"342\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-25.png 582w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-25-300x176.png 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/a><\/p>\n<p>You can press Alt + 9, then type space, and then type @ to insert empty bullet points.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_6_%E2%80%93_Text_Box\"><\/span><strong><span id=\"6\" style=\"color: #ff0000;\">Method 6 &#8211; Text Box<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want more control over the placement of your bullet points, you can use text boxes. Here&#8217;s how &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Go to<strong> Insert<\/strong> &gt;<strong> Text Box.<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-27.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34221 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-27.png\" alt=\"Add bullet points in Excel\" width=\"1917\" height=\"293\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-27.png 1917w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-27-300x46.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-27-1024x157.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-27-768x117.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-27-1536x235.png 1536w\" sizes=\"(max-width: 1917px) 100vw, 1917px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> <strong>Click where you want to place<\/strong> the text box and then <strong>drag<\/strong> to resize it.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-28.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34222 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-28.png\" alt=\"Add bullet points in Excel\" width=\"864\" height=\"402\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-28.png 864w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-28-300x140.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-28-768x357.png 768w\" sizes=\"(max-width: 864px) 100vw, 864px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Type the list.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-29.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34223 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-29.png\" alt=\"Add bullet points in Excel\" width=\"749\" height=\"397\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-29.png 749w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-29-300x159.png 300w\" sizes=\"(max-width: 749px) 100vw, 749px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> Right-click on the list and select Bullet. You can select any of the pre-designed bullets from the list.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-30.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34224 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-30.png\" alt=\"Add bullet points in Excel\" width=\"976\" height=\"668\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-30.png 976w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-30-300x205.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-30-768x526.png 768w\" sizes=\"(max-width: 976px) 100vw, 976px\" \/><\/a><\/p>\n<p>Your bullet list is now ready.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-31.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34225 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-31.png\" alt=\"Add bullet points in Excel\" width=\"705\" height=\"395\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-31.png 705w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-31-300x168.png 300w\" sizes=\"(max-width: 705px) 100vw, 705px\" \/><\/a><\/p>\n<p>Text boxes allow for precise positioning and formatting but this method is useful only if you are comfortable with presenting the data within a text box instead of a cell in the worksheet.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_7_%E2%80%93_SmartArt\"><\/span><strong><span id=\"7\" style=\"color: #ff0000;\">Method 7 &#8211; SmartArt<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>For a more visually appealing presentation, you can use <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/charts\/smart-art\/\" target=\"_blank\" rel=\"noopener\"><strong>SmartArt<\/strong><\/a> to create structured lists with bullet points. Follow these steps &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1:<\/span><\/strong> Go to<strong> Insert<\/strong> &gt;<strong> SmartArt<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-19.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34219 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-19.png\" alt=\"Add bullet points in Excel\" width=\"1480\" height=\"163\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-19.png 1480w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-19-300x33.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-19-1024x113.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-19-768x85.png 768w\" sizes=\"(max-width: 1480px) 100vw, 1480px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2:<\/span><\/strong> In the Choose a SmartArt Graphic dialog box, click on <strong>List<\/strong> and select the<strong> Vertical Curved List<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34218 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-18.png\" alt=\"Add bullet points in Excel\" width=\"850\" height=\"481\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-18.png 850w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-18-300x170.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-18-768x435.png 768w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3:<\/span><\/strong> Click on the<strong> small arrow<\/strong> on the left.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-26.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34220 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-26.png\" alt=\"Add bullet points in Excel\" width=\"688\" height=\"331\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-26.png 688w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-26-300x144.png 300w\" sizes=\"(max-width: 688px) 100vw, 688px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4:<\/span><\/strong> Type the list in the panel.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-34217 size-full\" title=\"Add bullet points in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-17.png\" alt=\"Add bullet points in Excel\" width=\"872\" height=\"382\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-17.png 872w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-17-300x131.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2024\/01\/Add-Bullet-Points-17-768x336.png 768w\" sizes=\"(max-width: 872px) 100vw, 872px\" \/><\/a><\/p>\n<p>SmartArt is excellent for creating dynamic and visually appealing bullet point lists.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><span style=\"color: #ff0000;\"><b>Conclusion<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In conclusion, <a href=\"https:\/\/support.microsoft.com\/en-au\/office\/insert-bullets-in-a-worksheet-60274daa-8079-4b40-8f69-0652dbadb4ec\" target=\"_blank\" rel=\"nofollow noopener\"><strong>adding bullet points<\/strong><\/a> in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/101-excel-macros-examples\/\" target=\"_blank\" rel=\"noopener\"><strong>Microsoft<\/strong> <strong>Excel<\/strong><\/a> can be accomplished through various methods, each offering unique advantages.<\/p>\n<p>Whether you prefer the simplicity of keyboard shortcuts, the flexibility of inserting symbols, the ease of CHAR function, the utilization of text boxes, the application of special font or <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-number-formats-thousands-millions\/\" target=\"_blank\" rel=\"noopener\"><strong>custom format<\/strong><\/a>, or the visual appeal of SmartArt, Excel provides the tools to enhance the presentation and readability of your data.<\/p>\n<p>Experiment with these methods to discover which ones best suit your specific needs and preferences.<\/p>\n<p><span style=\"font-weight: 400;\">Learn more about Formulas with our <\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>101 Advanced Excel Formulas &amp; Functions Examples<\/strong><\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel is a powerful tool widely used for data analysis, calculations, and organizing information. But, it is also a versatile tool for presenting and organizing textual information. You might encounter a situation where you must add a list, make key points, highlight milestones, or provide a step-by-step guide. In all such situations, you must [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":34281,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[3,9],"tags":[1562,1563,1564],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/34139"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=34139"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/34139\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/34281"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=34139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=34139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=34139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}