How to Insert Bullet Points Into Excel 2007

by Liz Turner ; Updated September 28, 2017

Excel 2007 is a spreadsheet program included with the Microsoft Office 2007 suite of products. It allows users to perform tasks such as tracking and analyzing data, performing calculations and creating sortable lists. One feature it doesn't have, however, is a button similar to the one found in Word that automatically creates a bulleted list. For users who need to insert bullet points into Excel spreadsheets, a little extra work is required.

Select the cell or cells in which you want to insert bullet points. The cells can be empty, or they can have text already entered.

Click the "Format" button, which is found in the "Cells" group under the "Home" tab. Scroll to the bottom of the list that appears, and under "Protection," choose "Format Cells."

Click "Custom" under the "Number" tab. If the selected cells are empty, the "@" symbol will appear in the "Type" box. If there is already text in the cells, there will be text in the "Type" box. Scroll down in the "Type" menu until you see the "@" symbol, and select it; it will replace whatever text is already in the box.

Place the cursor before the "@" symbol in the "Type" box. Hold down the "Alt" key, and type 0149 on the number pad. Release the "Alt" key; a bullet will appear before the @ symbol. Insert a space between the bullet and the @ symbol if you want a space between the bullet and the text in the spreadsheet. Click "OK" to exit the "Format Cells" menu.

Enter text into the selected cells. A bullet will appear in front of any text entered. If there was already text in the cells, the bullet point will appear before it.

Tip

  • If a bullet point is only needed in one cell, just double-click the cell, insert the cursor before the text, and hold "Alt" while typing 0149 on the number pad. You can insert other symbols besides the round circle bullet in the same manner; just type whatever symbol you want to use before the "@" symbol.

Tip

  • Be sure to use the number pad, and not the numbers along the top of the keyboard. If the number pad does not work, press the "Num Lock" key. If the cells selected contain numbers, you may have to double-click the cells after inserting the bullets to reformat them. Adding the bullets reformats the cells as text, so any existing calculations will be lost.

About the Author

Liz Turner has been writing since 1994. Her work has been published in several technology publications and local newspapers, as well as on eHow and LIVESTRONG.COM. She has writing and editing experience in technology, business, children's issues, travel, animal care, beauty, health and fitness topics. She has a Bachelor of Arts in English from the University of Central Florida.

Photo Credits

  • photo_camera Creatas Images/Creatas/Getty Images