HOW DO I CROSS OUT DATA IN A CELL WITHOUT DELETING IT?

D

David Biddulph

Firstly, the body of the message, not the subject line, is the space for
asking the question.

Secondly, please get your caps lock key repaired. Posting in upper case is
considered as shouting, and a breach of netiquette.

Thirdly, if what you want is to use a strikethrough format, then use Format/
Cells/ Font, and select strikethrough. You can either do this on the entire
content of the cell by selecting the cell before selecting Format, or it can
be applied to part of a cell's content by selecting the relevant part of the
text in the formula bar, then selecting Format.
 
J

Jon Jacobson

The above is not correct for the newest version of Excel if you're goal is to strikeout the whole box. (Directions are still correct if you want to strike out the text). To strike out the whole box click the box. Select "Format Cells", under "Borders" select one of the options for striking out a box(x, \ or /).
 

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

HOW DO i SET UP A REPORT USING INFO FROM A WORKSHEET LIS 1
HOW TO RETRIVED THE PREVIOUSLY SAVED VERSION? 1
How do i find the slope of a graph in excel? 1
How do I use the text content of a cell as a worksheet reference? 9
how do i set up a repeating meeting in outlook? 1
how do I create a link for both content and format of the cell? 1
how do I delete data in a cell without deleting formula? 2
How can I assign a value to a cell without putting a formula in it 4

Top