Strike Through Text

mouchers

New Member
Joined
Sep 27, 2006
Messages
7
Just a simple one to get me started!

- How do I keep my text in a cell but strike a line through it? Although the text that is in the cell is no longer correct or relevant I don't want to delete the text that is in the cell but I do want to make the reader see that it is no longer correct or relevant by striking a single line through the text itself, how do I do this?

Any help is much appreciated!
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Format>Cells and on the Font tab under Effects check the "Strikethrough" box.

Best regards

Richard
 

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
The shortcut key for that is CTRL-5
 

Watch MrExcel Video

Forum statistics

Threads
1,113,850
Messages
5,544,660
Members
410,628
Latest member
mike5
Top