How To Do Strikethrough in Excel by Multiple Techniques

In Excel, strikethrough is drawing a line through the numbers or words, to illustrate, they have changed or erased, but remain there visible. There are numerous ways for you to apply strikethrough. You’ll do this effortlessly by employing a uncommon shortcut on your keyboard. This makes it speedy and simple for everybody to use this option, whether they know Excel exceptionally well or not well.

In excel, before apply strikethrough shortcut, you must do the following.

Select the cell in the excel sheet, where you need to apply shortcut.
then, Press Ctrl+5 for applying the strikethrough.
In case, you’re a Mac user, press the ‘Command+Shift+X’ combination.

To utilize this include well, it’s critical to memorize the shortcut and to know when to utilize strikethrough. This will assist you create superior quality sheets.

Learning these shortcut will assist you build up sheets that clearly show any changes or upgrades you need to share with others.

What is Excel Strikethrough

Excel strikethrough is actually a formatting tool, that would apply the cross lines over the text inside the cell content. These highlights are especially valuable for highlighting things that have been completed, negated, are not pertinent.

Not at all like Microsoft Word, there are no strikethrough designing buttons in Microsoft Excel. Likwise, you must take after a long prepare to apply the strikethrough formate in excel.

How to Apply Strikethrough by an Option

To apply strikethrough in Excel, you have to use the ‘Microsoft’. Take after the steps given below.

Step No. 1

In the cell, where you need to apply the strikethrough organize. For instance, if you required crossing out the cell text i.e. the due date in the cell B3, select the cell B3.

Step No. 2

Right click on the specified cell and press ‘Format Cells’ or keyboard shortcut, hit the button ‘Ctrl +1’ to open the format cell dialog box.

Step No. 3

Now, click to the “Font” tab

Step No. 4

Sub heading of ‘Effects’, there is check the box, after the option of ‘Strikethrough’.

Step No. 5

Then, click OK,

If your required to remove the strikethrough formatting, you may remove the strikethrough by repeating the steps same as above and uncheck the box in format cell dialog box.

Its fundamental to know that you may apply the strikethrough designing to a complete cell, a particular text of the cell, or may the range of cells, which is totally depends the requirements.

Whereas, in excel ribbon, there is no button directly to apply the Strikethrough formatting but it is vital to know the easy Microsoft used for Strikethrough Content.

Shortcut Key for Strikethrough Text

A speedy and helpful method to apply the strikethrough format to the cell or text is by keyboard shortcuts. In this area, we are going cover Strikethrough shortcut keys for Mac and Windows user.

1) Shortcut Key of Strikethrough for Windows User

The windows user will follow the following steps for applying the Strikethrough formatting in cell or specified text.

Step No. 1 for Windows User

Select the range of cells or single cell merely need to apply the strikethrough. For instance, if you required the strikethrough to the text, ranging from B3 to B4, select as below.

In case, you want to apply strikethrough to numerous cells that are place in different rows and column then hold the ‘Ctrl’ for the selection of cells. You can select a particular portion of the Microsoft content which you want to strikethrough it.

For instance, in case you need to strike out the location in cell D2, select as it were that location. To choose a part of content in a cell, double-click and enter the edit mode and just select it.

Step No. 2 for Windows User

Now, press from keyboard, Microsoft. The strikethrough formatting will applied to the whole content of cell and if have chosen the portion of the content, the strikethrough format will applied on the selected part.

2) Shortcut Key of Strikethrough for Mac User

The Mac user will follow the below step for strikethrough option.

Step No. 1 for Mac User

If you need to apply the strikethrough option to cell extend B3 to B4, select as below.

For instance, you want to apply strikethrough to numerous cells that are place in different rows and column then hold the ‘Command’ for the selection of cells. You can select a particular portion of the cell content which you want to strikethrough it.

For instance, in case you need to strike out the location in cell D2, select as it were that location. To choose a part of content in a cell, double-click and enter the edit mode and just select it.

Step No. 2 for Windows User

Now, press from keyboard, Command + Shift + X. The strikethrough formatting will applied to the whole content of cell and if have chosen the portion of the content, the strikethrough format will applied on the selected part.

Adding Strikethrough Icon at Quick Access Toolbar

While working on the feature of Strikethrough and adding icon at the quick access toolbar, will help you adding and removing strikethrough conveniently. The Quick access toolbar can be customized to incorporate the strikethrough format icon, which permits more productive approach to apply strikethrough to your text. This strategy is specially valuable for those who look for a streamlined grip in Excel or lean toward using their mouse for organizing their work than using keyboard shortcuts. For adding icon to toolbar, track the steps below.