How to Strikethrough in Excel?

MS Office applications like Microsoft Word, Excel, and Google Docs are indispensable tools for millions of users worldwide. They enable the efficient creation of documents, spreadsheets, presentations, and emails. One feature that is particularly helpful when working on these applications is Strikethrough.

Strikethrough is an essential feature that indicates corrections or changes in a Word document or Excel spreadsheet. Striking through text in Microsoft Excel is easy. In this blog, we will cover how to use strikethrough in MS Excel.

Content

• Add Strikethrough Formatting from the Home Tab
• Strikethrough Format Keyboard Shortcut
• Add Strikethrough with the Quick Access Toolbar
• Apply Partial Strikethrough Formatting to a Cell
• Remove Strikethrough Formatting

Add Strikethrough Formatting from the Home Tab

To add strikethrough formatting -

• Select the cell or range of cells to which you would like to add strikethrough formatting.
• Go to the Home tab.
• Spot the Font section in the lower right corner. Click it. This will open the Format Cells dialog box.

• Go to the Font tab. Check the Strikethrough option.

• Press OK. 
• Adding strikethrough formatting.
• Your text will now have a strikethrough format.

Strikethrough Format Keyboard Shortcut

The fastest and simplest way to cross out text in Microsoft Excel is by using a keyboard shortcut. This shortcut works in all Office 365 applications, including Word and PowerPoint.

Open the Microsoft Excel spreadsheet and click on the cell where you want to apply the Strikethrough.

• On Windows, press Ctrl + 5. You can also use Ctrl + Z to undo the action.

• On Mac, press Command + Shift + X.

The selected text will now have a line through it. To remove the Strikethrough, press the same key combination again.

Explore these online degree programmes–

Online MBA Programmes	Online BTech Programmes
Online MSc Programmes	Online MTech Programmes

Add Strikethrough with the Quick Access Toolbar

For people who prefer to use the mouse over keyboard shortcuts, there is a faster way than using the Format Cells menu. You can add this to the quick action toolbar, so it's always a one-click process to add Strikethrough.

• Right-click anywhere on the Quick Access Toolbar and select Customize Quick Access Toolbar.

• Select All Commands from the drop-down menu.
• Scroll down and select Strikethrough from the list of available commands.
• Press the Add button to add this to your Quick Access Toolbar.
• Press the OK button to close the menu.

• The strikethrough format will now be visible in the Quick Access Toolbar. This command is now prominently available whenever you need to apply strikethrough formatting.

Apply Partial Strikethrough Formatting to a Cell

Select a cell, and then select some of the text in the formal bar to which you want to apply strikethrough formatting.

With the text selected within the formula bar, you can use any of the methods above to apply the Strikethrough to only the selected portion.

Remove Strikethrough Formatting

• Removing any strikethrough formatting in your text is as easy as applying it.
• Select the cells from which you want to remove formatting, and you can use any of these methods.
• Uncheck the Strikethrough option in the Format Cells menu.
• Press the keyboard shortcut Ctrl + 5.
• Press the Strikethrough command from the quick access toolbar.