Yes, Excel values can have strikethrough formatting. You can apply it manually with a keyboard shortcut, through the Format Cells dialog, or automatically with conditional formatting. Strikethrough is a character format that draws a line through the middle of text or numbers, commonly used to mark completed tasks or indicate deleted or obsolete data.
What Strikethrough Does in Excel
Strikethrough is a font effect that places a horizontal line through the center of a cell’s content. Unlike in Word, where strikethrough is a one-click ribbon button, Excel does not have a dedicated strikethrough button on the Home tab by default. The effect applies to the entire cell content or only to selected characters within the cell, depending on how you apply it. It is a cell format, so it travels with the cell when you copy or move it, and it can be combined with other formats like bold, italic, or color.
How to Apply Strikethrough Manually
There are three reliable ways to apply strikethrough manually. The fastest is the keyboard shortcut.
- Keyboard shortcut (Windows): Select the cell(s) or specific text within the formula bar, then press
Ctrl + 5. On a Mac, pressCmd + Shift + X. - Format Cells dialog: Select the cell(s), press
Ctrl + 1(Mac:Cmd + 1) to open Format Cells, go to the Font tab, and check the “Strikethrough” box under Effects. Click OK. - Quick Access Toolbar (optional): If you use strikethrough often, add it to the Quick Access Toolbar. Go to File > Options > Quick Access Toolbar (on Mac: Excel > Preferences > Ribbon & Toolbar), choose “Commands Not in the Ribbon,” find “Strikethrough,” add it, and click OK. This gives you a one-click button.
To remove strikethrough, repeat the same steps and uncheck the box, or press the shortcut again.
Applying Strikethrough to Part of a Cell
Sometimes you only want to strike through a word or number within a cell, not the entire content. Double-click the cell (or press F2) to enter edit mode, then select the specific characters with your mouse or by holding Shift and using arrow keys. Then apply the shortcut or use Format Cells. This works for text strings and numbers stored as text, but not for numeric values in general—Excel treats numbers as a single unit, so partial formatting is only possible if the cell is formatted as text or the number is part of a text string.
Using Conditional Formatting for Automatic Strikethrough
Conditional formatting lets you apply strikethrough automatically based on a rule, such as when a checkbox is ticked or a task is marked “Done.” For example, to strike through a task in A2 when B2 contains “Done”:
- Select the range you want to format (e.g., A2:A10).
- Go to Home > Conditional Formatting > New Rule.
- Choose “Use a formula to determine which cells to format.”
- Enter the formula:
=$B2="Done"(assuming the active cell is A2; adjust the row reference accordingly). - Click Format, go to the Font tab, check Strikethrough, and click OK twice.
Now any cell in the range gets strikethrough when the corresponding cell in column B says “Done.” This is a dynamic way to keep lists visually updated without manual formatting.
Common Problems and Misconceptions
A frequent issue is that strikethrough does not appear in the formula bar—it only shows in the cell itself. Another common mistake is expecting a keyboard shortcut like Ctrl + 5 to work on a Mac; it doesn’t. Also, some users think strikethrough is a cell property that can be toggled with a simple button, but Excel’s default ribbon lacks it. If strikethrough is not applying, check that the cell is not protected (if the sheet is protected, formatting may be locked). Also, conditional formatting rules can override manual formatting; if a rule exists, it takes precedence.
Strikethrough vs. Other Marking Methods
Strikethrough is one of several ways to mark data as obsolete or completed. Alternatives include:
- Font color: Graying out text to de-emphasize it without a line.
- Cell fill: Shading the cell background to indicate a status.
- Data validation: Using a dropdown to change status, often combined with conditional formatting.
- Comments/notes: Adding a note to explain why the value is struck through.
Strikethrough is best when you want to keep the original value visible but clearly mark it as inactive. It is widely used in task lists, inventory sheets, and revision histories.
Frequently Asked Questions
Does strikethrough affect calculations? No. Strikethrough is purely visual; the underlying value remains unchanged and is still used in formulas. If you need to exclude struck-through items from calculations, you must use a helper column or a formula that checks a status.
Can I use strikethrough in Excel for the web? Yes. In Excel for the web, the keyboard shortcut Ctrl + 5 (Windows) works, and you can also use Format Cells (right-click > Format Cells) to check the Strikethrough box. On Mac, Cmd + Shift + X works in the browser too.
Is there a way to strikethrough an entire row based on a cell value? Yes, use conditional formatting with a formula that references the row’s key cell. For example, to strike through rows where B2 is “Done”, select the entire range (e.g., A2:D10), create a new rule with formula =$B2="Done", and apply strikethrough. The dollar sign before the column letter locks the column, allowing the row to change.
Why doesn’t Ctrl+5 work on my Mac? The Ctrl+5 shortcut is Windows-specific. On Mac, use Cmd + Shift + X. Alternatively, you can use the Format Cells dialog on both platforms.
Can I remove strikethrough from only part of a cell? Yes, if the strikethrough was applied to only part of the text. Enter edit mode, select the specific characters, and then press the shortcut again or uncheck the box in Format Cells. If the entire cell is struck through, you must select the whole cell and remove it.
Final Tips for Using Strikethrough Effectively
Strikethrough is a simple but powerful tool when used consistently. For task lists, combine it with a checkbox (Insert > Symbols > Checkbox) and conditional formatting to auto-strike completed items. For shared workbooks, remember that strikethrough is a format, so it may be stripped if someone pastes as values or uses “Clear Formats.” Always save a backup before applying complex conditional formatting, and test on a small range first. With these methods, you can manage visual statuses efficiently without altering your data.
Related
- Excel Reverse Lookup with Multiple Criteria: How-To
- Excel Reverse Mortgage Calculator Spreadsheet
- Excel Repair Tool: What It Is & How to Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Undo Changes in Excel After Saving: Your Recovery OptionsIf the workbook is still open, press Ctrl+Z on Windows (Command+Z on Mac) to undo saved edits; saving…
- Excel Column Numbers: What A, Z, AA and XFD Mean in ExcelExcel columns have numerical positions even though their headings use letters: A is column 1, Z is 26,…
- Find Links to Other Workbooks in ExcelTo find links to other workbooks in Excel, check the Data tab’s Workbook Links command, then search formulas…
- Excel Shortcut Keys: Essential Shortcuts for Everyday WorkIf you mean important Excel shortcut keys, start with Ctrl+C to copy, Ctrl+V to paste, Ctrl+Z to undo,…
- Excel Text to Columns Shortcut: Windows and MacIn Excel for Microsoft 365 on Windows, press Alt+A, then E to open the Text to Columns wizard;…
- How to Create a Checkbox in Google Sheets (and Use It)To create a checkbox in Google Sheets in a web browser, select the cell or range where you…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.