![]() |
Excel
I am trying to insert bullet points in one cell, but Ii could not find that
option, does it exist? Can i insert bullet points in one cell? Kindly assist |
Excel
Not like you can do in MSWord.
You could insert a character, then format it (change the font) to show the bullet you like. But that's a manual effort for each bullet. Zouz wrote: I am trying to insert bullet points in one cell, but Ii could not find that option, does it exist? Can i insert bullet points in one cell? Kindly assist -- Dave Peterson |
Excel
I use a bullet designed from auto shape in a macro. Very easy and it will go any where you wish. -- arkey44 ------------------------------------------------------------------------ arkey44's Profile: http://www.excelforum.com/member.php...o&userid=29871 View this thread: http://www.excelforum.com/showthread...hreadid=496365 |
Excel
I am trying to insert bullet points in one cell, but I could not find
that option, does it exist? Can I insert bullet points in one cell? If you have an "equal sign" character (=) and put it in the "Webdings" font, you get a "bullet" character. For example, I put this in A1: '= abc (The apostrophe is to make Excel treat it like text, not a formula.) Then, with A1 selected, I hit the F2 key. This lets me apply formatting to parts of the text in a cell. Then I selected the "equal sign" and used the font pull-down to choose "Webdings." This gave me a bulleted line with "abc" as the text. (I have Excel 97.) |
All times are GMT +1. The time now is 02:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com