Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Method for inserting a check-mark/tick-box in Excel
It would be useful if I could have a box in Excel.
When I click on it I want it to turn from a square to square with an 'X' in the middle (or something similar) (the purpose is so that I can quickly 'tick' tasks off when I have done them) |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Method for inserting a check-mark/tick-box in Excel
Go to
View-- Toolbars---Then go to Commands... scroll down and click on Forms In the forms commands you should see the check box that you need. " wrote: It would be useful if I could have a box in Excel. When I click on it I want it to turn from a square to square with an 'X' in the middle (or something similar) (the purpose is so that I can quickly 'tick' tasks off when I have done them) |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Method for inserting a check-mark/tick-box in Excel
hi.
another way that i use... Format the cell(s) to font marlett. the letter A puts a check mark in the cell the letter R puts an X in the cell Regards FSt1 " wrote: It would be useful if I could have a box in Excel. When I click on it I want it to turn from a square to square with an 'X' in the middle (or something similar) (the purpose is so that I can quickly 'tick' tasks off when I have done them) |
#4
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel
|
|||
|
|||
Method for inserting a check-mark/tick-box in Excel
On 20-May-2007, ?B?RlN0MQ==?= wrote: When I click on it I want it to turn from a square to square with an 'X' in the middle (or something similar) (the purpose is so that I can quickly 'tick' tasks off when I have done them) I found a narrow RH column A1 downwards, conditionally formatted with a formula to change the cells colour, give me a column where gaps show unentered data; that is uncompleted tasks. =(A30) is the formula, and I set color to red for this condition. A3 being assigned a value is a completed task. I then copied and extended the format downwards through A1 to Ann. It's much easier to spot gaps in a black, red, or other colored line. Might be useful. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Short cut key to insert a tick or check mark? | Excel Discussion (Misc queries) | |||
In EXCEL - inserting box that toggles between a check mark & not. | Excel Worksheet Functions | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
Method for inserting a check-mark/tick-box in Excel | Excel Discussion (Misc queries) | |||
How can I put a tick/check mark in an Excel spreadsheet? | Excel Discussion (Misc queries) |