How do I line through data entered in an Excel worksheet without .

  • Thread starter Thread starter esmani
  • Start date Start date
E

esmani

Want to keep data entered, but show as not used or rejected by lining through
the entry.
 
Try this...

Select the cell(s) in question
Goto the menu Format>Cells>Font tab
Select Strikethrough in the Effects group
OK out
 
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 must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fixed decimal places in Excel 4
Lock out data entry in a cell 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Adding a new template spread sheet on the first day of a new month 1
How do I enter in a missed line of info into Excell? 1
Finding replicate data accidentally entered into a worksheet 1
How do I have a linked cell auto-size to fit the linked data? 2
How to delete Blank lines in excel workbook? 2

Back
Top