How to Strikethrough in Excel?

Strikethrough is a highly useful formatting feature in Excel that allows you to cross out text in cells. It’s especially handy for checklists, marking items as complete. This guide will navigate you through various methods to apply strikethrough in Excel, ensuring your Excel assignment looks polished and professional.

 

Strikethrough is a text formatting option that draws a line through the middle of the text in a cell. It’s often used to indicate that a task is complete or to mark items that are no longer relevant without removing them from the cell. Let’s delve into how to apply, modify, and remove strikethrough formatting in Excel.

Basic Strikethrough Formatting in Excel

Using the Format Cells Dialog

1. Select the cell or range of cells you want to apply strikethrough to.
2. Press Ctrl + 1 to open the Format Cells dialog.
3. Go to the Font tab.
4. Under Effects, check the Strikethrough box and click OK.

Utilizing Excel’s Ribbon

Excel’s Ribbon interface provides a quick and convenient way to access various formatting options, including strikethrough. To apply strikethrough using the Ribbon, first, highlight the text you want to cross out in the selected cell. Then, go to the “Home” tab in the Excel Ribbon. In the “Font” group, locate and click the “Strikethrough” button (it looks like an ‘ab’ with a horizontal line through it).

Employing Keyboard Shortcut

Excel offers keyboard shortcuts for frequently used formatting options, and strikethrough is no exception. To apply strikethrough using a keyboard shortcut, select the text you want to cross out in the cell, and then press “Ctrl + 5” on your keyboard to apply strikethrough instantly.

For Excel for Mac users, the keyboard shortcut is ⌘ + Shift + X.

In Excel Online, the process of applying strikethrough is slightly different as some features might not be available. To add strikethrough in Excel Online, first, select the cell you want to format. Then, go to the “Home” tab and in the “Font” group, click the Strikethrough button.

Do you want to add strikethrough to the Quick Access Toolbar? Here’s how:

1. Click the small arrow in the Quick Access Toolbar.
2. Choose ‘More Commands’.
3. From the ‘Choose commands from’ drop-down, select ‘All Commands’.
4. Scroll down and select ‘Strikethrough’.
5. Click ‘Add’ and then ‘OK’.

You can now use the Strikethrough button from the Quick Access Toolbar to cross out text in Excel.

Conditional Formatting with Strikethrough

Excel allows you to apply strikethrough automatically based on cell values using conditional formatting. This can be helpful for creating dynamic checklists or to-do lists. To use conditional formatting with strikethrough, first, select the cells you want to format. Then, go to the “Home” tab, click “Conditional Formatting” in the Styles group. Choose “New Rule,” and select “Use a formula to determine which cells to format.” Enter the formula that represents the condition for the strikethrough. Click the “Format” button, check the “Strikethrough” option under Effects, and click OK.

Your strikethrough formatting will now be applied automatically based on the cell values.

How to Remove Strikethrough in Excel

Removing strikethrough is as simple as applying it. To remove strikethrough, first, select the cell with the strikethrough you want to remove. Then, go to the “Home” tab and click the Strikethrough button again to deactivate it. Alternatively, you can use the Format Cells dialog (Ctrl + 1) and uncheck the Strikethrough option.

If you have applied strikethrough using conditional formatting, you can remove it by clearing the rules. To do this, select the cells with conditional formatting, go to the “Home” tab, click on “Conditional Formatting,” and choose “Clear Rules” from the menu.

Tips for Efficiently Using Strikethrough in Excel

• Use keyboard shortcuts for a faster way to apply or remove strikethrough.
• Add the strikethrough button to the Quick Access Toolbar if you use it frequently.
• Use conditional formatting for dynamic strikethrough based on cell values.

Summary

Strikethrough in Excel is a versatile tool that helps in various scenarios such as creating to-do lists or marking items as complete. With shortcuts, conditional formatting, and Quick Access Toolbar customization, using strikethrough becomes an even more powerful and efficient task. Whether you are using Excel on Windows, Mac, or online, understanding and utilizing the strikethrough formatting will surely add to your Excel proficiency.

You can find more STEM Guides in our designated category here at A*Help!

FAQ

Related

A*Help Insights - sign up for our Newsletter

Sign up

Thanks for signing up!

Something went wrong. Please try again later.

Follow us on Reddit for more insights and updates.