| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down menu
How do you produce a drop down menu in a single cell in Excel
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
Hi Freddo,
If I understand what you are looking for, DATA | VALIDATION | LIST hth regards form Brazil Marcelo "Freddo" escreveu: How do you produce a drop down menu in a single cell in Excel |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
I think I am doing it wrong, what do you type for the source to get the list
from another spread sheet. I have typed in the source and I am just getting the formula in the drop down menu and not a list "Marcelo" wrote: Hi Freddo, If I understand what you are looking for, DATA | VALIDATION | LIST hth regards form Brazil Marcelo "Freddo" escreveu: How do you produce a drop down menu in a single cell in Excel |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
I have worked out how you can make a list but I have only worked out if the
list is on the same spreadsheet can you put the list on another spreadsheet "Marcelo" wrote: Hi Freddo, If I understand what you are looking for, DATA | VALIDATION | LIST hth regards form Brazil Marcelo "Freddo" escreveu: How do you produce a drop down menu in a single cell in Excel |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
Name the range of the list of data first, then type in the source =name. -- matt_the_brum ------------------------------------------------------------------------ matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751 View this thread: http://www.excelforum.com/showthread...hreadid=567879 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
Highlight your list, type a name for it in the white box on the top left of the screen that usually shows the cell name. Then do Data Validation-List and type in source =name of range -- matt_the_brum ------------------------------------------------------------------------ matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751 View this thread: http://www.excelforum.com/showthread...hreadid=567879 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
Freddo
You use the generic term "spreadsheet". Do you mean worksheet in a workbook or another workbook? To use a list from another worksheet or workbook, you must give the list a name and use the name in the source dialog box. See Debra Dalgleish's site for how to do this. http://www.contextures.on.ca/xlDataVal05.html Gord Dibben MS Excel MVP On Thu, 3 Aug 2006 07:19:01 -0700, Freddo wrote: I think I am doing it wrong, what do you type for the source to get the list from another spread sheet. I have typed in the source and I am just getting the formula in the drop down menu and not a list "Marcelo" wrote: Hi Freddo, If I understand what you are looking for, DATA | VALIDATION | LIST hth regards form Brazil Marcelo "Freddo" escreveu: How do you produce a drop down menu in a single cell in Excel |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
How do you name the range
"matt_the_brum" wrote: Name the range of the list of data first, then type in the source =name. -- matt_the_brum ------------------------------------------------------------------------ matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751 View this thread: http://www.excelforum.com/showthread...hreadid=567879 |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
See post #6 -- matt_the_brum ------------------------------------------------------------------------ matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751 View this thread: http://www.excelforum.com/showthread...hreadid=567879 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Drop down menu
Iam sorry I seem to have done it wrong it does not seem recongnise the naming
of the range "matt_the_brum" wrote: Highlight your list, type a name for it in the white box on the top left of the screen that usually shows the cell name. Then do Data Validation-List and type in source =name of range -- matt_the_brum ------------------------------------------------------------------------ matt_the_brum's Profile: http://www.excelforum.com/member.php...fo&userid=5751 View this thread: http://www.excelforum.com/showthread...hreadid=567879 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit Menu will not automatically drop down anymore | Excel Discussion (Misc queries) | |||
| Excel 2003 - Certain icons in drop down menu are not functioning | Excel Discussion (Misc queries) | |||
| hyperlinks in drop down menu | Excel Worksheet Functions | |||
| hyperlinks in drop down menu | Excel Worksheet Functions | |||
| How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
Linear Mode
