Also, right click on the check box and select Edit Text to delete the current text. You can now position your cursor over it and move it so it is centered where you want it. Once you've clicked on the Check Box form control, go to the cell where you want to insert the first check box and click and drag your cursor in that cell: (Note: If you don't have a Developer tab on your ribbon, go to File => Options => Customize Ribbon and make sure the box is checked next to Developer in the right hand column. Next, I'll position my cursor where I want to insert the first checkbox, then go to the Developer tab in the ribbon, click on the down arrow under 'Insert' and select the Check Box form control: The first step is to create the data range where we will list the tasks and insert the check boxes: Today we want to create a ToDo List in Excel and set it up so that when we check the box next to any of the tasks, it will format that task in red and strike it through like this: If you get a preview, look for the download arrow in the upper right hand corner. You can download the file here to follow along. S+=_Characters(char_index,1).Here's how you can create and keep track of your ToDo list in Excel using check boxes and conditional formatting: If(!(bool)_Characters(char_index,1).Font.Strikethrough ) just keep building the string with any char that is not strikethrough String CleanStrikethroughChars(Excel.Range range) now you can replace the cell value with the clean_string value String clean_string = CleanStrikethroughChars(Excel.Range range)

set a range equal to a single cell that has your text that needs cleanedĮxcel.Range range = worksheet.get_Range('somecell', 'somecell') open some workbook and get a spreadsheet.Įxcel.Application app = new Excel.Application() Įxcel.Workbook workbook = ('workbook name',Įxcel.Worksheet ws = (Excel.Worksheet)app.Sheets And, at the very least, it shows the C# syntax to detect strike-through as a starting point for you. I'm sure there is a more eloquent solution but this works. Not sure but I thought you were looking for a C# solution.

How to do strikethrough in excel 2010