| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bullet points
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bullet points
You can not. Excel is not meant for word processing.
"Wayne" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bullet points
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 "Sheeloo" wrote: You can not. Excel is not meant for word processing. "Wayne" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bullet points
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......... "Wayne" wrote: 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 "Sheeloo" wrote: You can not. Excel is not meant for word processing. "Wayne" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bullet points
:-)
Through code you can do almost anything.. "Wayne" wrote: 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......... "Wayne" wrote: 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 "Sheeloo" wrote: You can not. Excel is not meant for word processing. "Wayne" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bullet points
But you don't need code Sheelo
Alt + 0149 textAlt +Enter Alt + 0149 textAlt +Enter etc. Gord Dibben MS Excel MVP On Sat, 1 Nov 2008 16:49:01 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: :-) Through code you can do almost anything.. "Wayne" wrote: 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......... "Wayne" wrote: 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 "Sheeloo" wrote: You can not. Excel is not meant for word processing. "Wayne" wrote: 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bullet points
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. -- Thanks, Shane Devenshire "Wayne" wrote: 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bullet points
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... "Gord Dibben" wrote: But you don't need code Sheelo Alt + 0149 textAlt +Enter Alt + 0149 textAlt +Enter etc. Gord Dibben MS Excel MVP On Sat, 1 Nov 2008 16:49:01 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote: :-) Through code you can do almost anything.. "Wayne" wrote: 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......... "Wayne" wrote: 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 "Sheeloo" wrote: You can not. Excel is not meant for word processing. "Wayne" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bullet Points | Excel Worksheet Functions | |||
| Bullet points | New Users to Excel | |||
| bullet points in one cell? | Excel Discussion (Misc queries) | |||
| bullet points | Excel Worksheet Functions | |||
| Bullet Points in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
