SOLVED

How to limit the values that can be input into a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1571369%22%20slang%3D%22en-US%22%3EHow%20to%20limit%20the%20values%20that%20can%20be%20input%20into%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571369%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%20I'm%20trying%20to%20make%20a%20workbook%20that%20will%20be%20used%20as%20a%20communication%20log.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20log%20will%20have%20an%20entry%20in%20each%20row.%20Each%20entry%20will%20have%20information%20like%20the%20creator's%20name%2C%20the%20date%2C%20the%20subject%2C%20and%20the%20comment.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20have%20a%20limited%20number%20of%20subjects%20that%20can%20be%20discussed%20in%20the%20log%2C%20so%20for%20example%2C%20people%20can%20make%20an%20entry%20about%20broad%20subjects%20like%20%22Scedules%22%20or%20%22Prorates%22%20or%20%22New%20Procedures%22%2C%20etc.%20I%20don't%20want%20people%20to%20be%20making%20entries%20with%20subjects%20that%20are%20too%20specific.%20That%20way%2C%20subjects%20can%20be%20easily%20filtered%20so%20people%20can%20see%20the%20information%20that%20is%20most%20relevant%20to%20them.%3C%2FP%3E%3CP%3EI%20know%20that%20there%20is%20a%20way%20to%20make%20cells%20that%20only%20allow%20certain%20inputs%20if%20they%20appear%20in%20a%20data%20range.%20If%20the%20data%20put%20into%20the%20cell%20is%20found%20in%20the%20range%2C%20then%20it%20is%20allowed%2C%20otherwise%2C%20it%20will%20say%20something%20like%20%22Error.%20The%20data%20is%20not%20found%20in%20the%20range%22.%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20you%20do%20that%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1571369%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1571381%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20limit%20the%20values%20that%20can%20be%20input%20into%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571381%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F731354%22%20target%3D%22_blank%22%3E%40M_Davis%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you're%20looking%20to%20do%20Data%20Validation.%20In%20the%20Data%20Tab%2C%20under%20Data%20Tools%2C%20select%20Data%20Validation.%20If%20you%20would%20like%20to%20restrict%20the%20subjects%20to%20a%20specific%20list%20of%20your%20choosing%2C%20under%20Allow%20choose%20List.%20You%20can%20reference%20a%20list%20in%20your%20workbook%20or%20simply%20type%20in%20your%20list%20using%20%22%2C%22%20comma%20separators.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1571410%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20limit%20the%20values%20that%20can%20be%20input%20into%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571410%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%26nbsp%3BYes.%20That's%20exactly%20what%20I%20was%20looking%20for.%20Thank%20you%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1571417%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20limit%20the%20values%20that%20can%20be%20input%20into%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1571417%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F731354%22%20target%3D%22_blank%22%3E%40M_Davis%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20pleasure!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hello. I'm trying to make a workbook that will be used as a communication log. 

The log will have an entry in each row. Each entry will have information like the creator's name, the date, the subject, and the comment. 

I want to have a limited number of subjects that can be discussed in the log, so for example, people can make an entry about broad subjects like "Scedules" or "Prorates" or "New Procedures", etc. I don't want people to be making entries with subjects that are too specific. That way, subjects can be easily filtered so people can see the information that is most relevant to them.

I know that there is a way to make cells that only allow certain inputs if they appear in a data range. If the data put into the cell is found in the range, then it is allowed, otherwise, it will say something like "Error. The data is not found in the range". 

How do you do that?

3 Replies
Highlighted
Best Response confirmed by M_Davis (New Contributor)
Solution

Hello @M_Davis,

 

Perhaps you're looking to do Data Validation. In the Data Tab, under Data Tools, select Data Validation. If you would like to restrict the subjects to a specific list of your choosing, under Allow choose List. You can reference a list in your workbook or simply type in your list using "," comma separators.

Highlighted

@PReagan Yes. That's exactly what I was looking for. Thank you so much!

Highlighted