Blog Post

Excel Blog
1 MIN READ

Introducing Checkboxes in Excel

JakeArmstrong's avatar
JakeArmstrong
Icon for Microsoft rankMicrosoft
Jun 27, 2024

We're excited to announce the release of Checkboxes to production in Excel. They are great for checklists, managing tasks and visualizing your data at a glance. With just a few clicks, you can insert Checkboxes into any cell, making your spreadsheets more dynamic and user-friendly.

 

To insert Checkboxes:

  1. Select the range where you want checkboxes.
  2. Select Insert > Checkbox.

 

To check or uncheck a Checkbox:

  • Click on the checkbox.
  • Select one or more checkboxes and press Space.

 

To remove Checkboxes:

  • Press the Delete key.

If any of the checkboxes were checked, Delete will uncheck them. Press Delete again to remove them.

 

See the help article here, for more information: Using Checkboxes in Excel

 

Availability:

Don’t have it yet? It’s probably us, not you. Features are released over time to ensure everything is working smoothly.

Windows and Mac Desktop: Fully rolled out to users on Current Channel [Updated on July 31, 2024]

On Web and Mobile (iPad, iOS & Android): Partially rolled out to production users [Updated on July 31, 2024]

 

Checkboxes are among the most requested features by our user community, so thank you for all of your feedback!

 

Jake Armstrong (LinkedIn)

Senior Product Manager, Excel

Updated Jul 31, 2024
Version 3.0

63 Comments

  • cookt's avatar
    cookt
    Copper Contributor

    JakeArmstrong Great!  One more thing I suppose I should have clarified in my original question -- the collaboration will work between Windows and web once it's rolled out on Windows even if it hasn't rolled out officially on web yet?

  • cookt's avatar
    cookt
    Copper Contributor

    If the checkbox is created in Excel for Windows, will it function if that same spreadsheet is opened in Excel for Web?  Asking for collaboration use.

  • DavidG323, to confirm as Stefan_Alexandrov and Lukas_Kucharczyk suggested,

     

    The value of a Checked checkbox is TRUE

    The value of an Unchecked checkbox is FALSE

     

    If you would like to write formula that's easier with 1/0, a useful trick is multiplying the TRUE/FALSE by 1. (FALSE*1 = 0, TRUE*1 = 1)

     

    This is a link to the help article for Checkboxes which has some more detail: Using Checkboxes in Excel - Microsoft Support. I've also added the link to the blog post itself.

  • If it's checked it returns true / 1, if it's not it returns false / 0. 

    It's similar to the legacy activeX checkboxes, but now it's direcly connected to the cell!

     

  • DavidG323's avatar
    DavidG323
    Copper Contributor

    What is the cell value of the checkbox?  For instance might it be "1" or "0" so that I can use it in an IF conditional statement.  Then if checked, can do something but if not, leave it blank.