Tuesday, May 24, 2011

How to Make Bullets in Excel Entries


Insert a Bullet to a Cell
1. Open the Excel worksheet.
2. Double-click the cell where you wish to insert the bullet symbol.
3. Press “Alt” and “7” using the numeric keypad on the keyboard. A black bullet appears in the cell. To create a bullet with a white interior and a black outline, press “Alt” and “9” on the numeric keypad. If you prefer a different bullet style, click the “Insert” tab on the command ribbon. Click “Symbol” in the “Symbols” group. Select a font. Select the bullet symbol. Click “OK” and “Close.”
4. Add more bulleted lines in the same cell by pressing “Alt” and “Enter.” The cell will contain a line break. Repeat the “Alt” and “7” or “Alt” and “9” keyboard shortcut to insert the bullet symbol on the new line.
Insert a Bullet to a List
5. Open the Excel worksheet that contains the list.
6. Add a bullet to a list in one cell by double-clicking the cell.
7. Place the insertion point on the line where you wish to insert the bullet.
8. Click the “Insert” tab on the command ribbon.
9. Click the blue “Symbol” button in the “Symbols” group. A chart with symbols displays.
10. Click the “Font” text box arrow. Select your preferred font. For example, “Arial Narrow.”
11. Scroll to view the symbols. For example, certain fonts display squares, diamonds, flags and arrows. Click your preferred bullet symbol.
12. Click “Insert.” Click “Close.” The selected symbol appears on the selected line in the cell.

Blogger news