💻 Software
Setting up a column of "enum"-fields in Excel
Fresh7 days ago
Mar 15, 202683387 viewsConfidence Score0%
0%
Problem
I'd like to setup a column in excel with several fixed possible values (like 'in-progress', 'done', 'canceled'). I'd like to set it up so the only possible values in these column are from the fixed list, and it would be easy to pick one of these items whenever I try to edit a cell in this column (a…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Setting up a column of "enum"-fields in Excel
Low Risk
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 t…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix