Last updated: February 23, 2017
Adding bullets in Excel is something that might seem like an obvious feature to include in the program but, if you are reading this article, you have probably found that it is not the case. Microsoft Word and Powerpoint make it very easy to create bulleted or numbered lists. This can happen so easily that you might not even be trying to create a list. But Excel 2013 does not offer a similar automatic list option, nor is there a way on the ribbon for you to enter one manually.
Fortunately you can add a bullet before a list item using a keyboard shortcut. You can even elect to add multiple bulleted items into a single cell with the help of a line break keyboard shortcut. Our guide below will show you how.
Multi-Item Bullet Lists in a Single Cell in Excel 2013
The steps in this article are going to show you how to create a bulleted list of two or more items inside a single cell of an Excel worksheet.
Step 1: Open a worksheet in Excel 2013.
Step 3: Hold down the Alt key on your keyboard, then press 0, then 1, then 4, then 9. This should insert a bullet into the cell.
Step 4: You can then type the information that you want to include as the first bulleted item. Once you have reached the end of the first line, hold down the Alt key on the keyboard, then press Enter. You can continue adding bullets by pressing Alt +0149 and adding line breaks by pressing Alt + Enter.
You can use different items as bullets by selecting them from the Symbols menu on the Insert tab as well, clicking a symbol on the menu, then clicking the Insert button to insert it into the cell.
Summary – how to add bullets in Excel 2013
- Click inside the cell where you want to add bullets.
- Hold down the Alt key, then press 0, then 1, then 4, then 9.
- Enter the information for the first bullet, then hold down the Alt key on your keyboard and press Enter to move to the next line within that cell.
- repeat steps 2 and 3 for each additional bullet item that you wish to add in Excel.
You can force Excel 2013 to automatically resize rows or columns to fit the size of their data by reading this article – https://www.solveyourtech.com/automatically-resize-row-height-excel-2013/ . This can save some frustration if your row or column sizing is acting difficultly.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.