Forum Discussion

M_Davis's avatar
M_Davis
Copper Contributor
Aug 06, 2020
Solved

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

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 subjec...
  • PReagan's avatar
    Aug 06, 2020

    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.

Resources