ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel (https://www.excelbanter.com/excel-discussion-misc-queries/62058-excel.html)

Zouz

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

Dave Peterson

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

arkey44

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


Jay

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