Saturday, August 27, 2011

How to Put Bullets in an Excel Spreadsheet


1. Open the Excel 2010 spreadsheet in which you want to add bullets.
2. Click on the cell where you want to add bullets. If there is already text in the cell, you will need to click on the formula bar above the spreadsheet. Place your cursor where you want the first bullet to go.
3. Hold down the 'Alt' button and press '7' on the numeric keypad. This will not work with the numbers above the keypad, so if you have a laptop without a dedicated numeric keypad, you will need to hold down the 'Function' button as well and type the letter that has 7 as an alternate. The bullet point appears.
4. Add the bullet point to adjacent cells by clicking and holding the mouse button over the bottom right corner of the cell. Drag the mouse to the right or down, and when you release the mouse button, all of the cells between where you started and where you released the button will be identical to the original cell.
5. Create a second bullet point in the original cell by clicking on the cell and then placing the cursor at the end of the first line of text, or right after the first bullet if there is no text. Hold down the 'Alt' button and press 'Enter.' Your text and bullet point will look like they disappeared, but they just moved up a line as you created a new text line in that cell. Press 'Alt' and '7' again to add another bullet point, and continue until you have all of the bullets that you need. You can move up and down between lines in a cell by using the arrows at the right end of the formula bar. You can also press the drop-down arrow at the end of the bar to expand the bar so that you can see three lines at once.

Blogger news