Setting up a column of "enum"-fields in Excel
Setting up a column of "enum"-fields in Excel
Setting up a column of "enum"-fields in Excel
Re: Setting up a column of "enum"-fields in Excel
Piece of cake.
1) Enter your list of the fixed values. (These have to be in the same sheet as the cell you want to restrict)
2) Click on the cell you want to restrict. Select "**validation**" from the Excel "**Data**" pull down menu
3) In the pull down on the "**Settings**" tab select "**List**"
4) click In the box labeled "**Source**" then select the cells that contain the values set up in step 1)
5) Click OK and you are done.
You can do this for any number of cells
You will see a pull down icon next to the restricted cell(s). Click on it to choose only values in the list. Excel will not allow any other value in this cell.
Look around in the Validation dialog box and you will see you can tweak how this works.
1) Enter your list of the fixed values. (These have to be in the same sheet as the cell you want to restrict)
2) Click on the cell you want to restrict. Select "**validation**" from the Excel "**Data**" pull down menu
3) In the pull down on the "**Settings**" tab select "**List**"
4) click In the box labeled "**Source**" then select the cells that contain the values set up in step 1)
5) Click OK and you are done.
You can do this for any number of cells
You will see a pull down icon next to the restricted cell(s). Click on it to choose only values in the list. Excel will not allow any other value in this cell.
Look around in the Validation dialog box and you will see you can tweak how this works.