E esmani Oct 16, 2009 #1 Want to keep data entered, but show as not used or rejected by lining through the entry.
T T. Valko Oct 16, 2009 #2 Try this... Select the cell(s) in question Goto the menu Format>Cells>Font tab Select Strikethrough in the Effects group OK out
Try this... Select the cell(s) in question Goto the menu Format>Cells>Font tab Select Strikethrough in the Effects group OK out
R Ron@Buy Oct 16, 2009 #3 You could select the relevant cells then > Format Cells and select > Effects Strikethrough Click to expand... Although Conditional Formatting may be the way to go. What is the criteria for 'lining through' a cell? You can set up Conditional Formatting so when that criteria is met the cell(s) automatically line through. Supply more detail for a better answer
You could select the relevant cells then > Format Cells and select > Effects Strikethrough Click to expand... Although Conditional Formatting may be the way to go. What is the criteria for 'lining through' a cell? You can set up Conditional Formatting so when that criteria is met the cell(s) automatically line through. Supply more detail for a better answer
