Adding an "X" or Check to a cell by clicking on the mouse
Without using a checkbox form (which it sounds like you don't want to use)
you will need to somehow enter the data into a cell. However, if you want to
just use the mouse, there are options.
Select the cells that you want to place the marks into. Under Data -
Validation, select List from the first box. In the input box, enter your
character (in this case, X)
Ok out.
Now, click on your cell, click on dropdown, and you can place an X into the
cell.
Alternate: If you want a checkmark (in appearance) format the cell to have a
font of Wingdings 2, and use P as your character.
Your latter question is much easier. W/o playing with the zoom feature,
select row 3. Then, goto Window - freeze pane. Voila!
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"KAZ" wrote:
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!!!!!!!! (-:
|