You might have noticed that Excel doesn't appear to offer "Boolean" as cell type. When you try to format a cell, Excel will suggest formatting its contents as a currency, a date or time, a percentage but not a boolean value. Nonetheless, Excel does process boolean values and it regularly produces them as the output from formulas. To create a cell whose boolean value you change, create a checkbox. When checked, this box will have the value of "True." When unchecked, it will have the value of "False."
Step 1
Click "File."
Video of the Day
Step 2
Click "Options." This opens the "Excel Options" window.
Step 3
Click "Customize ribbon."
Step 4
Check the box next to "Developer" in the pane on the right. Click "OK."
Step 5
Click "Developer" from the menu bar.
Step 6
Click "Insert" from the "Controls" tab.
Step 7
Click the icon for a check box from the "form options" section.
Step 8
Click on the cell to which you want the add the boolean value.
Video of the Day