How to Cross Out in Excel

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.

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.