Pinterest Pixel

The Ultimate Guide to Excel Strikethrough Text

Learn to apply & manage Excel strikethrough for efficient data handling. Explore keyboard shortcuts, conditional formatting &... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

The Ultimate Guide to Excel Strikethrough Text | MyExcelOnline The Ultimate Guide to Excel Strikethrough Text | MyExcelOnline

Excel Strikethrough is a formatting feature that allows you to draw a line through text or numbers within a cell. This is particularly useful for indicating that certain tasks are completed or that specific data entries are no longer relevant. Strikethrough helps maintain a record of past information without deleting it, making it easier to track changes and updates within your spreadsheets. In this article, we will cover different ways to apply strikethrough in Microsoft Excel.

Key Takeaways:

  • Purpose and Utility: Strikethrough helps in visually marking completed or irrelevant items without removing them from the spreadsheet, aiding in better data management and historical tracking.
  • Keyboard Shortcuts: Apply Strikethrough quickly using keyboard shortcuts – Ctrl + 5 on Windows and Command + Shift + X on Mac – for efficient editing.
  • Ribbon Customization: Customize your Excel Ribbon to include a Strikethrough button for easy access, allowing you to apply this formatting with a single click.
  • Conditional Formatting: Use conditional formatting to automate Strikethrough based on specific criteria, saving time and ensuring consistency in your data presentation.
  • Partial Strikethrough and Removal: Strikethrough can be applied to partial text within a cell for detailed editing, and it can be removed without affecting the underlying data, preserving data integrity.

 

Striking Out: A Quick Overview

What Is Excel Strikethrough?

Excel Strikethrough is like your virtual highlighter but instead of making things stand out, it helps you indicate the completion or irrelevance of tasks and items directly onto your data sheet. Imagine having a to-do list and drawing a line through each item you’ve completed – that’s exactly what the Strikethrough feature does to your text or numbers in Excel cells.

Excel Strikethrough

Significance of Using Strikethrough in Spreadsheets

In the realm of spreadsheets, where each cell’s content carries meaning, Strikethrough plays a vital role. It’s a visual indicator to quickly communicate the status of tasks, financial entries, or any point of data without removing historical entries.

For instance, in budget tracking, a Strikethrough lets you see both original estimates and alterations at a glance. It’s an excellent way to maintain a clean yet informative spreadsheet, as it fosters a non-destructive editing environment where nothing gets lost in the shuffle.

 

The Strikethrough Toolkit

Method 1: Keyboard Shortcuts for Speedy Editing

If you’re all about efficiency and speed, keyboard shortcuts are your best friend in Excel. To swiftly apply the Strikethrough format to your data, simply select your desired text, cell, or cell range and press Ctrl + 5 on Windows.

Mac users, on the other hand, should use the Command + Shift + X combo. Voilà! The selected data now appears crossed out. And guess what? If you change your mind or hit the shortcut by mistake, just press the same keys again to undo the Strikethrough.

STEP 1: Select the cell you want to strikethrough.

Excel Strikethrough

STEP 2: Now, hold ‘CTRL+5‘. You will then see a strikethrough in the selected cell ‘A2‘.

Excel Strikethrough

It’s that easy – no menus, no extra clicks.

Method 2: Ribbon Customization for Easy Access

For those who prefer mouse clicks over keyboard shortcuts, customizing your Excel Ribbon is a lifesaver. By adding a Strikethrough button to the Ribbon, you can mark items as complete with a single click, any time you need. Let’s walk through the simple process:

STEP 1: Right-click anywhere on the Ribbon and choose ‘Customize the Ribbon’.

Excel Strikethrough

STEP 2: Choose the ‘Home’ tab and click ‘New Group’ to create a custom group for your button.

Excel Strikethrough

STEP 3: Name your group something like ‘My Formats’ for easy recognition.

Excel Strikethrough

STEP 4: With your new group selected, choose ‘Commands Not in the Ribbon’ from the drop-down menu.

Excel Strikethrough

STEP 5: Scroll to find ‘Strikethrough,’ select it, and click ‘Add.’

Excel Strikethrough

STEP 6: Hit ‘OK’ to save your changes, and presto! Your Strikethrough button is ready for action on the Ribbon.

Excel Strikethrough

RESULT: Now, anytime your spreadsheets need a little tidying, your trusty Strikethrough tool is just a click away.

Excel Strikethrough

 

Manual versus Automatic: Applying Strikethrough

Step-by-Step for Manual Application

Applying Strikethrough to your text manually in Excel may seem like a task, but with these easy steps, you’ll be crossing off items in no time:

STEP 1: Start by selecting the cell or range where you want to apply Strikethrough.

Excel Strikethrough

STEP 2: Right-click the selection and select ‘Format Cells’ from the context menu.

Excel Strikethrough

STEP 3: In the ‘Format Cells’ dialog box, go to the ‘Font’ tab.

Excel Strikethrough

STEP 4: Look for the Strikethrough checkbox and click on it to mark it.

Excel Strikethrough

STEP 5: Finish by clicking ‘OK,’ and you will see the Strikethrough effect applied to your selection.

Excel Strikethrough

RESULT: This manual method gives you the control to apply this format to specific items, maintaining a versatile and organized sheet.

Excel Strikethrough

Automatic Strikethrough with Conditional Formatting

Harness the power of Excel’s conditional formatting to apply a Strikethrough automatically based on certain conditions – it’s like setting your spreadsheet on autopilot. Follow these steps to create your own rule:

STEP 1: First, select the range of cells you wish to apply automatic Strikethrough to.

Excel Strikethrough

STEP 2: Head over to the ‘Home’ tab and locate ‘Conditional Formatting’ in the ‘Styles’ group. Click it and select ‘New Rule.’

Excel Strikethrough

STEP 3: In the ‘New Formatting Rule’ dialog, choose ‘Use a formula to determine which cells to format.’

Excel Strikethrough

STEP 4: Enter the condition formula in the box that reads “Format values where this formula is true.” For example, typing =B3="Completed" will apply Strikethrough to any cell in your selected range that contains the word “done.” After setting the formula, click ‘Format’.

Excel Strikethrough

STEP 5: Now move to the ‘Font’ tab, and choose ‘Strikethrough.’ Confirm all your actions with ‘OK,’ and watch as cells automatically get struck through when they meet the conditions you specified.

Excel Strikethrough

STEP 6: Now you can preview the strikethrough formatting selected by you, then click “OK”.

Excel Strikethrough

RESULT: Automatic Strikethrough ensures your spreadsheet remains up-to-date with minimal manual intervention, saving you time for more important tasks.

Excel Strikethrough

 

Special Cases and Tips

Handling Partial Strikethroughs in a Cell

Sometimes, you might want to apply a Strikethrough to just a fragment of the text in a cell, rather than the entire cell content. This precision editing can be done through a few additional steps:

STEP 1: Double-click the cell to enable editing mode or press F2 after selecting the cell.

Excel Strikethrough

STEP 2: Highlight only the portion of text you want to strike through by dragging your mouse over it or using the Shift + arrow keys.

Excel Strikethrough

STEP 3: With the text selected, either right-click and choose ‘Format Cells’ or use the familiar shortcut; ‘Ctrl + 1’.

Excel Strikethrough

STEP 4: In the ‘Format Cells’ dialog box, tick the ‘Strikethrough’ checkbox under the ‘Font’ tab & Click ‘OK’.

Excel Strikethrough

RESULT: You will see that only the selected part of the text has the Strikethrough effect.

Excel Strikethrough

This little trick lets you bring attention to specific parts of your data while keeping the rest untouched and clearly visible.

Gaining Efficiency with Format Painter

To replicate Strikethrough formatting across different parts of your spreadsheet with finesse, the Format Painter tool is your go-to feature. Here’s how to use it:

STEP 1: Select the cell that has the Strikethrough format you want to copy.

Excel Strikethrough

STEP 2: Click the ‘Format Painter’ icon in the ‘Home’ tab (it looks like a paintbrush).

Excel Strikethrough

STEP 3: Then, simply select the cells where you’d like to apply the same formatting.

Excel Strikethrough

 

Removing Strikethrough Without Losing Data Integrity

Purging Strikethrough formatting from your Excel cells without disturbing the actual data is straightforward. If your data’s integrity is key, follow these simple steps:

STEP 1: Click on the cell or select the range where you want to remove Strikethrough.

Excel Strikethrough

STEP 2: Press Ctrl + 1 to open the ‘Format Cells’ dialog box, or right-click and choose ‘Format Cells’ from the context menu.

Excel Strikethrough

STEP 3: Under the ‘Font’ tab, you’ll find the Strikethrough option. Uncheck the box next to ‘Strikethrough.’ Hit ‘OK’.

Excel Strikethrough

RESULT: And just like that, the Strikethrough is gone, leaving your data untouched and readable.

Excel Strikethrough

For those using conditional formatting,

STEP 1: Navigate to the ‘Home’ tab.

Excel Strikethrough

STEP 2: Choose ‘Conditional Formatting,’ then ‘Manage Rules.’

Excel Strikethrough

STEP 3: Delete the rule associated with Strikethrough.

Excel Strikethrough

RESULT: By unwinding the format carefully, you maintain the sanctity of your data, ensuring its accuracy and reliability for any future analysis.

Excel Strikethrough

 

Frequently Asked Questions

How to do strikethrough text in Excel?

To do strikethrough text in Excel, select the cells you want to format and then use either the keyboard shortcut Ctrl + 5 or go to the Home tab, find the ‘Font’ group, and click the Strikethrough button. These actions will cross out the text in the selected cells immediately.

What is the shortcut for strikethrough text?

The shortcut for applying strikethrough text in Excel is Ctrl + 5 on a Windows computer and Command + Shift + X on a Mac. Just select your text and press these keys to toggle the strikethrough on and off.

Can Strikethrough Be Sorted or Filtered within Excel?

Strikethrough itself cannot be directly used as a criterion for sorting or filtering in Excel. If you need to sort or filter by strikethrough, you would have to use a workaround, like adding a helper column to indicate the status of cells that are struck through and then filter based on that column.

Are There Any Strikethrough Accessibility Features for Excel Online Users?

Excel Online users have access to most of the standard accessibility features found in Excel, including strikethrough formatting. However, they currently cannot select non-adjacent cells to apply strikethrough directly. Users must format cells individually or use keyboard shortcuts. Additionally, assistive technologies like screen readers can read out formatted text, including strikethrough, to aid users with visual impairments.

Where is the font strikethrough option?

In Excel, the strikethrough option is found in the ‘Font’ group under the ‘Home’ tab. To access it, click the small diagonal arrow at the bottom right of the ‘Font’ group, which opens the ‘Format Cells’ dialog box. Alternatively, you can press Ctrl + 1. In the dialog box, go to the ‘Font’ tab and check the ‘Strikethrough’ option.

If you like this Excel tip, please share it
The Ultimate Guide to Excel Strikethrough Text | MyExcelOnline The Ultimate Guide to Excel Strikethrough Text | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  How to Apply Strikethrough in Excel - 3 Easy Methods

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...