Adding an "X" or Check to a cell by clicking on the mouse

  • Thread starter Thread starter KAZ
  • Start date Start date
K

KAZ

Good morning,

I am attempting to create a spreadsheet within Excel 2003. I have partially
completed it and would like to have it so that when I click on the boxes an
"X" or a check mark appears. I have tried adding the check box but that is
not quite what I want (not that I've fully figured it out). I want the "X"
or check mark to fill the space with no wording. Can this be done...I am
pretty Excel illiterate and not the best with computers in general so I need
all the help that I can get.

Also, my list is very long and has headings in the first 2 rows that I need
to see when I get to the bottom so that I know which type and size boxes to
check. I have tried playing with the zoom button but to be able to see at
the bottom of the page I have to take it down to 25% and I am old and would
need a magnifying glass to see it...LOL

Any help would be very much appreciated!!

THANK YOU!!!!!!!! (-:
 
How about another alternative...

(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.
 
Back
Top