How to Insert Bullet List Items in Excel 2010

Microsoft Excel 2010 is a great tool when you need to evaluate and compare data, but it has other uses as well. In fact, you may find that you are doing a lot of text editing with your Excel spreadsheets. This can create some unfortunate scenarios, however, as Excel does not have the full compliment of text-editing and formatting options that are present in Word 2010.

So when you are attempting to create a bulleted list of items within a cell in Excel 2010, you will find that there is not as simple a way to do so as there is in Word 2010. Fortunately you are able to create bullets for lists in Excel 2010 by following the steps below.

 

Entering Bullet Lists In Excel 2010

It’s important to note for the instructions below that you need to use the numeric keypad on your keyboard. The row of numbers above your alphabetic keys will not work. If you do not have a 10-key numeric keypad on the right side of your keyboard, then you will need to press the Num Lock key at the top-right of the keyboard, then use the numeric keypad that is defined on your specific laptop’s keyboard. If you do not have a Num Lock key, then you will need to check the owner’s manual or documentation to determine how you can enable Num Lock on your laptop.

 

Step 1: Open the worksheet in Excel 2010 in which you want to insert a bullet list.

 

Step 2: Double-click inside the cell where you want to type the bullet.

click inside the cell where the bullet list will go

 

 

Step 3: Press the Alt + 7 keys at the same time to enter a closed-circle bullet. Alternatively you can press Alt + 9 to enter an open-circle bullet. Again, these need to be the number keys on the numeric keypad, not the row of numbers above your alphabetic keys.

enter your first bullet with alt and 7

 

 

Step 4: Enter the data that you want to follow the bullet. If you want to move to a second line within that same cell for your next list item, hold the Alt key down and press Enter. Otherwise you can move to a different cell by clicking on it with your mouse.

how to create bullet lists in excel 2010

 

 

Note that you can insert some additional symbols and characters by pressing the Alt key and any of the other numbers on the numeric keypad as well.

 

 

Alternatively, it is often easier to just create the bullet list in Microsoft Word, then copy and paste it into the desired cell in Excel 2010. If you want to paste the entire bullet list into one cell, then you will need to double-click inside that cell before pasting the copied list.

If you’re having trouble printing multipage documents in Excel 2010, then this article about printing a two-page spreadsheet on one page might be helpful.

solveyourtech.com newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.