Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help
I am trying to create a spreadsheet where data is inputted but the content of certain columns is restricted to certain text values which can be selected by the inputter. For example: column A: ES, EW, EE, SH, SR Column B: Yes or NO Column C: Crime, Evidence, Drugs or Other The column names are just as examples. Does anyone know how this can be done? -- rjc_29 ------------------------------------------------------------------------ rjc_29's Profile: http://www.excelforum.com/member.php...fo&userid=3475 View this thread: http://www.excelforum.com/showthread...hreadid=489071 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help
It seems like you need to use Data Validation.
Check Debra Dalgleish's site: http://www.contextures.com/xlDataVal01.html Does that help? *********** Regards, Ron "rjc_29" wrote: I am trying to create a spreadsheet where data is inputted but the content of certain columns is restricted to certain text values which can be selected by the inputter. For example: column A: ES, EW, EE, SH, SR Column B: Yes or NO Column C: Crime, Evidence, Drugs or Other The column names are just as examples. Does anyone know how this can be done? -- rjc_29 ------------------------------------------------------------------------ rjc_29's Profile: http://www.excelforum.com/member.php...fo&userid=3475 View this thread: http://www.excelforum.com/showthread...hreadid=489071 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help
Look under Data / Validation...
"rjc_29" wrote: I am trying to create a spreadsheet where data is inputted but the content of certain columns is restricted to certain text values which can be selected by the inputter. For example: column A: ES, EW, EE, SH, SR Column B: Yes or NO Column C: Crime, Evidence, Drugs or Other The column names are just as examples. Does anyone know how this can be done? -- rjc_29 ------------------------------------------------------------------------ rjc_29's Profile: http://www.excelforum.com/member.php...fo&userid=3475 View this thread: http://www.excelforum.com/showthread...hreadid=489071 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help
Try Data menu | Validation. You can use this to restrict values in selected
cells. Be sure to select properly. Add column labels describing the data, then select the entire column before running the menu option to ensure the restrictions apply to all cells in that column. "rjc_29" wrote: I am trying to create a spreadsheet where data is inputted but the content of certain columns is restricted to certain text values which can be selected by the inputter. For example: column A: ES, EW, EE, SH, SR Column B: Yes or NO Column C: Crime, Evidence, Drugs or Other The column names are just as examples. Does anyone know how this can be done? -- rjc_29 ------------------------------------------------------------------------ rjc_29's Profile: http://www.excelforum.com/member.php...fo&userid=3475 View this thread: http://www.excelforum.com/showthread...hreadid=489071 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help
Go To Data|Validation and choose to allow: List Enter the values of the list in the source box separated by commas. -- Vito ------------------------------------------------------------------------ Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182 View this thread: http://www.excelforum.com/showthread...hreadid=489071 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|