Forum Discussion
Convert to Checkboxes
In the Excel Web app, there seems to be a new feature. When you are entering data in a column in a table, and are entering values y or n, you get a prompt asking you whether you would like to convert...
Apparently, it only happens within a structured table after you enter a few y or n. See screenshot below. Don't think it can be switched off.
Hello, Yes, that's what I found too.
Not sure what happened to my previous reply but that's exactly what happens.
It's a real pain as it's unwanted behaviour and it's too tempting for the users to resist.
I've found a work around for now which is to turn on data validation for the column and give the options "y" and "n" in a list. It stops the dialogue from popping up.