Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default HOW DO I CROSS OUT DATA IN A CELL WITHOUT DELETING IT?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default 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
...



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
...




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I merge two cells without deleting data from the cell? Batmans_Wife Excel Discussion (Misc queries) 50 April 3rd 23 10:54 AM
Deleting all data in cell if value starts with 3 particular letter Mary Ann Excel Discussion (Misc queries) 6 November 6th 07 05:34 PM
Deleting cell data without deleting formula Tom Hall Excel Discussion (Misc queries) 4 October 29th 06 04:07 PM
Moving cell data and separating or deleting jonhunt Excel Worksheet Functions 6 June 13th 06 07:11 PM
How can I make cell data automatically shift up when deleting Orangepegs Excel Discussion (Misc queries) 4 February 26th 05 11:11 PM


All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"