Removing distracting text in Excel helps your spreadsheet stay clean and readable. Learning how to draw a line through text in Excel gives you a quick way to mark items as complete or deprecated without deleting data.
This guide walks through the steps and settings so you can apply, manage, and print strike through text consistently across your workbooks.
| Method | When to Use | Keyboard Shortcut | Impact on Cell |
|---|---|---|---|
| Format Cells Dialog | Precise control, batch formatting | Ctrl+1 then Alt+O+K | Applies to entire cell content |
| Quick Access Toolbar | Fast repeated use | Customizable shortcut | One-click toggle on selection |
| Keyboard Shortcut | Speed for power users | Ctrl+5 | Toggles strike through on/off |
| VBA Macro | Automation and large datasets | Assign to button or shortcut | Can apply based on rules |
Using Format Cells to Apply Line Through
The Format Cells dialog is the most reliable way to add a line through text in Excel. It gives you clear options and works on any Windows or Mac version of Excel.
Open the dialog by pressing Ctrl+1 after selecting the cells. Then move to the Font tab and check the Strikethrough box. This method is helpful when you want consistent formatting across many rows at once.
After you confirm, Excel draws a line through the center of each character in the selection. You can combine this with other font changes such as color or style while keeping the strike through active.
Adding Strike Through to the Quick Access Toolbar
Adding the strike through button to your Quick Access Toolbar saves time when you mark tasks or statuses frequently. The button appears next to the filename and works on the selected range without opening any dialog.
Customize the toolbar by clicking the drop-down arrow and choosing More Commands. Find Strikethrough in the list, add it, and then click OK. After that, you can select text and click the button to toggle the line on or off.
This approach is especially useful when you alternate between regular text and crossed-out entries during data cleanup sessions.
Using the Keyboard Shortcut Ctrl+5
Knowing the Ctrl+5 shortcut lets you draw a line through text in Excel without reaching for the mouse. It works the same as clicking the Strikethrough button but is faster once you memorize the combination.
Select the cell or range, press Ctrl+5, and Excel immediately applies or removes the line. This toggle behavior makes it easy to correct mistakes by pressing the same keys again.
If the shortcut does not respond, check your keyboard layout or remap it in Excel options to ensure it is active in your workbook.
Automating with VBA for Large Datasets
When you need to mark many rows based on rules, a VBA macro can automatically draw a line through text in Excel. This is helpful for status tracking, audits, or cleaning exports where manual formatting would take too long.
A simple macro loops through selected cells and toggles the Strikethrough property based on your criteria. You can assign the macro to a button or a keyboard shortcut for quick execution on demand.
Use caution with macros on shared files and keep backups, because automated changes can affect data integrity if the logic is not tested carefully.
Best Practices for Consistent Line Through Formatting
- Use keyboard shortcuts or the Quick Access Toolbar for speed during data cleanup.
- Apply format cells rules when you need uniform lines across large ranges.
- Document your macros if you automate strikethrough for team use.
- Test print settings to confirm lines appear clearly on paper.
- Avoid relying on strikethrough for critical calculations, treating it as a display aid only.
FAQ
Reader questions
Will applying a line through text in Excel affect my formulas or calculations?
No, drawing a line through text only changes the visual appearance. The cell value remains unchanged, so formulas and calculations continue to use the original data.
Can I print the strikethrough lines clearly on paper?
Yes, printed output includes the line through text by default. Ensure your printer settings do not use grayscale or draft mode that might fade the line, and consider using a thicker font if the line appears too light.
Why does the Ctrl+5 shortcut not work in my workbook?
This usually happens when the shortcut is overridden by another add-in or custom ribbon setting. Recheck your keyboard shortcuts in Excel options and, if needed, assign a different key combination to the Strikethrough command.
Can I use strikethrough in Excel Online or on mobile devices?
Excel Online supports strikethrough through the Format Cells dialog, but mobile apps may have limited or no visual effect. For full compatibility, use the desktop version of Excel when precise formatting is required.