This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using Excel Online and converting documents from Numbers to excel format. Numbers allowed you to create a checkbox column in their spreadsheets while Excel does not.
As a workaround, I am trying to insert a checkmark symbol into the Excel Online document but I'm unable to. I can insert a regular checkbox, but not a checkmark. I inserted the symbol into my Excel program just fine, but if I copy and paste to Excel Online, it's garbage.
Is there no workaround to get a checkmark in an Excel Online document?
Thanks,
Wanda
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I am having same issue and there is nothing to support check mark's and other symbols on online version. Thinking on my decision on going online.
Hi Wanda,
Try setting the font of the checkmark range to Marlett and, to add a checkmark, enter a lower case letter a.
===
Regards,
Norman
My apologies. I should have noted the Office 365 version you specified. While setting a custom number format is not possible in Excel Online, the format is used if you can set it through an Excel desktop application prior to sending it to the 'cloud'. As part of the formatting of the cell(s), it can be copied to other cells once you have one set.
That worksheet is available on my own OneDrive here for you to reference/download/transfer.
Excel online version, doesn't render the ticks
Thank you all, but does this apply to Excel online? I can't find any of those options. When I try to open my online documentation into excel it won't allow it. I'm finding this whole Office 365 experience very rigid.
My preferred method involves setting the cells to a WingDing font and using a custom number format (Ctrl+1, Number, Custom, Type:) of [color10]ü;;[color9]û;
This produces a green check when a 1 (or any positive number) is typed and a red × when a zero is typed.
Excel treats a 0 as FALSE and anything that is not a zero is TRUE so these can be used directly within conditional formulas like,
=IF(A1, <something if true>, <something if false>)