How to Insert Bullet Points in Excel? 6 Multiple Ways

digimarketer2k25

posted on 4 days ago — updated on 1 second ago

20
views

<p class="" data-start="107" data-end="341">When working with Excel, adding bullet points can enhance readability and organization. <strong><a class="inline_disabled" href="https://www.bizinfograph.com/resource/how-to-insert-bullet-points-in-excel/" target="_blank" rel="noopener noreferrer">excel bullet points</a></strong>, Excel does not have a direct bullet point function, but there are several ways to insert them. Here are six multiple ways to do so:</p><h3 class="" data-start="343" data-end="380">1. <strong data-start="350" data-end="378">Using Keyboard Shortcuts</strong></h3><p class="" data-start="381" data-end="471">One of the easiest ways to insert bullet points in Excel is by using keyboard shortcuts:</p><ul data-start="472" data-end="649"><li class="" data-start="472" data-end="529"><p class="" data-start="474" data-end="529">Select the cell where you want to add a bullet point.</p></li><li class="" data-start="530" data-end="602"><p class="" data-start="532" data-end="602">Press <strong data-start="538" data-end="549">ALT + 7</strong> (on the numeric keypad) for a standard bullet (•).</p></li><li class="" data-start="603" data-end="649"><p class="" data-start="605" data-end="649">Press <strong data-start="611" data-end="622">ALT + 9</strong> for a hollow bullet (◘).</p></li></ul><h3 class="" data-start="651" data-end="687">2. <strong data-start="658" data-end="685">Using the CHAR Function</strong></h3><p class="" data-start="688" data-end="753">Excel's CHAR function allows you to insert bullets dynamically:</p><ul data-start="754" data-end="879"><li class="" data-start="754" data-end="822"><p class="" data-start="756" data-end="822">Click on a cell and type <code data-start="781" data-end="793">=CHAR(149)</code>, which gives a bullet (•).</p></li><li class="" data-start="823" data-end="879"><p class="" data-start="825" data-end="879">Press <strong data-start="831" data-end="840">Enter</strong>, and you will see the bullet appear.</p></li></ul><h3 class="" data-start="881" data-end="915">3. <strong data-start="888" data-end="913">Using a Custom Format</strong></h3><p class="" data-start="916" data-end="965">To add bullets automatically in multiple cells:</p><ul data-start="966" data-end="1217"><li class="" data-start="966" data-end="1010"><p class="" data-start="968" data-end="1010">Select the cells where you want bullets.</p></li><li class="" data-start="1011" data-end="1066"><p class="" data-start="1013" data-end="1066">Press <strong data-start="1019" data-end="1031">CTRL + 1</strong> to open the Format Cells window.</p></li><li class="" data-start="1067" data-end="1132"><p class="" data-start="1069" data-end="1132">Go to the <strong data-start="1079" data-end="1089">Number</strong> tab, select <strong data-start="1102" data-end="1112">Custom</strong>, and enter <code data-start="1124" data-end="1129">• @</code>.</p></li><li class="" data-start="1133" data-end="1217"><p class="" data-start="1135" data-end="1217">Click <strong data-start="1141" data-end="1147">OK</strong>, and all text entries in the selected cells will now have a bullet.</p></li></ul><h3 class="" data-start="1219" data-end="1253">4. <strong data-start="1226" data-end="1251">Using the Symbol Menu</strong></h3><p class="" data-start="1254" data-end="1302">You can manually insert bullets using symbols:</p><ul data-start="1303" data-end="1514"><li class="" data-start="1303" data-end="1351"><p class="" data-start="1305" data-end="1351">Click on the cell where you want the bullet.</p></li><li class="" data-start="1352" data-end="1396"><p class="" data-start="1354" data-end="1396">Go to <strong data-start="1360" data-end="1379">Insert > Symbol</strong> in the ribbon.</p></li><li class="" data-start="1397" data-end="1473"><p class="" data-start="1399" data-end="1473">Choose <strong data-start="1406" data-end="1426">Arial Unicode MS</strong> as the font and scroll to find a bullet (•).</p></li><li class="" data-start="1474" data-end="1514"><p class="" data-start="1476" data-end="1514">Click <strong data-start="1482" data-end="1492">Insert</strong> and then <strong data-start="1502" data-end="1511">Close</strong>.</p></li></ul><h3 class="" data-start="1516" data-end="1545">5. <strong data-start="1523" data-end="1543">Using Copy-Paste</strong></h3><p class="" data-start="1546" data-end="1575">For quick bullet insertion:</p><ul data-start="1576" data-end="1677"><li class="" data-start="1576" data-end="1635"><p class="" data-start="1578" data-end="1635">Copy a bullet point from another source (such as Word).</p></li><li class="" data-start="1636" data-end="1677"><p class="" data-start="1638" data-end="1677">Paste it into the desired Excel cell.</p></li></ul><h3 class="" data-start="1679" data-end="1724">6. <strong data-start="1686" data-end="1722">Using a Formula for Bullet Lists</strong></h3><p class="" data-start="1725" data-end="1771">If you need a list with bullets in one cell:</p><ul data-start="1772" data-end="1927"><li class="" data-start="1772" data-end="1858"><p class="" data-start="1774" data-end="1792">Use the formula:</p><div class="contain-inline-size rounded-md border-[0.5px] border-token-border-medium relative bg-token-sidebar-surface-primary"><div class="flex items-center text-token-text-secondary px-4 py-2 text-xs font-sans justify-between h-9 bg-token-sidebar-surface-primary dark:bg-token-main-surface-secondary select-none rounded-t-[5px]">sql</div><div class="sticky top-9"><div class="absolute bottom-0 right-0 flex h-9 items-center pr-2"><div class="flex items-center rounded bg-token-sidebar-surface-primary px-2 font-sans text-xs text-token-text-secondary dark:bg-token-main-surface-secondary"><span class="" data-state="closed"><button class="flex gap-1 items-center select-none px-4 py-1" aria-label="Copy">Copy</button></span><span class="" data-state="closed"><button class="flex select-none items-center gap-1 px-4 py-1">Edit</button></span></div></div></div><div class="overflow-y-auto p-4" dir="ltr"><code class="!whitespace-pre"><span class="hljs-operator">=</span><span class="hljs-type">CHAR</span>(<span class="hljs-number">149</span>)<span class="hljs-operator">&</span>" Item 1"<span class="hljs-operator">&</span><span class="hljs-type">CHAR</span>(<span class="hljs-number">10</span>)<span class="hljs-operator">&</span><span class="hljs-type">CHAR</span>(<span class="hljs-number">149</span>)<span class="hljs-operator">&</span>" Item 2"</code></div></div></li><li class="" data-start="1859" data-end="1927"><p class="" data-start="1861" data-end="1927">Enable <strong data-start="1868" data-end="1881">Wrap Text</strong> from the Format menu for proper formatting.</p></li></ul><p> </p><p class="" data-start="1929" data-end="2051">By using these six methods, you can effectively insert bullet points in Excel and enhance the organization of your data.</p>