I am designing an excel spreadsheet where I would like to be able to enter a tick mark in certain cells.
I have looked under the 'Tools' and 'Customise' menus etc but cannot find under any of the options a tick symbol.I do not really want to have to draw a tick sign, but would prefer to be able to use perhaps a dedicated icon.
Navneet Ahluwalia
Replies (7)
Please login or register to join the discussion.
Do you actually want a check box?
From the View menu, click on Toolbars, then forms to display the forms toolbar.
Click on the tick, then select the area of the worksheet where you want the tickbox to appear.
Right click on the tickbox and select format control from the menu. In the control tab, select cell link, and click on the cell you want to affect.
When the box is ticked, the cell will be set to True (1), and when it is unticked, the cell value will be set to false (0).
(Don't try this if you are using a laptop with one of those touchpad mouse thingies!)
It's in the font
There are several ways of achieving this. One way is a follows:
From your Start menu select Accessories>Character Map
Set the Font to Symbols
Select the tick symbol, Copy, and Paste to your spreadsheet.
This will only show a tick if you set the font for that cell to Symbol, but there's no tick in Arial, Excel's standard font.
Once you have a tick in a cell, you can easilly copy this within your sheet.
Navneet
A tick (check sign) can be entered in Excel using Wingdings font and keyboard selection Alt+0252.
For practical use, enter into a suitable cell and use copy and paste into other cells as required as required. Alternatively, format the relevant cells in Wingdings font, so that the entry of the tick is effected by just using the keyboard selection above without the need to change font. I usually prefer to use a standard keyboard key, such as the letter "y" as an equivalent as its faster and easier.
If you want to do it properly you willl need to use a macro and visual basics.
To be able to trace symbols etc under different fonts, load the "Character Map" shortcut onto your desktop, quicklaunch toolbar or Microsoft Office shortcuts toolbar.
ticks in excel
If you go to insert - symbols, you will find a square root symbol that looks very like a tick. Insert it into one cell and then copy and paste as necessary.
Placing a tick
i do not no much about excel 2000 but if the font type MARLETT is available, change to this font type, and press the A button on your keyboard.see the result.