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

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

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

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