Excel Strikethrough : Different Methods

 

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.

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

Excel Strikethrough Different Method

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.

Strikethrough - Learn from The SUAB.

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.

Strikethrough - Learn from The SUAB.

Step No. 3

Now, click to the “Font” tab

Strikethrough - Learn from The SUAB

Step No. 4

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

Strikethrough - Learn from The SUAB

Step No. 5

Then, click OK,

Strikethrough - Learn from The SUAB

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.

Strikethrough - Learn from The SUAB.

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.

Strikethrough - Learn from The SUAB-

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.

Strikethrough - Learn from The SUAB-

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.

Strikethrough - Learn from The SUAB

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.

Strikethrough - Learn from The SUAB

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.

Strikethrough - Learn from The SUAB-

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.

Step No. 1

In QAT, there is small dropdown arrow, just click on it which is at the top-left corner of the Excel window.

Strikethrough - Learn from The SUAB-

 

Step No. 2

Select ‘More Commands’ from the list of dropdown.

Strikethrough - Learn from The SUAB.

 

Step No. 3

Select the option ‘All Commands’ from ‘Choose commands from’ dropdown, in excel options window.

Strikethrough - Learn from The SUAB.

Step No. 4

Now, Scroll down, choose the ‘Strikethrough’ command and hit the “Add >” button in order to add in QAT.

Strikethrough - Learn from The SUAB.

Step No. 5

Select ‘OK” for save the setting.

Strikethrough - Learn from The SUAB.

At this instant, you’ll be able basically select the cells containing the strikethrough and click Strikethrough icon in QAT for applying the formatting.

Strikethrough - Learn from The SUAB.

 

By practicing these technique of strikethrough, you will be well expert to do the various organizational data and you will be expert in the presentation skills while using the excel.

1 thought on “Excel Strikethrough : Different Methods”

Leave a comment