How To Cross Out A Cell In Excel

Of course. Here is a complete pillar blog post on how to cross out a cell in Excel, written in a natural, human voice.

How to Cross Out a Cell in Excel: The Complete Guide to Strikethrough Formatting

Ever finished a spreadsheet and feel like it’s a mess of old data, completed tasks, and outdated figures? You know the look — a grid full of numbers and words where it’s impossible to tell what’s still active and what’s done. It’s visually exhausting.

That’s where crossing out a cell comes in. Here's the thing — it’s a simple trick, but it’s a something that matters for clarity. A clean strikethrough tells a story at a glance: this item is purchased, this task is finished, this price is obsolete. It keeps your data readable without the mess of deleting anything.

But here’s the thing most guides get wrong. There isn’t just one way to do it. And picking the wrong method for the job can lead to a spreadsheet that’s confusing or even broken. So, let’s fix that. This isn’t just a list of steps; it’s a practical guide to using strikethrough formatting the right way.

What Is "Crossing Out" in Excel? More Than Just a Line

First, let's be clear on what we're talking about. Now, "Crossing out" a cell in Excel means adding a horizontal line through the text or number inside it. The official term is strikethrough formatting*.

The key point is that the data isn’t deleted. The line is purely a visual indicator. You can still use it in formulas, sort by it, or filter it. And it’s still there. This distinction is crucial because it determines how and when* you should use it.

Think of it like a to-do list. Practically speaking, you don’t delete a task when you finish it; you check it off or cross it out. Because of that, the information remains for context, but its status is visually updated. That’s exactly what strikethrough does in your spreadsheets.

Why Bother? The Real Benefits of Strikethrough Formatting

You might think, "Why not just delete the cell?" That’s the first question, and it’s a good one. Here’s why strikethrough is often the better choice:

• Preserves Data Integrity: That crossed-out number might be part of a SUM formula, a historical record, or a reference for a future calculation. Deleting it breaks those links. Strikethrough keeps the data intact for your formulas while signaling its "inactive" status to your eyes.
• Provides Clear Visual Context: A sheet full of crossed-out items is a history log. It shows your work. You can see what was considered, what was completed, and what was changed. This is invaluable for tracking projects, budgets, or inventory.
• Works with Filtering and Sorting: You can still filter your list to show only active items, ignoring the crossed-out ones. The data is still there to be sorted and managed, it’s just visually set apart.

In short, strikethrough is for when you need to de-stress* data without removing* it.

How to Cross Out a Cell: The 4 Main Methods

Alright, let’s get to the practical stuff. Here are the primary ways to cross out a cell, from the quickest one-off method to the most powerful automated approach.

Method 1: The Keyboard Shortcut (Fastest for Single Cells)

This is your go-to for quickly crossing out one or two cells without taking your hands off the keyboard.

1. Select the cell or the text you want to cross out.
2. Press the keys: Alt + H + 1.

That’s it. A line appears through your text. It’s fast, intuitive, and perfect for when you’re in the flow of building your sheet.

Pro Tip:* You can also press Ctrl + 5 to open the Format Cells dialog box directly and check the "Strikethrough" box under the Font tab. It’s a few more keystrokes but works just as well.

Method 2: The Ribbon Button (Best for Visual Learners)

If you prefer using the mouse or are teaching someone else, the Ribbon is the most straightforward path.

1. Select the cell(s) you want to format.
2. Go to the Home tab on the Ribbon.
3. In the Font group, look for the button with the abc and a line through it. This is the Strikethrough button. (Its official name is "Strikethrough").
4. Click it.

Just like the shortcut, the line appears. This method is excellent because you can see the button and it’s easy to remember where it is.

Method 3: The Format Cells Dialog Box (For Precise Control)

Sometimes you need more than just a simple on/off switch. The Format Cells dialog box is the control center for all things cell formatting.

1. Select your cell(s).
2. Right-click and choose Format Cells… from the menu. Alternatively, press Ctrl + 1.
3. Go to the Font tab.
4. In the Font list, you’ll see a checkbox for Strikethrough. Check it.
5. Click OK.

Why use this method? But because this same dialog box is where you can change the font color, style, size, and effects all at once. If you want to cross out text and make it gray to really point out it’s inactive, this is the place to do it.

Method 4: Conditional Formatting (The Power User's Choice)

This is where things get powerful. Take this: any task with a "Completion Date" that is not blank should be crossed out. But what if you want cells to be crossed out automatically based on a condition? This is where Conditional Formatting shines.

Want to learn more? We recommend how do you find the of neutrons and where are protons neutrons and electrons located in an atom for further reading.

1. Select the range of cells you want to apply the rule to (e.g., A2:A100).
2. Go to the Home tab > Conditional Formatting > New Rule….
3. Choose Use a formula to determine which cells to format.
4. In the "Format values where this formula is true" box, enter a formula. For our task example, if column B is the "Completion Date," the formula would be: =B2<>"" (This means "if the cell in B2 is not empty.")
5. Click the Format button.
6. In the Format Cells dialog, go to the Font tab and check the Strikethrough box. You might also choose a lighter font color here.
7. Click OK to close the Format Cells box, then OK again to create the rule.

Now, whenever you enter a date in column B, the corresponding task in column A will automatically be crossed out. This is incredibly efficient for dynamic sheets.

Common Mistakes and What Most People Get Wrong

Now for the part that separates a casual user from an Excel pro. Here are the pitfalls to avoid.

• Mistake 1: Using the Border Line Instead of Strikethrough. The most common error. People draw a line through a cell using the Draw Border tool. This is wrong. A border line is part of the cell's frame, not the text inside it. It looks messy and doesn't move with the text if you change

the font size or column width. Strikethrough is a font property; it scales and moves perfectly with your content.

• Mistake 2: Applying It to the Whole Cell When You Only Need a Word. If a cell contains "Project Alpha — Complete," crossing out the entire cell destroys the context. Double-click the cell (or press F2) to enter edit mode, highlight only the specific word or phrase you want to strike through, and apply the shortcut (Ctrl + 5) or Format Cells dialog. This keeps the relevant data readable while visually flagging the specific change.

• Mistake 3: Confusing "Hidden" with "Crossed Out." Users sometimes change the font color to white (matching the background) to "hide" data. This is dangerous—data is still there, easily copied, printed, or revealed by a simple format change. Strikethrough is a visual status indicator*, not a security feature. If data truly needs to be removed, delete it; if it needs to be archived, move it to a separate sheet.

• Mistake 4: Forgetting the Mac Difference. If you switch between Windows and Mac, the muscle memory for Ctrl + 5 will fail you. On Mac, the shortcut is Cmd + Shift + X. There is no Ctrl + 1 equivalent for Format Cells on Mac either; it’s Cmd + 1. Keep a mental sticky note for this if you work cross-platform.

• Mistake 5: Overusing It in Printed Reports. On screen, a red strikethrough with a gray font is a clear "done" signal. On a black-and-white printout, it can just look like a smudgy mess. If you are preparing a sheet for physical distribution, consider using a "Status" column (e.g., "Done," "Voided") instead of—or in addition to—strikethrough formatting.

Pro Tips for a Cleaner Workflow

Combine with Color for Instant Scanning Don't rely on the line alone. In the Format Cells dialog (Method 3) or Conditional Formatting (Method 4), set the Font Color to a medium gray (like Gray - 25%* or Gray - 50%*) alongside the Strikethrough. This creates a visual hierarchy: active tasks are black and bold; completed tasks are gray and crossed out. Your brain processes the color difference faster than the line.

Use a Custom Number Format for "Soft" Deletes If you want a cell to display* as crossed out but retain its underlying numeric value for formulas, use a Custom Number Format.

1. Press Ctrl + 1 > Number tab > Custom.
2. In the Type box, enter: 0;-0;0;@ (standard) but you cannot add strikethrough via number formats alone. Correction:* Number formats cannot apply strikethrough. This is a common myth. You must* use Conditional Formatting (Method 4) or VBA if you want the strikethrough to appear based on a value while keeping the cell calculable.

Add the "Strikethrough" Button to Your Quick Access Toolbar (QAT) If you use the Ribbon button (Method 2) frequently, right-click the Strikethrough button on the Home tab and select Add to Quick Access Toolbar. It will sit permanently at the very top of your Excel window (above the Ribbon), accessible via Alt + [Number Key] depending on its position. This is often faster than hunting for the Font group.

Conclusion

Strikethrough in Excel is deceptively simple. On the surface, it’s a single line through text. In practice, it is a versatile signaling system: a manual checkmark for ad-hoc edits (Ctrl + 5), a formatting staple for polished reports (Format Cells), and an automation engine for live dashboards (Conditional Formatting).

Mastering the shortcut gets the job done. Stop drawing borders through your cells. Mastering the context*—knowing when to strike a single word versus a whole row, when to pair it with gray font, and when to automate it—turns a formatting trick into a professional workflow standard. Start striking through with purpose.