Become a Certified GST Practitioner with CA Arun Chhajer. Register Now!

Bullet in MS Excel

Anil (1638 Points)

23 August 2008

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.

Reply
Follow
Share

7 Replies

CA MOHIT VAATS (Consultant) (554 Points)
Replied 23 August 2008

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

Upgrade to CAclubindia Pro. Subscribe Now!

CA Chaitanya (PRACTISING CA) (4283 Points)
Replied 23 August 2008

You cannot put bullets in a single cell in excel.

Rupesh Nigam (Associate) (35 Points)
Replied 23 August 2008

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.

Anil (1638 Points)
Replied 24 August 2008

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

(Guest)

there is any add ons for this?? please advice

Upgrade to CAclubindia Pro. Subscribe Now!

CHEZHIYAN (SENIOR FINANCIAL ANALYST) (2517 Points)
Replied 25 August 2008

thank you sir

Gopakumar V S (Government Servant) (27 Points)
Replied 01 May 2009

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