Google Sheets Checkbox X Symbol: Show an X Instead

Google Sheets’ built-in checkbox cannot be changed to draw an X instead of its usual check mark. To show an X inside a box, use the text symbol ☒ or a formula that returns it; to keep an interactive checkbox, you can give it a custom checked value of X, but the checkbox itself will still look like a checked box.

What an X means in a Google Sheets checkbox

A checkbox in Sheets is a cell control, not just a decorative character. By default, an unchecked box has the value FALSE and a checked box has the value TRUE. The grid displays the familiar empty or check-marked box, while formulas can read the underlying value. That makes the control useful for marking tasks complete, recording responses, or controlling calculations.

There are two different requests people may mean by “checkbox X symbol”:

Use X as the checked value: the cell continues to show a native checkbox, but its stored checked value is the text X rather than TRUE.
Show a box containing an X: the cell displays the character ☒. This looks like an X in a box, but it is text or formula output, not a clickable checkbox.

Keeping that distinction in mind avoids a common surprise: changing the cell’s data value does not change the design of Google Sheets’ checkbox control.

Insert a standard interactive checkbox

In Google Sheets in a web browser, select the cell or range where you want checkboxes, then choose Insert > Checkbox. Each selected cell gets a checkbox. Click one to toggle it between unchecked and checked. You can also select a range first—for example, B2:B20—to add controls for a whole task list at once.

For a small example, put task names in A2:A4 and insert checkboxes in B2:B4. Clicking B2 marks the first task as done. With the default settings, formulas can test B2 for TRUE or count checked cells in the range. The checkbox is not a separate floating object: it belongs to the cell and moves, copies, and sorts with that cell’s contents.

To remove the controls, select the relevant cells and use the delete or clear option appropriate to your sheet. Be aware that deleting cell contents can also remove values or formulas in the selected range, so check what is selected before clearing a large area.

Set X as the checked value

If a workflow needs the literal letter X—for example, because another sheet or a downloaded report expects X—edit the checkbox validation rule. Select the checkbox cells and open Data > Data validation. In the rule, make sure the criterion is Checkbox, enable the option to use custom cell values, and enter X as the checked value. Set an unchecked value as well, such as a blank value if the rule accepts it or a clear label such as No. Save the rule.

The precise wording and placement of the controls in the data-validation side panel can change as Google updates Sheets, but the relevant settings are the checkbox criterion and its custom checked and unchecked values. If the cells already have checkbox rules, editing the existing rule is usually preferable to adding a second rule over the same range.

After this change, a click still toggles the checkbox control, but the cell’s underlying value is X when checked and the chosen unchecked value otherwise. The checked control still uses the normal check-mark appearance; it does not become a box with an X drawn inside. This option is valuable when X is the data convention, not when the goal is to change the visible icon.

For example, a column headed “Approved” might use X for a checked response and a blank for an unchecked one. That can make exported data easier to read, but it changes how formulas should test the cells. Formulas that expected TRUE now need to look for X, and formulas that count X values should account for the custom unchecked value.

Display a boxed X while keeping a checkbox control

If the appearance matters and you still want people to toggle a native checkbox, use two columns: one for the checkbox and one for the symbol. Put the interactive checkbox in B2 and use a formula in C2 to show a boxed X when B2 is checked and an empty box otherwise. With a default checkbox in B2, enter =IF(B2,UNICHAR(9746),UNICHAR(9744)) in C2. It returns ☒ when B2 is checked and ☐ when it is not. Fill the formula down for the other rows.

This arrangement preserves a simple, accessible control for editing while providing the requested symbol in a separate display column. The formula result is not itself clickable. Users toggle B2; C2 updates in response. You can hide the control column if that suits the layout, although doing so may make the source of the symbol less obvious to collaborators.

For a checkbox that uses X as its custom checked value rather than TRUE, the test in the display formula must match that value. If B2 is the custom-value checkbox and its checked value is X, use =IF(B2="X",UNICHAR(9746),UNICHAR(9744)) in C2. The formula returns ☒ for X and ☐ for any other value. A label or note can help explain the relationship between the input checkbox and the symbol column.

Use the ☒ character without a checkbox

If no one needs to click the cell, the simplest option is to paste the symbol ☒ directly into it. You can copy it from this page, or use a formula to generate the character. In a cell such as A2, =UNICHAR(9746) returns ☒. The related characters are =UNICHAR(9744) for ☐ and =UNICHAR(9745) for ☑. These formulas return text characters, not Sheets checkbox controls.

Direct text works well for a fixed legend, a printed checklist, or a symbol that someone has already decided should be marked. It is less suitable when the cell must capture a reliable yes-or-no input: a person can accidentally type over the symbol, and formulas cannot treat it as a native checkbox without checking the character itself.

Unicode symbols can look slightly different across fonts, browsers, operating systems, and print settings. If the box appears as a plain square, a missing glyph, or a style that does not match neighboring text, try changing the cell’s font or use the native checkbox instead. Check the sheet in the environment where it will be used or printed, since the font available to one viewer may differ from another’s.

Choose the right option for formulas and reports

Use a default checkbox when you want a clear interactive TRUE/FALSE input. For instance, a completion percentage can be calculated from the number of checked boxes. If B2:B6 contains five default checkboxes, and three are checked, =COUNTIF(B2:B6,TRUE) returns 3. Dividing that count by the number of tasks gives a completion rate; keep the range limited to actual task rows so blank rows do not distort the total.

Use a custom X value when another process specifically needs X as the stored data. If B2:B10 contains custom-value checkboxes with X for checked and blanks for unchecked, =COUNTIF(B2:B10,"X") counts the checked items. If two cells contain X, this formula returns 2. Be consistent: if unchecked cells use a word such as No, other formulas and exports need to account for that value.

Use ☒ and ☐ text when the symbol is mainly for display, or use a formula-driven symbol column when a separate interactive control should determine the display. Think about sorting, filtering, copying, and exports before choosing. A TRUE/FALSE checkbox is easy to test logically, while X is convenient for human-readable or legacy data but is text that must be compared as text.

Common problems and fixes

The box still shows a check mark. That is expected after setting X as a custom checked value. The custom value changes what is stored, not the checkbox graphic. Use ☒ as text or formula output to show an X.
A formula does not detect checked cells. Check whether the range uses the default TRUE value or a custom value such as X. A formula testing TRUE will not match a cell whose checked value is the text X.
The symbol looks wrong or is missing. Try a font with Unicode box-drawing symbols, or use a native checkbox for the input. Font rendering can vary between viewers and printouts.
The X appears, but clicking does nothing. A pasted character or a formula result is not interactive. Add a checkbox through Insert > Checkbox if users need to toggle the state.
Checkboxes are missing from some rows. Confirm that the data-validation rule’s range includes those cells. Selecting the full intended range before inserting checkboxes can prevent gaps.

Frequently Asked Questions

Can I make a Google Sheets checkbox show an X instead of a check mark?
No. Sheets does not provide a setting to replace the checkbox’s check-mark graphic with an X. Use the ☒ character for the visual effect, or show it in a formula column linked to a real checkbox.

How do I make a checked checkbox return X?
Select the checkbox cells, open Data > Data validation, edit the Checkbox rule, enable custom cell values, and set the checked value to X. The checkbox remains visually the standard checked control.

What is the Google Sheets symbol for a box with an X?
The Unicode character ☒ is a ballot box with an X. You can paste it into a cell, or generate it with =UNICHAR(9746). It is a text character rather than a checkbox control.

Can I count X-marked checkboxes?
Yes. If the checked value is custom text X, count that text with COUNTIF—for example, for a suitable range use =COUNTIF(B2:B10,"X"). If the checkboxes use default values, count TRUE instead.

Can a symbol formula also be clicked?
No. Formula output is not an interactive control. Put a native checkbox in one cell and a formula-generated ☒ or ☐ in another if you need both click-to-toggle input and an X-style display.

Google Sheets versus Excel

The steps above use Google Sheets in a web browser. Excel also offers cell checkboxes in supported Microsoft 365 versions, but its menus and checkbox implementation are not identical to Google Sheets. If you move a sheet between the two programs, verify the checkbox behavior, custom values, and formulas rather than assuming the control will transfer unchanged. Unicode symbols such as ☒ may also render differently depending on the selected font and the application.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.