Check boxes

[Michaela]

Hi!

In my work sheet I have several rows (and columns) with text and in each row
I have put a check box. When I sort the rows in different ways I want the
check boxes to "follow". I have tried to change the properties both "move
with cells" and "don't move with cells" but there is no difference. They stay
where they are... how do I do?

Kind regards
Michaela

 

[Dave Peterson]

Make sure that the checkboxes are completely within the cell. Don't let them
get close to the edge!

And make sure you include that column when you sort the range. (Are you letting
excel guess the range or are you selecting the range yourself?)

How about an alternative that I find easier to use.

(saved from a previous post)

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
=counta(a1:a10)
to get the number of "checked" cells in A1:A10

Or you can filter by blanks and non-blanks.