{"id":115627,"date":"2020-11-19T14:23:00","date_gmt":"2020-11-19T11:23:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-insert-bullet-points-in-an-excel-spreadsheet\/"},"modified":"2020-11-19T14:23:00","modified_gmt":"2020-11-19T11:23:00","slug":"how-to-insert-bullet-points-in-an-excel-spreadsheet","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-insert-bullet-points-in-an-excel-spreadsheet\/","title":{"rendered":"#How to Insert Bullet Points in an Excel Spreadsheet"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a3dfe2da9b8b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a3dfe2da9b8b\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-bullet-points-in-an-excel-spreadsheet\/#Insert_Bullet_Points_From_the_Symbol_Menu\" >Insert Bullet Points From the Symbol Menu<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-bullet-points-in-an-excel-spreadsheet\/#Insert_Bullet_Points_in_a_Text_Box\" >Insert Bullet Points in a Text Box<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-insert-bullet-points-in-an-excel-spreadsheet\/#Insert_Bullet_Points_Using_Keyboard_Shortcuts\" >Insert Bullet Points Using Keyboard Shortcuts<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Insert Bullet Points in an Excel Spreadsheet&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-435491 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2019\/07\/xstock-lede-microsoft-office_excel-1.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.Bi7kk-HHRf.png\" alt=\"Excel Logo on a gray background\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Adding a bulleted list in an Excel worksheet isn\u2019t straightforward, but it\u2019s possible. Unlike Microsoft Word\u2014or even PowerPoint\u2014there\u2019s not much in the way of visual cues to guide you when adding these lists. Instead, we\u2019ll try some manual trickery to get the task done.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_Bullet_Points_From_the_Symbol_Menu\"><\/span>Insert Bullet Points From the Symbol Menu<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>First, select any blank cell in your Excel workbook.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-695875\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xblank.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.gW1EQx7ZTn.png\" alt=\"blank cell excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Make sure you have the \u201cInsert\u201d tab open and click \u201cSymbol\u201d from under the \u201cSymbols\u201d icon.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-695874\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xsymbols.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.5KgghIy9a7.png\" alt=\"symbol menu excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the dialog box, type 2022 in the \u201cCharacter code\u201d box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-695872\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/x2022.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.Gc3ZhjqJVf.png\" alt=\"unicode symbol excel\" width=\"650\" height=\"299\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cInsert\u201d and then \u201cClose.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-695873\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xinsert-close.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.roBk7KdMMn.png\" alt=\"insert and close in excel\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you want to add more bullets to the lines underneath, press ALT + Enter on the keyboard and repeat the previous steps.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_Bullet_Points_in_a_Text_Box\"><\/span>Insert Bullet Points in a Text Box<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you want to skip the functionality of a worksheet and just layer a text box on top, it\u2019s a more straightforward process than the above\u2014though you\u2019ll lose some of the functionality of a worksheet as it acts more like a Word document.<\/p>\n<p>Go to the \u201cInsert\u201d tab and click \u201cText Box\u201d under the \u201cText\u201d menu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696816\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xtext-textbox.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.ee1_Ni6eDJ.png\" alt=\"text menu text box\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click anywhere in the worksheet to add the text box. To resize, grab any of the corners, drag it to your desired size and then release the mouse button.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696817\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xdrag.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.kLRyffLQxv.png\" alt=\"drag to resize\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Type the list items inside the text box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696818\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xtype-items.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.YZoHbil75s.png\" alt=\"list of items in text box\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Highlight the items you want to add bullets to. To add the bullets, right-click the list and then click \u201cBullets\u201d from the list of options.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696821\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xbullets.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.DOi5ZxfDQo.png\" alt=\"right-click menu, bullets\" width=\"650\" height=\"299\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Choose your bullet style.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696820\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xbullet-style.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.AU4jKAwGkZ.png\" alt=\"bullet styles\" width=\"650\" height=\"299\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Insert_Bullet_Points_Using_Keyboard_Shortcuts\"><\/span>Insert Bullet Points Using Keyboard Shortcuts<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Click the cell where you\u2019d like to start your bulleted list.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696819\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xcell.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.xgxNrBufkK.png\" alt=\"empty cell\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a standard bullet, press Alt + 7 on your keypad. You can also use Alt + 9 if you\u2019d prefer a hollow bullet.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696825\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/bullet.png\" alt=\"bullets keyboard shortcuts\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To add more bullets, just click the square in the lower-right corner, hold the mouse button down, and drag the mouse down (or to the left or right) to fill in additional cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696822\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xmore-bullets.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.4DLusn408_.png\" alt=\"drag to copy bullets\" width=\"650\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Or, if you want to add your bullets to a non-adjacent cell, just highlight the bullets and press Ctrl + C to copy and then Ctrl + P to paste it into a new area.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-696824\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2020\/10\/xnon-adjacent.png.pagespeed.gp+jp+jw+pj+ws+js+rj+rp+rw+ri+cp+md.ic.nA_VQgBDy2.png\" alt=\"copy bullets to non-adjacent cell\" width=\"650\" height=\"299\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Excel, like most Microsoft Office products, has multiple ways to do the same thing. Just choose the way that works best for you and what you\u2019re trying to accomplish.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener noreferrer\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/695861\/how-to-insert-bullet-points-in-an-excel-spreadsheet\/\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Insert Bullet Points in an Excel Spreadsheet&#8221; Adding a bulleted list in an Excel worksheet isn\u2019t straightforward, but it\u2019s possible. Unlike Microsoft Word\u2014or even PowerPoint\u2014there\u2019s not much in the way of visual cues to guide you when adding these lists. Instead, we\u2019ll try some manual trickery to get the task done. Insert Bullet&#8230;<\/p>\n","protected":false},"author":1,"featured_media":115628,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/thumbcache\/2\/200\/2144ab7a8e4ef0c005417526e2a219c4\/wp-content\/uploads\/2019\/07\/stock-lede-microsoft-office_excel-1.png","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-115627","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/115627","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=115627"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/115627\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/115628"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=115627"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=115627"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=115627"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}