Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check box
I have created an Excel workbook listing all the CD's I'm suppose to have.
Now I want to put a check box at the beginnig of each row. If the box is checked, I have the CD and it is in its case. If blank, don't have cd or case. Once I've made my selections, and I can then choose the flagged rows to do an operation, say print them, sort, erase, or whatever. I've been able to make a single check box, but that is as far as I get. How do I get a check box in every row, and how do I reference the row as use, or don't use. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check box
I think you will find it easier to forget the checkbox and just use a cell.
You can enter a character in the cell. You can also use a variety of characters with different meanings. Then use AutoFilter to display the data based on the contents of the cells. Looup AutoFilter in Help if you don't know how to use it. -- Regards, OssieMac "PDStar" wrote: I have created an Excel workbook listing all the CD's I'm suppose to have. Now I want to put a check box at the beginnig of each row. If the box is checked, I have the CD and it is in its case. If blank, don't have cd or case. Once I've made my selections, and I can then choose the flagged rows to do an operation, say print them, sort, erase, or whatever. I've been able to make a single check box, but that is as far as I get. How do I get a check box in every row, and how do I reference the row as use, or don't use. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
check box
On Jan 4, 12:45�am, OssieMac
wrote: I think you will find it easier to forget the checkbox and just use a cell. You can enter a character in the cell. You can also use a variety of characters with different meanings. Then use AutoFilter to display the data based on the contents of the cells. Looup AutoFilter in Help if you don't know how to use it. -- Regards, OssieMac "PDStar" wrote: I have created an Excel workbook listing all the CD's I'm suppose to have. � Now I want to put a check box at the beginnig of each row. �If the box is checked, I have the CD and it is in its case. �If blank, don't have cd or case. Once I've made my selections, and I can then choose the flagged rows to do an operation, �say print them, sort, erase, or whatever. � I've been able to make a single check box, but that is as far as I get. �How do I get a check box in every row, and how do I reference the row �as use, or don't use If PDStar wants eye-candy then set the column's font to Monotype Sorts and enter a 4. this gives you a tick. Or an 8 to give you an X. Use Charater Map (a Windows OS program) to display the shapes you can get with Monotype Sorts (or any other font). Alan Lloyd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make the check mark boc bigger on the check box? | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do I check/uncheck ten or odd Checkboxes by click on one check | Excel Discussion (Misc queries) |