Where is bullets in excel 2010

This can create some unfortunate scenarios, however, as Excel does not have the full compliment of text-editing and formatting options that are present in Word So when you are attempting to create a bulleted list of items within a cell in Excel , you will find that there is not as simple a way to do so as there is in Word Fortunately you are able to create bullets for lists in Excel by following the steps below.

The row of numbers above your alphabetic keys will not work. Again, these need to be the number keys on the numeric keypad, not the row of numbers above your alphabetic keys. Step 4: Enter the data that you want to follow the bullet. If you want to move to a second line within that same cell for your next list item, hold the Alt key down and press Enter.

To see the steps for adding bullets in a cell, or in a textbox, watch this short Excel video tutorial. Here is a link to the page. Faster and easier to remember…. When the Symbol dialog box pops up, I can usually find what I want by, in the Font dropdown box, selecting Windgings-1, 2 or 3.

Your email address will not be published. This site uses Akismet to reduce spam. Learn how your comment data is processed. Skip to content. Add Bullets in Excel With a Formula You can add bullets with a formula too — just use the CHAR function, and refer to either of the numbers that we used in the shortcut keys above. 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. 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. Email This BlogThis!