How to X (Cross) Out a Cell in Excel & Google Sheets

This tutorial demonstrates how to X out a cell in Excel and Google Sheets.

 

 

Apply Strikethrough – Format Cells

To strikethrough means to put a line through a value in a cell. There are a few different ways to do this, and one of them uses cell formatting.

1. First, select the cell or range of cells (here, cell A2) where you want to apply strikethrough formatting and right-click on it. In the drop-down menu, click on Format Cells.

 

 

2. The Format Cells window appears. Click on Font then under Effects, check Strikethrough and click OK.

 

 

As a result, the value in the selected cell is crossed out.

 

 

Apply Strikethrough – Shortcut

The fastest way to apply strikethrough is to use shortcut CTRL + 5. The shortcut can be used on an entire cell, a certain part of the cell, or a range of cells.

To apply strikethrough on the entire cell, select the cell and press CTRL + 5.

 

 

To apply strikethrough on a part of the cell value, double-click on the cell and select the text you want to X out, then press CTRL + 5.

 

 

To apply strikethrough on a range of cells, select the range and press CTRL + 5 .

 

 

Draw a Line Through a Cell

To X out a cell, you could also draw a line.

1. First, in the Ribbon, click on Insert. Then click on the Shapes button and choose Line.

 

 

2. Then draw the line to cover the cell value.

 

 

Note that if you are applying this line on the entire cell, in order to make the line aligned, you can activate the Snap to Grid option.

 

 

As a result, the value will be crossed out.

 

 

Apply Strikethrough in Google Sheets

To apply strikethrough on a cell, select a cell or range of cells (in this example cell A1). In the Menu, click on Format and from the drop-down menu, choose Strikethrough.

 

 

As a result, the value in the selected cell will be crossed out.

 

 

Add Strikethrough Using the Toolbar – Google Sheets

You can also use the Strikethrough shortcut from the Toolbar.

First, select the cell or range of cells you want to format with strikethrough (here, A1:A3). Then click on the Strikethrough button in the formatting section of the Toolbar’s second row.

 

 

As a result, all selected cells will be formatted with a strikethrough.