Crossing out text in Excel provides a clear visual indicator for revisions, completed tasks, or deprecated information without deleting data. This simple formatting technique maintains an audit trail while keeping the original content visible for reference. While not a native button exists, several efficient methods allow users to apply this style consistently across spreadsheets.
Using the Keyboard Shortcut
The fastest way to apply a line through text involves a quick keyboard combination that triggers the strikethrough format. This method requires selecting the specific cell or range of cells before executing the command. It is the preferred option for users who prioritize speed and perform this action frequently.
Step-by-Step Shortcut Process
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.
Release both keys to instantly apply or remove the strikethrough effect.
Utilizing the Ribbon Menu
For users who rely on mouse navigation or prefer visual interfaces, the Excel Ribbon offers a dedicated option for this formatting need. This panel houses the necessary tools within the Home tab, making it accessible without memorizing key combinations. The interface clearly indicates the active formatting state, helping users avoid accidental applications.
Ribbon Navigation Steps
Click on the cell containing the text you want to alter.
Navigate to the Home tab located at the top of the window.
Locate the Font group within the ribbon.
Click the Strikethrough button, which appears as an underlined AB icon.
Customizing the Quick Access Toolbar
Since the shortcut key is not immediately visible, frequent users often benefit from adding the command to the Quick Access Toolbar. This customization places the function a single click away, streamlining the workflow significantly. By bypassing the Ribbon, you can maintain focus on your data without unnecessary navigation.
Toolbar Configuration
Click the downward arrow next to the Quick Access Toolbar at the top left.
Select More Commands from the dropdown menu.
In the Excel Options dialog, choose All Commands from the list.
Scroll down and select Strikethrough , then click Add .
Click OK to save the changes.
Format Cells Dialog Method
Users who wish to adjust multiple formatting attributes simultaneously can utilize the Format Cells dialog. This method provides a centralized location for font styles, including the line style. It is particularly useful when combining bold, italic, and strikethrough effects.
Dialog Box Procedure
Right-click on the desired cell or range and choose Format Cells .
In the Format Cells window, navigate to the Font tab.
Check the box labeled Strikethrough under the Effects section.
Click OK to confirm the formatting change.
Conditional Strikethrough Implementation
Advanced users can automate the formatting based on specific cell values, creating dynamic spreadsheets that visually update with data changes. This technique is invaluable for inventory management or task tracking, where manual updates become inefficient. The rule relies on comparing cell content against predefined criteria.
