To strikethrough text in Excel, select the cell(s) and press Ctrl+5 on Windows (or Cmd+Shift+X on Mac). You can also use the ribbon: go to Home > Font group > click the Strikethrough button (the “ab” with a line through it). This applies a single line through the middle of the text, useful for marking completed tasks or showing deleted items without removing the data.
What Strikethrough Means in Excel
Strikethrough is a font effect that draws a horizontal line through the characters in a cell. Unlike deleting content, it keeps the original text visible and intact. In Excel, you can apply it to a whole cell, part of a cell’s text, or even to a range of cells at once. It’s commonly used for to-do lists, inventory tracking, or indicating that a value is no longer active but should remain in the record for auditing or reference.
How to Apply Strikethrough (Step-by-Step)
There are three main methods, each suited to different situations:
- Keyboard shortcut (fastest): Select the cell(s) and press Ctrl+5 (Windows) or Cmd+Shift+X (Mac). Press again to remove it.
- Ribbon button: Select the cell(s), go to Home > Font group, and click the Strikethrough icon (an “ab” with a line). This toggles the effect.
- Format Cells dialog: Right-click the cell, choose Format Cells (or press Ctrl+1), go to the Font tab, and check the Strikethrough checkbox. Click OK. This also lets you apply other effects like superscript or subscript at the same time.
To strike through only part of a cell’s text (e.g., a word within a sentence), double-click the cell to enter edit mode, select the specific characters with your mouse, then use any of the above methods. The line will only appear on the selected portion.
Keyboard Shortcuts for Strikethrough in Excel
The shortcut is the most efficient way once you memorize it:
- Windows:
Ctrl+5 - Mac:
Cmd+Shift+X(note: this is different from Word’s Mac shortcut, which isCmd+Shift+Xas well, but Excel uses its own).
If you prefer to use the mouse, you can add the Strikethrough button to the Quick Access Toolbar (QAT) for one-click access. To do this, click the down arrow at the end of the QAT, choose More Commands, select All Commands from the dropdown, scroll to Strikethrough, click Add, and then OK. This places the button at the top of the window, always visible.
Using Conditional Formatting for Automatic Strikethrough
You can make Excel apply strikethrough automatically based on a condition, such as when a checkbox is ticked or a cell contains a specific word. This is done with Conditional Formatting:
- Select the range of cells 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 a formula. For example, if you have a checkbox in column B (linked to cell B2), and you want to strikethrough A2 when B2 is TRUE, use:
=$B2=TRUE(adjust the row reference). - Click Format, go to the Font tab, check Strikethrough, and click OK.
- Click OK to apply the rule.
Now, when you check the box in column B, the corresponding text in column A gets a strikethrough automatically. This is a dynamic way to manage task lists without manual formatting.
Common Problems and How to Fix Them
Users often encounter these issues:
- Shortcut not working: If
Ctrl+5does nothing, check if you’re in cell edit mode (double-clicked) or if the Num Lock is interfering. Also, ensure you’re not using a laptop with a function key that needs to be pressed (sometimesFnis required). On some keyboards, the number row might be shared with F-keys. - Strikethrough not showing in print: The strikethrough is a font effect, so it should print. If it doesn’t, check your print settings—sometimes “Draft quality” or “Black and white” might hide it. Also, ensure the cell has enough width; a line might be cut off if the column is too narrow.
- Can’t apply to part of a cell: You must be in edit mode (double-click the cell) before selecting text. If you select the cell and apply, it formats the entire cell.
- Conditional formatting not working: Make sure the formula is correct and the relative references are right. For example, if your range starts at A2, the formula should refer to B2 (not B1).
Strikethrough vs. Other Formatting Options
Strikethrough is often confused with other ways to indicate deletion or completion:
- Delete vs. Strikethrough: Deleting removes the value entirely; strikethrough keeps it visible for reference. Use strikethrough when you need an audit trail or want to show what was changed.
- Font Color vs. Strikethrough: Graying out text (changing font color) is another visual cue, but it doesn’t imply a line. Some users prefer gray for “inactive” and strikethrough for “done”.
- Comments vs. Strikethrough: Comments are for notes, not for marking text as obsolete. Strikethrough directly alters the visual appearance of the content.
Frequently Asked Questions
How do I remove strikethrough from multiple cells at once?
Select all the cells that have strikethrough, then press Ctrl+5 (Windows) or Cmd+Shift+X (Mac) once. This toggles the effect off for the entire selection. Alternatively, open Format Cells (Ctrl+1) and uncheck the Strikethrough box.
Can I use strikethrough in Excel formulas?
No, strikethrough is purely a visual formatting attribute. It does not affect the value or any formula calculations. If you reference a cell with strikethrough, the formula will still use the underlying value (e.g., a number or text) as if the formatting weren’t there.
Does strikethrough work in Excel for the web?
Yes, Excel for the web supports strikethrough. Use the ribbon button (Home > Font > Strikethrough) or the keyboard shortcut Ctrl+5 (Windows) and Cmd+Shift+X (Mac). The Format Cells dialog is not available in the web version, but the button works.
How do I add a strikethrough button to the ribbon?
Excel’s ribbon doesn’t allow adding buttons to existing tabs by default, but you can add it to the Quick Access Toolbar as described above. Alternatively, you can create a custom group in the Home tab by right-clicking the ribbon, choosing Customize the Ribbon, and adding the Strikethrough command to a new group.
Why is my strikethrough line not straight or appears broken?
This can happen if the font you’re using has a decorative strikethrough or if the cell has a diagonal border that looks similar. Strikethrough is always a single horizontal line; if you see a slanted line, it’s likely a border. Check the cell’s borders (Home > Borders) and remove any diagonal lines.
Alternatives to Strikethrough in Excel
If strikethrough isn’t ideal for your use case, consider these alternatives:
- Checkboxes: Use form controls (Developer tab) or Insert > Checkbox (Excel 365) to mark tasks as done, and combine with conditional formatting to apply strikethrough automatically.
- Data Validation with Dropdown: Create a dropdown with “Done” and “Pending”, then use conditional formatting to strike through when “Done” is selected.
- Filter or Hide Rows: Instead of marking, you can filter out completed items or hide rows entirely, but this hides the data rather than showing it as struck through.
- Cell Fill Color: Use a light gray fill to indicate inactive items, which is less visually intrusive than a line.
Choose the method that best fits your workflow. Strikethrough is simple, but conditional formatting with checkboxes is more automated for large lists.
Related
- Excel Sheet for Employee Schedule: How to Build One
- Excel Sheet for Expense Tracking: How to Build One
- Excel Sheet Employee Schedule Template: How to Make One
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Conditional Formatting for Cell Fill ColorTo apply a conditional fill color in Excel for Microsoft 365 on Windows, select the cells, go to…
- Excel Date Month and Year Only: Format or Convert?To display an Excel date as month and year only, select the date cells, press Ctrl+1, choose Number…
- Access vs Excel: Pros, Cons, and Best Uses ComparedMicrosoft Access is usually the better choice for managing related records, enforcing consistent data entry, and supporting a…
- Google Sheets: Count Checked Checkboxes with COUNTIFTo count checked checkboxes in Google Sheets, use =COUNTIF(B2:B20,TRUE), replacing B2:B20 with the cells that contain your checkboxes.…
- Excel Shortcut to Switch Between Worksheet TabsIn Excel for Microsoft 365 on Windows, press Ctrl+Page Down to move to the next sheet tab, or…
- How to Share a Google Sheets Link and Control AccessTo share a Google Sheets link, open the sheet in a browser, select Share, choose who can access…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.