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 analysing 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.
- Skill level:
Other People Are Reading
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.
Tips and warnings
- 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.
- 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.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for