Bullet points

W

Wayne

How do I format an Excel cell similar to an MS Word Table cell with bullets
or numbers on discrete lines within the cell ?
• Jgjgkj
• Kjhkh
• Kjhkh
• kjlkhlk
1. kjhkhlkhjl
2. lklkjhlkjh
3. lkjhlkjh
4. lkjhlkjh
 
W

Wayne

Yeah thanks

I have a very large workbook containing mixed text and data and need Excel
capability for sorting. In some text cells I need to provide a line
separated list of outcomes
 
W

Wayne

ok cracked it thanks

wrote a separate macro for inserting 1-5 bullet points in a cell
used insert symbol and a couple of spaces
used alt enter for the line break required

it can be done in Excel.........
 
S

Sheeloo

:)

Through code you can do almost anything..

Wayne said:
ok cracked it thanks

wrote a separate macro for inserting 1-5 bullet points in a cell
used insert symbol and a couple of spaces
used alt enter for the line break required

it can be done in Excel.........
Click to expand...
 
G

Gord Dibben

But you don't need code Sheelo

Alt + 0149> text>Alt +Enter
Alt + 0149> text>Alt +Enter
etc.


Gord Dibben MS Excel MVP
 
S

ShaneDevenshire

Hi,

I've written an app that puts bullet points in a cell using two methods both
work fine and there are hundreds of bullet styles you could choose from.

In addition I recommend that you NOT insert bullet points in cells, instead
you create custom formats that format the cell with bullets. The advantage
it that they don't interfere with the content of the cell.

If you want a copy of a file containing formatted bullets or the file with
the code method drop me a line.

[email protected]
 
S

Sheeloo

Gord,

You are entering each bullet by hand, it can not be done 'automatically' ...
I meant it could not be done through an option provided by Excel...
 
Top