Mastering the Excel keyboard shortcut for strikethrough helps you track completed tasks, revisions, and action items without leaving the keyboard. This small efficiency habit speeds up data entry and keeps your formatting consistent across large spreadsheets.
Below you can quickly see how the shortcut works on Windows and Mac, when it is most helpful, and how to control its behavior with common patterns such as double strike, range selection, and undo.
| Platform | Shortcut | Effect | When to Use |
|---|---|---|---|
| Windows | Ctrl + 5 | Toggles a line through selected text | Quickly mark checked items or old data |
| Mac | Command + Shift + X | Toggles a line through selected text | Same marking tasks on Mac keyboards |
| Excel Web | Alt + Shift + H then J | Applies or removes strikethrough in the ribbon path | When Ribbon is available and you prefer menu navigation |
| Touch Mode | Ribbon Home > Font > Strikethrough | Visual toggle when keyboard is not accessible | Tablets or compact layouts where shortcuts differ |
How to Apply Strikethrough Using the Shortcut
The Excel keyboard shortcut for strikethrough is designed for speed. By memorizing a single key combination, you avoid mouse navigation and keep your hands on the home row.
First, select the cell or range you want to format. On Windows, press Ctrl + 5. On Mac, press Command + Shift + X. Each press toggles the line on selected text, so you can easily undo the format by repeating the shortcut.
Use the Home ribbon only when the Ribbon is visible and you prefer an interface-driven workflow. However, the shortcut remains faster for repeated use, especially when you are marking long lists or versioned entries.
Selecting the Right Range Before Using the Shortcut
Applying the Excel keyboard shortcut for strikethrough to a whole range keeps your formatting consistent. Click the first cell, hold Shift, and click the last cell to highlight a block, then press the shortcut once.
For non-adjacent cells, hold Ctrl while clicking each cell, then apply the shortcut. This technique is powerful when you need precise control over which items are marked as completed or deprecated.
Avoid accidental formatting by checking the active cell address in the name box. If the range looks unexpected, press Ctrl + Z immediately to revert and try again with a cleaner selection.
Troubleshooting Common Issues with Strikethrough
Sometimes the shortcut appears to do nothing, often because cells are merged or protected. Merged cells can behave inconsistently, so consider using a table or structured layout instead.
Workbook protection or sheet protection can block the shortcut. Check the Review tab to see whether changes are allowed, and ensure the font settings for strikethrough are not overridden by a restrictive style.
Conditional formats and custom number formats do not add a visual line but can simulate deletion by changing font color. Combine them with the true strikethrough shortcut only when you want a strong visual distinction.
Keyboard, Platform, and Accessibility Considerations
On laptops, you may need to enable Function Lock or use the dedicated Home key row depending on your device model. Check your keyboard layout to confirm that the correct characters appear when you hold the modifier keys.
Screen readers recognize strikethrough formatting, but they may not always announce the change immediately. Test your setup by navigating through formatted cells and verifying that status messages reflect the updated appearance.
Keep a simple reference nearby until the motion feels natural. A small sticker on your monitor with Ctrl + 5 and Command + Shift + X can save time during the first days of practice.
Optimize Daily Workflows with Consistent Shortcut Use
Using the Excel keyboard shortcut for strikethrough regularly trains muscle memory and reduces formatting interruptions. Over time, marking tasks as complete becomes a fluid part of your data routine rather than a separate step.
Combine the shortcut with cell styles, number formats, and icons to build a clear visual language for status tracking. This approach keeps your sheets readable and makes handoffs smoother for team members who rely on quick cues.
- Select the cell or range you want to mark before using the shortcut
- Remember Windows key combination: Ctrl + 5
- Remember Mac key combination: Command + Shift + X
- Use the Home > Font menu only when the Ribbon is the preferred interface
- Check protection and merge settings if the shortcut behaves unexpectedly
- Test print previews to confirm strikethrough visibility on paper
- Practice selecting non-adjacent cells with Ctrl for precise marking
FAQ
Reader questions
Does the shortcut work the same for numbers and text in merged cells?
Yes, the Excel keyboard shortcut for strikethrough works on both numbers and text, but merged cells may not respond predictably. Use ranges of unmerged cells for reliable results.
Can I use this shortcut in printed output to show removed items?
Yes, strikethrough appears in printouts by default. If your printer settings hide faint lines, adjust the font weight or add a border to make the deletion line clearly visible on paper.
Will applying strikethrough through the shortcut affect filters and formulas?
No, the shortcut only changes display formatting. Filters still see the original value, and formulas that refer to the cell continue to use the underlying number or text unless they explicitly test for the visual style.
How can I quickly remove strikethrough from an entire column without manual selection?
Select the column by clicking the header, then press the same shortcut again. Because strikethrough is a toggle, repeating Ctrl + 5 or Command + Shift + X removes the line from every selected cell at once.