Bullet in MS Excel

Excel 2383 views 7 replies

I have typed a sentence in MS Excel. It extends to more than one cell. Now I would like to put a bullet at the begining of the sentence like we do in MS Word. But I am not finding the bullet button in the menu.

 

Can anyone please help?

 

Thanks.

 

 

Replies (7)

Go to Insert & select the symbol & insert the bullet whetever u want

You cannot put bullets in a single cell in excel.

Unlike Microsoft Word, Microsoft Excel does not provide a button to create a bulleted list in text. To add bullets to worksheet text, you need to insert a symbol. Do one of the following: To add a bullet to an empty cell on the worksheet, click the cell. You may want to do this if your bullets will be in a separate column from the list items. To add a bullet to a cell that contains text, double-click the cell, and then place the insertion point where you want the bullet to appear. Do this when you want the bullet and list item to appear in the same cell. On the Insert menu, click Symbol. On the Symbols tab, in the Font box, click the font that you want to use. Use the scroll bar on the right side to find the symbol that you want to insert. Tip Different fonts provide different symbols. If your font does not provide the bullet or other symbol that you want, try a selecting a font like Wingdings. Click the bullet or symbol that you want, click Insert, and then click Close. To add more bullets, you can copy and paste the first one that you inserted. Or, if the bullet is in its own cell, you can drag the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) to repeat the symbol in adjacent cells.

Thank you sirs. I got the solution to my problem.
 

there is any add ons for this?? please advice

 

thank you sir

Insert the symbol you want to be the bullet in a colum parallel to the required field.  Enter the data.  In the next colum use the contatenate formula.  [ =concatenate(a1,b1) ]  Copy the formula till the end of the table.  Then hide the colums a and b


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register