Just because the data in your Excel spreadsheet isn't what you want it to be doesn't mean you don't want it to be visible. Whatever your reason for needing to cross out cell contents, Excel's strikethrough feature lets you put this effect into action. In a couple of clicks, you'll see your cells showing small, neat lines through the characters within.
Video of the Day
Step
Launch Excel 2013. Open an existing spreadsheet or create a new one and type in some text to apply the strikethrough effect.
Step
Right-click the cursor into the cell to cross out and click "Format Cells" from the fly-out menu. The Format Cells window opens.
Step
Click a check mark into the Strikethrough box under the Effects section.
Step
Click the "OK" button and you are returned to the spreadsheet with the cross-out appearing.
Step
Click the "Format Painter" button, the small yellow paintbrush in the Clipboard section of the Home tab's ribbon which stores your last formatting action in Excel's memory.
Step
Move to another cell you want to cross out. Click into the cell and the Strikethrough effect is applied.
