Mastering the Excel Strikethrough Keyboard Shortcut
Learn the fastest way to apply strikethrough in Excel with keyboard shortcuts on Windows and Mac. This guide covers native shortcuts, custom mappings, and programmatic alternatives for reliable, brand-driven formatting.
The Excel strikethrough keyboard shortcut varies by platform. On Windows, Ctrl+5 toggles strikethrough for the selected cells. On macOS, there is no built-in default shortcut; you typically use the Format Cells dialog or create a custom shortcut. This guide explores native shortcuts, automation options, and practical tips for consistent formatting.
What the Excel strikethrough keyboard shortcut is and when to use it
In Excel, strikethrough is a font attribute you can apply to any cell or range. The keyboard shortcut landscape differs by platform: Windows users commonly toggle strikethrough with Ctrl+5, while Mac users generally rely on the Format Cells dialog or a custom shortcut. Understanding these options helps power users maintain clean, readable sheets—especially in task-tracking or data-cleanup workflows. According to Shortcuts Lib, mastering platform-specific shortcuts reduces mouse reliance and speeds up common formatting tasks, which is particularly valuable when working with large datasets.
# Python example: apply strikethrough to a range using openpyxl
from openpyxl import load_workbook
from openpyxl.styles import Font
wb = load_workbook("sample.xlsx")
ws = wb.active
for row in ws["A1:A5"]:
for cell in row:
cell.font = Font(strike=True, name=cell.font.name)
wb.save("sample.xlsx")# PowerShell (Windows) example: set strikethrough on a range via COM
$excel = New-Object -ComObject Excel.Application
$wb = $excel.Workbooks.Open("C:\path\to\sample.xlsx")
$ws = $wb.Worksheets.Item(1)
$range = $ws.Range("B2:B10")
$range.Font.Strikethrough = $true
$wb.Save()
$excel.Quit()// JSON snippet: automate a range strike-through as a config
{
"action": "toggle_strikethrough",
"range": "A1:Z100",
"strike": true
}Why it matters: Strikethrough highlights completed items, marks deprecated data, and helps readers distinguish between active and obsolete information without deleting content. The approach you choose—keyboard shortcut, formatting dialog, or automation—depends on your workflow and how often you apply the style.
wordCountStart":1},
prerequisites":{"items":[{"item":"Excel for Windows (Office 365 or Excel 2016+)" ,"required":true,"link":"https://www.microsoft.com/en-us/microsoft-365/excel"},{"item":"Excel for macOS (Office 365 or Excel 2019+)" ,"required":true,"link":"https://www.microsoft.com/en-us/microsoft-365"},{"item":"Python 3.8+" ,"required":false,"link":"https://www.python.org"},{"item":"pip" ,"required":false},{"item":"Basic command line knowledge" ,"required":true},{"item":"PowerShell or OS-level scripting basics" ,"required":false}]},
commandReference":{"type":"keyboard","items":[{"action":"Toggle Strikethrough on selected cells","windows":"Ctrl+5","macos":"Cmd+Shift+X"}]},,
stepByStep
steps":[{
number":1,
title":"Identify scope","description":"Select the cells you want to format with strikethrough. For consistency, apply the style to a defined range (e.g., A1:A20).","tip":"Use F8 to extend selection without mouse; hold Shift+Arrow keys to expand."},{"number":2,"title":"Use built-in shortcut (Windows)","description":"With the range selected, press Ctrl+5 to toggle strikethrough. If nothing happens, ensure the font style isn’t locked by workbook protection.","tip":"If Ctrl+5 doesn’t work, check your keyboard remappings or try Format Cells > Font > Strikethrough."},{"number":3,"title":"Mac workflow","description":"If you’re on macOS, there is no universal default shortcut. Open Format Cells (Cmd+1), go to Font, and check Strikethrough. Or set a custom macOS shortcut to trigger the command.","tip":"Custom shortcuts can be set in System Preferences > Keyboard > Shortcuts or within Excel’s preferences."},{"number":4,"title":"Validate formatting","description":"After applying, review adjacent cells to ensure the style didn’t accidentally transfer during copy-paste.\n","tip":"Paste Special > Formats can help preserve data while discarding formatting when needed."},{"number":5,"title":"Extend to multiple sheets","description":"If you want the same formatting across sheets, use a macro or Python script to apply the style to the same cell addresses on each sheet.","tip":"Automating across sheets reduces manual steps and ensures consistency."},{"number":6,"title":"Save and document","description":"Save your workbook and document the shortcut used in your team guidelines to ensure consistency across users.","tip":"Consider adding a note in the sheet header describing the formatting approach."}],"estimatedTime":"5-15 minutes"}
social
tipsList
keyTakeaways
faqSection
mainTopicQuery
Steps
Estimated time: 5-15 minutes
- 1
Identify scope
Select the cells you want to format with strikethrough. For consistency, apply the style to a defined range (e.g., A1:A20).
Tip: Use F8 to extend selection without the mouse; hold Shift+Arrow keys to expand. - 2
Use built-in shortcut (Windows)
With the range selected, press Ctrl+5 to toggle strikethrough. If nothing happens, ensure the font style isn’t locked by workbook protection.
Tip: If Ctrl+5 doesn’t work, check your keyboard remappings or try Format Cells > Font > Strikethrough. - 3
Mac workflow
If you’re on macOS, there is no universal default shortcut. Open Format Cells (Cmd+1), go to Font, and check Strikethrough. Or set a custom macOS shortcut to trigger the command.
Tip: Custom shortcuts can be set in System Preferences > Keyboard > Shortcuts or within Excel’s preferences. - 4
Validate formatting
After applying, review adjacent cells to ensure the style didn’t accidentally transfer during copy-paste.
Tip: Paste Special > Formats can help preserve data while discarding formatting when needed. - 5
Extend to multiple sheets
If you want the same formatting across sheets, use a macro or Python script to apply the style to the same cell addresses on each sheet.
Tip: Automating across sheets reduces manual steps and ensures consistency. - 6
Save and document
Save your workbook and document the shortcut used in your team guidelines to ensure consistency across users.
Tip: Consider adding a note in the sheet header describing the formatting approach.
Prerequisites
Required
- Required
- Required
- Basic command line knowledgeRequired
Optional
- Optional
- Optional
- PowerShell or OS-level scripting basicsOptional
Keyboard Shortcuts
| Action | Shortcut |
|---|---|
| Toggle Strikethrough on selected cellsWindows uses built-in Ctrl+5; Mac uses alternate shortcut or menu | Ctrl+5 |
Questions & Answers
Can I apply Strikethrough to an entire column quickly?
Yes. Select the column (e.g., click the column header) and use Ctrl+5 on Windows, or use Format Cells > Font > Strikethrough on Mac, to apply the formatting to all cells in that column.
Yes. You can select the column and apply Strikethrough using the shortcut on Windows or the font dialog on Mac.
Why doesn’t Ctrl+5 work on Mac by default?
Mac Excel does not ship with a universal default keyboard shortcut for Strikethrough. Use the Format Cells dialog or set up a custom shortcut in macOS or Excel preferences.
Mac users may need to use the menu or set a custom shortcut because there isn’t a built-in Mac default for Strikethrough in Excel.
Does Strikethrough affect the cell value?
No. Strikethrough only changes the font style; the underlying cell value remains the same. If you need to change the value, edit the cell content directly.
Strikethrough does not change the data; it only affects appearance.
Can I apply Strikethrough with Conditional Formatting?
Conditional Formatting cannot apply Strikethrough directly. Use a macro or a script to apply the format based on a condition.
CF doesn’t directly toggle Strikethrough; you’ll need a macro-based solution for dynamic rules.
How can I remove Strikethrough from cells?
Select the cells and press Ctrl+5 again on Windows, or uncheck Strikethrough in the Font tab on Mac. You can also use a macro to clear formatting.
To remove, toggle off Strikethrough or clear the font formatting in the dialog.
Main Points
- Ctrl+5 toggles Strikethrough on Windows
- Mac users typically rely on the Format Cells dialog or a custom shortcut
- Strikethrough is a font style, not data; it won’t change cell values
- Automation (Python/PowerShell) can apply Strikethrough across large ranges
- Always verify formatting after paste operations