How to Strikethrough in Excel

Excel’s strikethrough formatting is beneficial for marking deleted or outdated cell entries while keeping them visible. It’s commonly used to track changes and completed tasks, maintaining a clear record of spreadsheet edits over time. It’s often used for tracking changes or completed tasks, visually indicating data deletions or invalidations while providing a clear record for spreadsheet reviews or edits. This feature visually highlights data that has been removed or is no longer valid, making it helpful in reviewing and editing spreadsheets.

In Excel, a strikethrough is a formatting option that adds a horizontal line through text or numbers in a cell, indicating irrelevance, deletion, or completion. It can be applied to cells or text parts, commonly used for tracking changes or marking completed tasks. This tool, also crucial in word processing, crosses out entered content in Excel cells.

Excel offers seven ways to strike through cell contents for deletion or irrelevance.

Note:

Open Microsoft Excel spreadsheet

Open Microsoft Excel from Windows start icon that appears on the left bottom corner of your device screen. Open a file where you want to work.

Open Microsoft Excel spreadsheet

Step 1: Open Excel and Enter the data into the sheet

Step 2: Select the cells

Step 3: Press “Ctrl+ 5”

Step 4: Preview Results

Ultimately, this technique will strike through selected cell contents.

Step 1: Select the cells

Choose cells with the data for Formatting.

Step 2: Click the Format Cells

Click the Format Cells box button to access formatting options.

Step 3: Tap to Strikethrough

Click Strikethrough in the Format Cells box under Effects to apply the Formatting.

Step 4: Save the workbook

Save the workbook, then reopen it in Excel for the web to view changes.

Use Quick Access Toolbar (QAT) for Excel strikethrough, and follow the steps:

Step 1: Go to the access toolbar

Access Excel’s dropdown from the top left.

Step 2: Choose “More Commands”

Choose “More Commands” and select “All Commands” to add “Strikethrough.”

Step 3: Tab to “OK”

Tab to “OK” to confirm the changes.

Step 4: Apply Strikethrough

Apply Strikethrough: Choose the text and click the Strikethrough option on the Quick Access Toolbar.

Use Ribbon for Excel strikethrough; follow the steps:

Step 1: Choose the Text in Excel

Click on the cells with the text for Strikethrough.

Step 2: Access the Ribbon

Visit the “Home” tab in Excel Ribbon.

Step 3: Locate the Font Group

Find the “Font” group in the Home tab, where font formatting options reside.

Step 4: Add Strikethrough

To add Strikethrough, find and click the “Strikethrough” button in the Font group. It is often symbolized by an “AB” with a line through it.

Use Dynamic Conditional Formatting for Excel strikethrough.

Step 1: Choose cells

Click or drag to select the cell range for Strikethrough.

Step 2: Open Conditional Formatting

Access Conditional Formatting using the “Home” tab in Excel Ribbon. Choose “New Rule” to open the dialog.

Step 3: Set rule

Open for using a formula to decide cell formatting. Enter the strikethrough condition formula (e.g., =A1<0). Click “Format” to customize.

Step 4: Apply Strikethrough

Go to the “Font” tab in Format Cells and tick “Strikethrough.”

Step 5: Verify Strikethrough

Click “OK” in the Formatting Rule dialog. Verify that the selected cells now display the Formatting that has been applied.

Use Visual Basic Editor for Excel strikethrough, follow the steps:

Step 1: Choose the Developer tab

Select the “Command button” under the Developer tab in Excel.

Step 2: Change the “Properties”

Create the command button, and change the “Properties”.

Step 3: Select the view code option

After closing the dialog box, click “View Code” in the “Controls” button.

Step 4: Insert VBA Code

Select “Strikethrough,” then paste the VBA code.

Step 5: Apply Strikethrough

Save the .xlsm file; selected cells show Strikethrough.

To remove Excel strikethrough, use various methods.

Step 1: Remove Strikethrough

To remove strikethrough formatting,

Step 2: Tap the shortcut

Press Ctrl + 5 again after using a shortcut or cell format. Alternatively, access the Format Cells dialog (Ctrl + 1)

Step 3: Tap to uncheck

Uncheck the Strikethrough box.

Step1: Select the cell

Open Microsoft Excel and select cells for Formatting.

Step 2: Click on Conditional Formatting

Open Conditional Formatting Rules Manager in Excel.

Step 3: Set the rules

Choose the rule with Strikethrough, and delete the rule.

Step 4: Verify strikethrough formatting

Verify the removal of strikethrough formatting.

In Excel, a strikethrough is a formatting option used to draw a line through text in cells, indicating information is outdated but visible. Apply it to cells or ranges for various uses, like in financial models, task lists, or checklists. Evaluate its purpose in your spreadsheet: if it enhances clarity, it’s beneficial; however, excessive or improper use can confuse readers. Consider the audience and context when using formatting tools like Strikethrough in Excel.

What is the shortcut key for Strikethrough in Excel?

Ctrl + 5 is the Excel key for Strikethrough on Mac and Windows. To apply the strikethrough effect on Windows, open the format dialogue box and click Ctrl + 1.

How do you strikethrough in Excel without text?

Microsoft Excel provides a useful keyboard shortcut for Strikethrough: Ctrl + 5 on Windows and Command + Shift + X on Mac. Hit these key combinations to instantaneously apply the strikethrough format to the specified cells.

Does Strikethrough affect formulas in Excel?

No, Strikethrough formatting in Excel is purely visual and doesn’t impact cell formulas or data; it’s a formatting option only.