Bullet in MS Excel

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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
20 November 2026
Charted Accountant

Cothas Coffee Co.

Bengaluru

CA

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
Featured ARTICLESHIP 18 November 2026
Articles

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Foundation

View Details
Company
Featured ARTICLESHIP 31 October 2026
CA Articleship

apricus india

Navi Mumbai

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
16 November 2026
Assistant Article

ZAK & Co. Chartered Accountants

Bengaluru

CA Inter

View Details