Thursday, December 27, 2012

How to Insert Bullet Points Into Excel 2007


1. 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.
2. 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.'
3. 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.
4. 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.
5. 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.

Blogger news