Finding strikethrough in Excel is a common need for anyone managing data, whether you are tracking completed tasks, flagging obsolete inventory, or simply formatting text for clarity. While the function is easy to spot once you know where to look, it is hidden within the ribbon and the right-click context menu, requiring a specific sequence to activate.
Locating the Strikethrough Tool in the Ribbon
The most direct method to apply a line through text involves the main toolbar at the top of your spreadsheet. This area houses the majority of Excel’s formatting commands, but the specific icon is not immediately visible and requires accessing a menu.
Using the Home Tab Font Group
To find strikethrough in the Excel ribbon, you must first navigate to the Home tab. Within the Home tab, locate the Font group, which is typically situated on the left side of the ribbon interface. The commands here control the visual appearance of your text, but the Strikethrough option is nested within a dialogue box launcher rather than sitting as a standalone button.
Look for a small arrow icon in the bottom-right corner of the Font group; this is the Format Cells dialogue box launcher. Clicking this arrow opens a comprehensive menu where you can adjust font styles, sizes, colors, and borders. It is within this specific window that the checkbox for applying a line through your text resides.
Accessing Strikethrough via Keyboard Shortcuts
For users who prioritize speed and efficiency, memorizing a keyboard shortcut is the fastest way to find strikethrough in Excel. This method bypasses the ribbon entirely and allows you to apply the format with a simple combination of keys, saving valuable time during data entry or editing sessions.
The standard shortcut involves holding the Control key and pressing the number five key (Ctrl+5). This command toggles the strikethrough formatting on and off instantly. If you are using a Mac, the equivalent command is Command+Shift+X, providing the same functionality for Apple users.
Utilizing the Right-Click Context Menu
Another reliable way to access this feature is through the right-click context menu, which provides a streamlined list of common formatting options without opening a separate dialogue box. This method is particularly useful for users who prefer a visual checklist of formatting styles directly beside their cursor.
To use this method, select the cell or range of text you wish to modify, right-click to open the menu, and look for the option labeled Strikethrough. Clicking this option applies the format immediately, making it one of the most intuitive ways to find and use this specific tool.
Customizing the Quick Access Toolbar
To ensure you can find strikethrough in Excel with a single click at any time, consider adding the command to your Quick Access Toolbar. This toolbar sits above the ribbon and houses your most frequently used functions, eliminating the need to navigate through multiple tabs.
By default, the toolbar includes Save, Undo, and Redo, but you can easily modify it to include the Strikethrough button. Click the downward arrow next to the toolbar, select "More Commands," and then add the command from the Popular Commands list. Once added, it remains available for every workbook you open.
Troubleshooting Common Issues
Occasionally, users may struggle to locate or apply the format, often because the cell is formatted as a formula or protected structure. If the right-click option appears greyed out, it is likely due to worksheet protection or merged cells preventing direct editing.
To resolve this, ensure the cell is not locked if the sheet is protected, or unmerge the cells if necessary. Understanding these limitations helps you find strikethrough in Excel without frustration, ensuring the formatting tool works exactly as intended.
