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.
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.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.