Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I create a list inside a single cell?

I need to be able to create a simple, bulleted list inside a single cell,
where I don't need to be concerned about the cell width in order for a line
to break as I desire.
Thanks.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 709
Default How do I create a list inside a single cell?

desert_penguin, to get a new line in a cell use Alt+enter, is that what you
want?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"desert_penguin" wrote in message
...
I need to be able to create a simple, bulleted list inside a single cell,
where I don't need to be concerned about the cell width in order for a
line
to break as I desire.
Thanks.



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,203
Default How do I create a list inside a single cell?

For the other part of it, the bulleted list, you can use Insert | Symbol at
the beginning of each line to pick a type of bullet to show there. Actually,
once you've inserted it once, you can copy that one character and then paste
it at the start of each new line within the cell after using [Alt]+[Enter]

"Paul B" wrote:

desert_penguin, to get a new line in a cell use Alt+enter, is that what you
want?

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"desert_penguin" wrote in message
...
I need to be able to create a simple, bulleted list inside a single cell,
where I don't need to be concerned about the cell width in order for a
line
to break as I desire.
Thanks.




  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default How do I create a list inside a single cell?

Bullets can be inserted by using ALT + 0149 from the NumPad

To get more than one line in a cell type your bullet, data then hit ALT + ENTER.

Once you experiment you will get the idea.

You can make a bulleted/numbered list in a cell.


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 10:49:02 -0700, desert_penguin
wrote:

I need to be able to create a simple, bulleted list inside a single cell,
where I don't need to be concerned about the cell width in order for a line
to break as I desire.
Thanks.


Gord Dibben MS Excel MVP
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
insert date Larry Excel Worksheet Functions 28 July 15th 06 02:41 AM
Copy List of text to a single cell? nastech Excel Discussion (Misc queries) 3 February 15th 06 03:19 AM
create a list of single values from multiple values Jordan Excel Worksheet Functions 3 November 4th 05 12:25 AM
How to create Multiple Conditional Formulas in a single cell? Maxfx Excel Discussion (Misc queries) 2 February 1st 05 03:26 PM
Is it possible to create a table inside of a cell? Jose Excel Discussion (Misc queries) 1 January 21st 05 07:47 AM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"