Forum Discussion

Jaimeeow's avatar
Jaimeeow
Copper Contributor
Jun 07, 2022

Make simple checkboxes into a standard tool, not developer tool

why in so many applications is it so easy to just start a checklist? in word you can do it, simply start bullet points and click the checkbox bullet point. boom, done.

i understand that you can do many complex and intricate things with the developer tool checkboxes in excel, by why is there not a simple option that just lets me make a checklist for a matrix of things?
example: i have multiple sheets to check for various items. i need to have the list of sheets descending in the y direction and the list of things i need to check for each sheet in the x direction (or vice versa) and all i want to do is select the empty space after i've created the list and fill them in with checkboxes.

why do i have to learn how to use an entirely new developer tool just to do that? that's quite ridiculous.

our office has mostly just resorted to typing an X or "done" in the fields that would be checked off in a table. i can do that and it is easy, but a checkbox would be so much simpler and it seems quite ridiculous that it just doesn't exist in excel. that way instead of pasting "done" or typing an x into a field i could just click through to check things off the same way you can check off items in a phone app list or anything else. what gives? how many years has excel been around and this still isn't a thing? was it a thing that got removed? why does it only exist as an overly complicated developer tool?

  • Jaimeeow's avatar
    Jaimeeow
    Copper Contributor
    94 Views.
    0 Likes.
    I just don't understand. how could i possibly be the only person who finds this perplexing that a simple feature that OneNote can easily do, simply does not exist in Excel?
  • Jaimeeow's avatar
    Jaimeeow
    Copper Contributor

    Jaimeeow 

    everyone, see attached photos to see what adds insult to this injury. works fine in a more simplified app, but in onenote formatting cells is more difficult.

    and below is a picture of how i currently do checklists using conditional formatting. again, it's not that hard, but why is it so hard just to add checkbox functionality to excel? why does it need to be an overly complicated developer tool when in other apps you simply say "add to-do tag" or "make bullet points checkboxes"

Resources