Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]() 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 | |
|
|
![]() |
||||
Thread | Forum | |||
X axis tick mark over label | Charts and Charting in Excel | |||
Tick Mark Label Line Wrap | Charts and Charting in Excel | |||
How can I put a tick/check mark in an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Can tick mark labels be flipped about axis? | Charts and Charting in Excel | |||
tick mark labels | Charts and Charting in Excel |