Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i have a drop-down menue in a cell of an Excel preadsheet
I am trying to have a choice of different options in some cells of a
spreadsheet and need to know how to creat them. appreciate your help. Reza |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i have a drop-down menue in a cell of an Excel preadsheet
Data - Validation... Change the "Allow" to "List", make sure the In-cell dropdown is checked, and supply the list of values in the "Source" area. (Can be a typed list, a list somewhere in the spreadsheet, etc) -- Maistrye ------------------------------------------------------------------------ Maistrye's Profile: http://www.excelforum.com/member.php...o&userid=36078 View this thread: http://www.excelforum.com/showthread...hreadid=559066 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i have a drop-down menue in a cell of an Excel preadsheet
Click in the cell(s) where the drop-down should appear and select Data
Validation. You'll probably select a 'List' and either type the values (separated by commas) or indicate a range of cells where each cell contains one valid selection. You'll also have options to select what action to take if an invalid value is entered (stop, show a warning, ...) "Reza Rassoulli" wrote: I am trying to have a choice of different options in some cells of a spreadsheet and need to know how to creat them. appreciate your help. Reza |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i have a drop-down menue in a cell of an Excel preadsheet
Go to Debra Dalgleish's web site and scroll down to the D's.
Check out the pages on "Data Validation", for all you'll need to know about this subject: http://www.contextures.com/tiptech.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Reza Rassoulli" <Reza wrote in message ... I am trying to have a choice of different options in some cells of a spreadsheet and need to know how to creat them. appreciate your help. Reza |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions |