Adding a bulleted list in an Excel worksheet isn’t straightforward, but it’s possible. Unlike Microsoft Word– or even PowerPoint– there’s not much in the method of visual hints to assist you when including these lists. Rather, we’ll attempt some manual trickery to get the task done.
Insert Bullet Points From the Symbol Menu
Initially, choose any blank cell in your Excel workbook.
Make certain you have the “Insert” tab open and click “Symbol” from under the “Symbols” icon.
In the dialog box, type 2022 in the “Character code” box.
Click “Insert” and then “Close.”
If you wish to include more bullets to the lines below, press ALT + Enter on the keyboard and repeat the previous actions.
Place Bullet Points in a Text Box
If you want to skip the functionality of a worksheet and simply layer a text box on top, it’s a more straightforward process than the above– though you’ll lose a few of the performance of a worksheet as it acts more like a Word document.
Go to the “Insert” tab and click “Text Box” under the “Text” menu.
Click throughout the worksheet to add the text box. To resize, grab any of the corners, drag it to your preferred size and after that launch the mouse button.
Type the list items inside the text box.
Highlight the items you want to add bullets to. To include the bullets, right-click the list and after that click “Bullets” from the list of alternatives.
Choose your bullet design.
Place Bullet Points Using Keyboard Shortcuts
Click the cell where you ‘d like to start your bulleted list.
For a standard bullet, press Alt + 7 on your keypad. You can also utilize Alt + 9 if you ‘d prefer a hollow bullet.
To include 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 out extra cells.
Or, if you wish to include your bullets to a non-adjacent cell, just highlight the bullets and press Ctrl + C to copy and after that Ctrl + P to paste it into a new location.
Excel, like the majority of Microsoft Office items, has multiple methods to do the same thing. Just select the manner in which works best for you and what you’re attempting to accomplish.
Unlike Microsoft Word– or even PowerPoint– there’s not much in the method of visual cues to assist you when adding these lists. Click anywhere in the worksheet to add the text box. Highlight the products you desire to add bullets to. For a standard bullet, press Alt + 7 on your keypad.