ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I CROSS OUT DATA IN A CELL WITHOUT DELETING IT? (https://www.excelbanter.com/excel-worksheet-functions/166060-how-do-i-cross-out-data-cell-without-deleting.html)

Wayno7734

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


David Biddulph[_2_]

HOW DO I CROSS OUT DATA IN A CELL WITHOUT DELETING IT?
 
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.
--
David Biddulph

"Wayno7734" wrote in message
...




Jon Jacobson

Firstly, the body of the message, not the subject line, is thespace for
 
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 /).

On Wednesday, November 14, 2007 11:53 AM Wayno773 wrote:





On Wednesday, November 14, 2007 12:19 PM David Biddulph wrote:


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.
--
David Biddulph

"Wayno7734" wrote in message
...






All times are GMT +1. The time now is 04:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com