How To X Out A Cell In Google Sheets

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

While some other spreadsheet programs such as Excel have features for cell borders that cross the cell diagonally, at the time of writing Google Sheets unfortunately has no such feature. It is possible, however, to insert an X floating over a cell, or use strikethrough text formatting to achieve a similar effect. This tutorial covers both topics

Use Strikethrough Formatting

If you simply want to illustrate that the contents of a cell is no longer relevant, completed, etc, using strikethrough formatting may be your best bet

Here’s how to apply strikethrough formatting to a cell:

Step 1

Select the cell or cells you want to X out

Step 2

Click on the Strikethrough icon in the toolbar

Step 3

All selected cells will be X’d out with strikethrough formatting

Insert an X Over a Cell

If the look of strikethrough formatting isn’t right for your purposes and you need diagonal lines to X out the cell, you can insert the X using Google Sheets’ Drawing feature

Step 1

Open the Insert and choose Drawing

Step 2

In the Drawing Editor, click on the Shape icon to open the Shape menu, then hover over the Equation submenu and choose the Multiply symbol

Step 3

Your cursor will turn into a black plus sign. Click and drag on the canvas to add the multiply symbol

Step 4

Click on the yellow diamond near the upper-left corner of the box and drag it up to make the lines of the X narrower

Step 5

If you like, set the Fill Color and Border Color using the menus in the toolbar

Step 6

When you’re done editing the X, click on Save and Close. The X will appear floating over the cells

Step 7

Position the X over the cell you want to X out, then use the square drag handles to resize it to fit the cell

Step 8

Your cell is X’d out


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to x out a cell in Google Sheets. Want more? Check out all the Google Sheets Tutorials.