Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 27th 06, 04:10 PM posted to microsoft.public.excel.newusers
Fedde
 
Posts: n/a
Default Making a list inside a cell


Hello,

I'd like to make a list inside a cell, in which you can choose the
sentence you would like to have into that specific cell.
For example:
I would like to have the following list into, say, cell F4:
- Tree
- Leaves
- Root
- Twig
- Oak

Is this possible to make?


--
Fedde
------------------------------------------------------------------------
Fedde's Profile: http://www.excelforum.com/member.php...o&userid=30900
View this thread: http://www.excelforum.com/showthread...hreadid=505739


  #2   Report Post  
Old January 27th 06, 04:31 PM posted to microsoft.public.excel.newusers
cycling-rod
 
Posts: n/a
Default Making a list inside a cell


Instructions for creating a drop-down list is he
http://www.beyondtechnology.com/tips018.shtml


--
cycling-rod
------------------------------------------------------------------------
cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520
View this thread: http://www.excelforum.com/showthread...hreadid=505739

  #3   Report Post  
Old January 27th 06, 04:38 PM posted to microsoft.public.excel.newusers
Fedde
 
Posts: n/a
Default Making a list inside a cell


Hey thanks!


--
Fedde
------------------------------------------------------------------------
Fedde's Profile: http://www.excelforum.com/member.php...o&userid=30900
View this thread: http://www.excelforum.com/showthread...hreadid=505739

  #4   Report Post  
Old January 27th 06, 05:26 PM posted to microsoft.public.excel.newusers
gls858
 
Posts: n/a
Default Making a list inside a cell

Fedde wrote:
Hello,

I'd like to make a list inside a cell, in which you can choose the
sentence you would like to have into that specific cell.
For example:
I would like to have the following list into, say, cell F4:
- Tree
- Leaves
- Root
- Twig
- Oak

Is this possible to make?


Check Excel Help for drop-down list. The instruction are pretty
straight forward. Post back if you need more help.

gls858
  #5   Report Post  
Old January 28th 06, 12:45 AM posted to microsoft.public.excel.newusers
paul
 
Posts: n/a
Default Making a list inside a cell

the combo box from the forms toolbar will also give you a list.Its advantage
to me is that the drop down is always visible whereas the validation list
only shows when you navigate to the cell
--
paul
remove nospam for email addy!



"Fedde" wrote:


Hello,

I'd like to make a list inside a cell, in which you can choose the
sentence you would like to have into that specific cell.
For example:
I would like to have the following list into, say, cell F4:
- Tree
- Leaves
- Root
- Twig
- Oak

Is this possible to make?


--
Fedde
------------------------------------------------------------------------
Fedde's Profile: http://www.excelforum.com/member.php...o&userid=30900
View this thread: http://www.excelforum.com/showthread...hreadid=505739




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
In Cell Validation List & Linked Cell VLOOKUP BEEZ Excel Discussion (Misc queries) 7 July 1st 07 07:17 PM
copy and pasting a find all list into another column Ben Excel Discussion (Misc queries) 18 December 31st 05 11:51 PM
Can a cell have a drop down list and can also be auto populated Adrian Excel Worksheet Functions 1 March 17th 05 06:05 AM
How do I create a bulleted list text format inside cell? DEH Excel Discussion (Misc queries) 5 February 1st 05 08:37 AM
How do I set up drop-down list for a cell when the list is in ano. redsunjvd Excel Discussion (Misc queries) 2 January 29th 05 02:03 AM


All times are GMT +1. The time now is 02:32 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017