قالب وردپرس درنا توس
Home / Tips and Tricks / Insert bullets into an Excel spreadsheet

Insert bullets into an Excel spreadsheet



Excel Logo on a gray background

Adding a bulleted list to an Excel worksheet isn’t easy, but it is possible. Unlike Microsoft Word – or even PowerPoint – there aren’t many visual cues to guide you in adding these lists. Instead, we will try some manual trickery to get the job done.

Insert bullets from the symbol menu

First, select a blank cell in your Excel workbook.

blank cell excels

Make sure the “Insert” tab is open and click “Symbol” under the “Symbols” icon.

symbol menu Excel

In the dialog box, type 2022 in the “Character Code” box.

unicode symbol Excel

Click on ‘Insert’ and then on ‘Close’.

insert and close in Excel

If you want to add more bullets to the lines below, press ALT + Enter on the keyboard and repeat the previous steps.

Insert bullets in a text box

If you want to skip the functionality of a worksheet and just put a text box on top of it, this is a simpler process than the above – although you will lose some of the functionality of a worksheet as it looks more like a Word document.

Go to the “Insert” tab and click on “Text Box” under the “Text” menu.

text menu text box

Click anywhere in the worksheet to add the text box. To resize, grab one of the corners, drag it to the size you want, then release the mouse button.

drag to resize

Type the list items in the text box.

list of items in text box

Highlight the items that you want to add bullets to. To add the bullets, right-click the list and then click “Bullets” in the list of options.

right-click menu, bullets

Choose your bullet.

bullet styles

Insert bullets using keyboard shortcuts

Click the cell where you want to start your bulleted list.

empty cell

For a standard bullet point, press Alt + 7 on your keyboard. You can also use Alt + 9 if you prefer a hollow bullet.

bullet shortcuts

To add more bullets, just click the square in the lower right corner, hold down the mouse button and drag the mouse down (or left or right) to fill in additional cells.

drag to copy bullets

Or, if you want to add your bullets to a nonadjacent cell, highlight the bullets and press Ctrl + C to copy, then Ctrl + P to paste them into a new area.

copy bullets to a non-adjacent cell

Excel, like most Microsoft Office products, has multiple ways to do the same. Just choose the way that works best for you and what you are trying to achieve.




Source link