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.
7 Replies
CA MOHIT VAATS
(Consultant)
(554 Points)
Replied 23 August 2008
Go to Insert & select the symbol & insert the bullet whetever u want
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.
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
Recent Topics
- Reporting in gstr9 of ITC of Previous year reverse
- Tax on Reimbursement of House Rent
- MAHARASHTRA CHARITY COMMISSIONER WEBSITE
- Explanation 3 to section 11(1) read with section 4
- Ammendment in Partnership On Death of Partner and
- TDS Provisions applicability Tax Audit Individual
- NAME CHANGE OF HUF
- Advisory for Reporting TDS Deducted by scrap Deale
- Section 194 J Technical Service/Professional Servi
- Solving of Export Related Problems
Related Threads
CAclubindia
