Strike Through Text in Excel: Easy Guide

Excel is a powerful tool for data management and analysis, and sometimes you need to visually indicate that certain data is no longer relevant or has been completed. The strike-through formatting in Excel is perfect for this. Whether you're managing a to-do list, comparing data sets, or simply want to mark items for review, knowing how to apply a strike-through is an essential skill. This article will guide you through multiple, straightforward methods to achieve this, ensuring you can efficiently manage your spreadsheets.

Why Use Strike-Through Formatting?

Strike-through text in Excel adds a line through the middle of the content within a cell. This visual cue serves several purposes:

• Task Completion: Ideal for to-do lists, project plans, or any checklist where you want to mark items as finished.
• Data Comparison: When comparing two sets of data or a spreadsheet with a physical document, strike-through helps indicate that an item has been found or verified in both places.
• Irrelevant Data: Useful for marking data that is outdated, superseded, or no longer pertinent to your current analysis, without actually deleting it. This preserves the historical context.
• Review and Verification: It can signify that a particular entry has been reviewed, checked, or approved.

Unlike deleting or replacing data, strike-through preserves the original information while clearly indicating its status. This is particularly helpful when you need to print reports and visually track progress or changes.

Method 1: Using the Excel Ribbon

This is perhaps the most intuitive method for many users, as it involves navigating through the standard Excel formatting options. Here’s how:

1. Select the Cells: First, highlight the cell or range of cells containing the text or numbers you wish to strike through.
2. Access Format Cells: Navigate to the Home tab on the Excel ribbon. In the Font group, locate the small arrow in the bottom-right corner. Click this arrow to open the Format Cells dialog box.
3. Apply Strike-Through: Within the Format Cells dialog box, select the Font tab. Under the Effects section, you will find a checkbox labelled Strikethrough. Click this checkbox to select it.
4. Confirm: Click OK to apply the formatting. Your selected text will now have a line through it.

Tip: To remove the strike-through, simply repeat these steps and uncheck the Strikethrough box.

Method 2: Right-Click and Format Cells

This method offers a quicker way to access the same Format Cells dialog box, especially if your mouse cursor is already on the relevant cell.

1. Select the Cells: Highlight the cell(s) you want to format.
2. Right-Click: Right-click anywhere within the selected cells.
3. Choose Format Cells: From the context menu that appears, select Format Cells....
4. Apply Strike-Through: As in Method 1, go to the Font tab, find the Effects section, and check the Strikethrough box.
5. Confirm: Click OK.

This method is efficient and requires fewer clicks than navigating through the ribbon.

Method 3: Using the Keyboard Shortcut (Ctrl + 5)

For those who prefer keyboard shortcuts to speed up their workflow, Excel offers a direct way to apply strike-through formatting.

1. Select the Cells: Highlight the cell(s) you want to format.
2. Press the Shortcut: Press the key combination Ctrl + 5 on your keyboard.

Important Note: This shortcut works when using the number keys located above the letter keys on your keyboard. If you use the numeric keypad on the right side of your keyboard, Ctrl + 5 may perform a different function or no function at all. Ensure you are using the primary number row.

This is the fastest method once you commit it to memory.

Striking Through Only Part of a Cell's Content

Sometimes, you might only want to strike through a specific word or phrase within a cell, not the entire content. Excel allows for this granular control:

1. Select the Cell: Click on the cell containing the text you want to partially strike through.
2. Enter Edit Mode: You can enter edit mode in two ways:
   • Press the F2 key.
   • Double-click the cell.
   • Click into the Formula Bar at the top of the Excel window.
3. Highlight Specific Text: With the cursor in the cell or formula bar, use your mouse to select only the portion of the text you want to apply the strike-through to.
4. Apply Formatting: Now, use any of the methods described above (Ribbon, Right-Click, or Ctrl + 5) to apply the strike-through to your highlighted selection.

The strike-through will only appear on the text you specifically selected within the cell.

Impact on Formulas and Functions

It's crucial to understand how strike-through formatting affects your spreadsheet's calculations:

Strike-through is purely a visual formatting effect. It does not change the underlying value of the data in the cell. Therefore, if a cell with strike-through formatting contains a number used in a formula (e.g., SUM, AVERAGE), that number will still be included in the calculation. The strike-through line is simply an overlay and doesn't alter the cell's data content.

If you need a cell's value to be excluded from calculations, you must either delete the content or replace it with something that won't be recognised by the formula (like text, if the formula expects numbers). Strike-through is for visual indication, not for logical exclusion from calculations.

Comparison Table: Strike-Through Methods

Frequently Asked Questions (FAQs)

Q1: Can I change the colour of the strike-through line?

A: Yes. When you access the Format Cells dialog box (via Method 1 or 2), you can select a colour from the Font colour dropdown menu. This will change both the text colour and the strike-through line colour.

Q2: Does strike-through work in other Microsoft Office applications like Word or PowerPoint?

A: Yes, the process is very similar across the Microsoft Office suite. You can typically find the strike-through option within the Font settings in the Format Cells/Characters dialog box.

Q3: How do I remove a strike-through?

A: Simply select the cell(s) with the strike-through formatting, open the Format Cells dialog box, and uncheck the Strikethrough box under the Font tab. Alternatively, if you used the Ctrl + 5 shortcut, pressing it again on the selected cells will remove the formatting.

Q4: Will the strike-through appear when I print my Excel sheet?

A: Yes, strike-through formatting is a print setting. Any text formatted with a strike-through will appear with the line through it on a printed document.

Mastering the strike-through function in Excel can significantly enhance your ability to manage and present data effectively. By using these straightforward methods, you can clearly communicate the status of your information, from completed tasks to data that requires further attention.