What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-c
On Jul 28, 1:58*pm, "Ken Wright"
wrote:
For a *non code solution, simply select all the cells that will be toggled
and then firstly give them a name using Insert / Name / Define and call it
anything you like. *That lets you select them all in one easy hit using the
drop down just above cell A1.
Next, simply type TRUE/FALSE or 1/0 depending on what you are using and then
hit CTRL+ENTER which will put the same value into every cell.
Regards
* * * * * * * * *Ken.......................
"LunaMoon" wrote in message
...
What's the best way to toggle between true and false in Excel?
Hi all,
My excel work involves a lot of toggling between true and false
(boolean types) ... and it's very repetitive...
Is there a way to select a bunch of cells, and press a key short-cut
so that they toggle all at once?
Thanks!
thanks but this is not a toggle solution...
|