See all How-To Articles

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

In this tutorial, you will learn how to X out a cell in Excel and Google Sheets.

 

x out cell 5

 

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 Format Cells.

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

 

x out cell 1

 

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

 

x out cell 3

 

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

 

x out cell 4

 

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 wanted cell and press the CTRL + 5 shortcut.

 

x out cell 11

 

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

 

x out cell 10

 

To apply strikethrough on a range of cells, select the range and press the CTRL + 5 shortcut.
x out cell 12

 

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.

 

x out cell 6

 

2. After that, just draw the line to cover the cell value.

 

x out cell 7

 

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.

 

x out cell 14

 

As a result, the value will be crossed out.

 

x out cell 18

 

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 Toolbar, click on Format and from the drop-down menu, choose Strikethrough.

 

x out cell 15

 

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

 

x out cell 16

 

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 the strikethrough (in this example, A1:A3) and then click on the Strikethrough button in the formatting section of the Toolbar’s second row.

 

x out cell 21

 

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

 

x out cell 22