If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do i filter check boxes?
I am trying to create a spreadsheet that has check boxes in it one column for
outstanding and one column for completed. How can I apply a filter so it will show me either the ones outstanding or the ones that have been completed? Thanks if you can help |
#2
|
|||
|
|||
how do i filter check boxes?
How are you creating the Check boxes?
"Bobble" wrote: I am trying to create a spreadsheet that has check boxes in it one column for outstanding and one column for completed. How can I apply a filter so it will show me either the ones outstanding or the ones that have been completed? Thanks if you can help |
#3
|
|||
|
|||
how do i filter check boxes?
I'd use a simple X in a cell--it makes filtering easier.
But you can use checkboxes from the Control toolbox toolbar and change the properties to move and size with cells (each checkbox!) Then use a linked cell on the same row that returns true/false for that checkbox. An alternative: Select the range that would have held the checkboxes. Format|cells|number tab|custom category In the "type:" box, put this: alt-0252;alt-0252;alt-0252;alt-0252 But hit and hold the alt key while you're typing the 0252 from the numeric keypad. It should look something like this when you're done. ü;ü;ü;ü (umlaut over the lower case u separated by semicolons) And format that range of cells as Wingdings (make it as large as you want) Now, no matter what you type (spacebar, x, anyoldtextatall), you'll see a check mark. Hit the delete key on the keyboard to clear the cell. If you have to use that "checkmark" in later formulas: =if(a1="","no checkmark","Yes checkmark") Or you can filter by blanks and non-blanks. Bobble wrote: I am trying to create a spreadsheet that has check boxes in it one column for outstanding and one column for completed. How can I apply a filter so it will show me either the ones outstanding or the ones that have been completed? Thanks if you can help -- Dave Peterson |
#4
|
|||
|
|||
how do i filter check boxes?
I am using the toolbars, control toolbox way of putting them in.
"Jim May" wrote: How are you creating the Check boxes? "Bobble" wrote: I am trying to create a spreadsheet that has check boxes in it one column for outstanding and one column for completed. How can I apply a filter so it will show me either the ones outstanding or the ones that have been completed? Thanks if you can help |
Thread Tools | |
Display Modes | |
|
|