Mastering text formatting in spreadsheets is essential for clear data presentation, and knowing how to add strikethrough in Excel is a fundamental skill for any user. This visual cue is perfect for marking obsolete information, indicating completed tasks, or showing price changes without deleting the original content. While the option is hidden deeper than bold or italic, applying it is straightforward once you understand the locations.
Using the Keyboard Shortcut
The fastest method to apply a line through text is universally recognized across Windows applications. You simply select the cell or range of cells you want to format and press a specific combination of keys. This action triggers the strikethrough style instantly, saving you time when you are working quickly.
Quick Steps for the Shortcut
Select the cell or text string you wish to modify.
Press and hold the Ctrl key on your keyboard.
While holding Ctrl , press the 5 key on the numeric keypad.
Note that this requires the numeric keypad, not the numbers row above the letters. If you are using a compact keyboard or laptop, you may need to activate the NumLock or use the dedicated Application key if available.
Accessing the Format Cells Dialog
For users who prefer visual navigation or need to adjust multiple properties at once, the Format Cells dialog is the ideal tool. This window provides a comprehensive list of all available formatting options, including alignment, protection, and number formatting. It serves as a centralized hub for fine-tuning how your data appears.
Step-by-Step Guide
Right-click on the cell or range you want to format.
Select Format Cells from the context menu.
In the dialog box, navigate to the Font tab.
Check the box labeled Strikethrough .
Click OK to apply the change.
Using the Ribbon Menu
The Excel Ribbon provides a direct button for this formatting need, making it easily accessible without diving into menus. This method is particularly useful for mouse users who prefer point-and-click interactions over memorizing keyboard combinations. The icon is clearly labeled to represent the action it performs.
How to Apply via Ribbon
Highlight the cell or text you want to modify.
Navigate to the Home tab on the Ribbon.
Locate the Font group.
Click the Strikethrough button, which looks like an underlined ABC with a horizontal line running through the center.
Adding Strikethrough to the Quick Access Toolbar
To optimize your workflow, you can add the strikethrough button directly to your Quick Access Toolbar. This customization places the command at your fingertips, eliminating the need to navigate the Ribbon for frequent tasks. It is a small change that significantly speeds up repetitive formatting.
Customization Process
Right-click the strikethrough button in the Home tab’s Font group and select Add to Quick Access Toolbar . Alternatively, you can access the Excel Options menu to manage all your frequently used commands in one centralized location. Once added, the icon will appear in the top left corner of your window for instant use.
