Mastering the Excel keyboard shortcut for strikethrough is one of the fastest ways to boost your spreadsheet efficiency, especially when you are reviewing data or tracking changes. While you can manually format text through the mouse-driven ribbon, a simple combination saves precious seconds and keeps your fingers on the keyboard where they belong.
What is the Strikethrough Shortcut in Excel?
The Excel keyboard shortcut for strikethrough applies a line through the center of the selected text, visually indicating deletion, completion, or obsolescence. This formatting tool is essential for creating to-do lists, marking inventory items as shipped, or showing that a value has been adjusted without deleting the original data. The default shortcut relies on the Ctrl key, but the exact keys depend on your operating system and version of Excel.
How to Apply Strikethrough on Windows
On Windows, the process is straightforward and consistent across most modern versions of Microsoft 365, Excel 2019, 2016, and later. You simply select the cell or range of cells you want to format and then press a specific combination. This method is significantly faster than navigating through the Home tab to click the strikethrough button in the Font group.
Windows Shortcut Keys
Ctrl + 5: This is the primary keyboard shortcut to toggle strikethrough on or off.
Alternative Method: Select the cell, press Ctrl , and then press Shift + X sequentially.
How to Apply Strikethrough on Mac
Mac users need to adjust their approach slightly because the standard Ctrl key is not used in the same way for formatting. Apple keyboards rely on the Command key, and Excel for Mac has its own set of optimized shortcuts that mirror the logic of macOS system standards.
Mac Shortcut Keys
Command + Shift + X: This is the dedicated keyboard shortcut for strikethrough on Mac systems.
Function Key: If you are using a Mac keyboard with function keys locked, you might need to press Fn + Command + Shift + X .
Customizing the Shortcut for Advanced Users
If you find the default keys uncomfortable or if you frequently switch between operating systems, you can customize the Excel keyboard shortcut for strikethrough. By modifying the Quick Access Toolbar or creating a custom macro, you can assign a different key combination that feels more natural to your typing rhythm.
Troubleshooting Common Issues
Sometimes the shortcut may not work due to simple oversights. The most common issue is that the "Strikethrough" font effect is already applied, and pressing the shortcut again will remove it, which might be confusing if you are expecting it to only apply. Additionally, if a cell is locked within a protected worksheet, the shortcut will be disabled until you unprotect the sheet. Ensure that your keyboard layout is correct and that the "Filter" or "Sticky Keys" settings on your operating system are not intercepting the command.
Efficiency in Practice
In a real-world scenario, such as auditing a budget sheet, the speed of this formatting becomes undeniable. Instead of reaching for the mouse, clicking through ribbons, and breaking your focus, you can select a row of outdated figures and strike them through in one fluid motion. This small change reduces friction in your workflow and helps maintain a consistent, professional appearance in your financial documents.
