Removing a line through text in Excel is a common formatting need, whether you are tracking completed tasks, highlighting deprecated data, or creating a visual comparison. The process is straightforward, yet offers several methods to suit different workflows and versions of the software.
Using the Keyboard Shortcut
The fastest way to apply a strike-through is by using a keyboard shortcut, which bypasses the ribbon interface entirely. This method requires you to add the command to your Quick Access Toolbar first, as it is not available by default in the core Excel function set.
Customizing the Quick Access Toolbar
To enable the shortcut, you must first customize the toolbar to include the strike-through icon. This initial setup ensures you can execute the command instantly without navigating through multiple menus.
Right-click on the Quick Access Toolbar, usually located at the top left of the Excel window.
Select "More Commands" from the dropdown menu to open the configuration panel.
Choose "All Commands" from the list of options in the left column.
Scroll down to find "Strikethrough" and select it.
Click "Add" and then "OK" to integrate the tool into your toolbar.
Applying the Format via the Ribbon
Once the command is available, you can apply the line by selecting the cell or range of cells and clicking the new icon on the Quick Access Toolbar. Alternatively, you can access the format menu through the main ribbon if you prefer not to customize the toolbar.
Utilizing the Format Cells Dialog
For users who need to adjust multiple formatting options at once, the Format Cells dialog provides a centralized location. This method is particularly useful when combining the strike-through with other font adjustments like color or style.
Press Ctrl + 1 on your keyboard to open the Format Cells dialog box.
Navigate to the "Font" tab within the window.
Locate the "Effects" section and check the box next to "Strikethrough".
Click "OK" to apply the formatting to your selected cells.
Using a Formulaic Approach
Advanced users might prefer to integrate the line directly into the cell content using specific syntax. This technique is helpful when the strike-through needs to be dynamic or linked to the value of another cell.
CHAR Function Method
By leveraging the CHAR function, you can insert the Unicode character for a strike-through line. This allows the line to appear as part of the cell's text string rather than a static format override.
=CHAR(1023) "Your Text"
Conditional Striking Through Data
Excel's Conditional Formatting feature allows you to automate the process, applying the line only when specific criteria are met. This is essential for maintaining large datasets where manual formatting is impractical.
Setting the Rules
To automate, you define the conditions that trigger the format. For instance, you can automatically strike through a row when a status changes to "Completed".
Select the range of cells you want to format.
Go to the "Home" tab and click "Conditional Formatting".
Choose "New Rule" and then "Use a formula to determine which cells to format".
Enter a formula such as =B2="Done" where B2 is the status cell.
Click the "Format" button, navigate to the "Font" tab, and check "Strikethrough".
