Microsoft Excel contains a variety of formatting options. Along with bold, italic, underline, you can also strikethrough in excel for highlighting the text.

There may be various reasons for using the strikethrough text. For example, you can use strikethrough to mark the tasks as completed, to highlight the particular text or a cell etc. If you don’t know how to do a strikethrough in excel, then read out the guide. However the procedure for making text strikethrough is just a few clicks step, but if you feel difficult to finding the options then the guide how to put line through text in excel will help you doing that.

Jan 21, 2014 - Want to apply a strikethrough effect to text in Excel? All you need is this simple keyboard shortcut.

Wanted to represent numerical data in an attractive manner? Along with that, you can also.

How to Strikethrough in Excel In this guide, along with strikethrough, we will also let you now how to remove strikethrough in excel. The procedure for how to cross words out in excel contains just a few steps. Read out the guide and learn how to strikethrough word in excel program. The steps are given below. Step 1: First of all, open the MS excel program to your system.

To do so, go to start menu and then select all programs. In the list of all programs, select MS office and then click on the programs MS excel. Step 2: Now type any word or sentence you want to strikethrough in excel.

For example, I have typed the word Strikethrough in Ms Excel in the first cell. Step 3: Now to strikethrough word, first, go to Format cells. This is the window where, you can change the font type, font style, font size and can do various changes in texts.

One of the effects you can add to the text is Strikethrough them. To go to the format cells, go to the menu bar and click on the arrow showing in the Font section. If you are unable to find the option, check out the image I have mentioned below. This is the screenshot, I grabbed for your better understanding. Step 4: As sooner you click on the arrow, a dialogue box format cells will pop up.

As I said above you can make various changes, add effects to the text, increase and decrease the size for the font via this dialogue box. Apart from that, you can also change the color of the font. For this, you will have to go to the color section. But since you are here to make the text strikethrough, go to the effects section. Check out the image I have mentioned below. I have marked the effects section with red.

Check it out. Step 5: Ok, now to make the text strikethrough, first, select the text, or cell and then mark the checkbox by clicking on it. And click on Ok. As sooner you click on ok, the word, sentence, or cell, you selected would be converted to the crossed.

And the crossed word would something like the image I have mentioned below. Check out that. This is how you can convert the text to the strikethrough in excel. Apart from this, you can also go to the format cell by right-clicking on the cells. For example, if you want to go to the format cell, then select any cell. Best free terminal emulator for mac. As sooner you do this, a dialogue box containing various options would appear.

One of the options would be Format Cells. Select that, and the same dialogue box that you saw in step 4. Now simply select the strikethrough option and click on ok. The word would be converted to the strikethrough text.

Let me tell you, these words can be converted into normal fonts as well if you want. For this, you will have to follow all the above procedure and then uncheck the box you checked to make the word strikethrough. Check out the image below.

After seeing the image, I don’t think you will face any difficulty while removing the strikethrough from words. This is how the strikethrough in excel is performed. I hope you have got all the steps clearly and have no more confusion regarding the procedure.

If you have any, you can ask us by dropping the comment in the comment section. We will try to reach out to you ad soon as possible. Now let’s check out However, there should not be nay doubt, since the procedure is very short and easy. But in case if you have any query, do drop the comment.

Now let’s check out strikethrough shortcut key for Ms excel. First of all, to make any word, sentence, text or cell, strikethrough, select that. Once you are done with the selection, press the key CTRL+SHIFT+F or CTRL+1. This shortcut would immediately launch the format cell dialogue box.

Once the dialogue box is open, I am sure you know what you have to do next. Simply select the strikethrough and click on ok. This was the shortcut for opening the format cell dialogue box.

There is an another shortcut which will help you quickly apply or remove strikethrough formatting without using the dialog box. And the shortcut is CTRL+5. All you will have to do is click on the cell, row or column you want to make strikethrough to. After selecting the text, you will have to press CTRL+5. And the word or cell would be immediately converted to the strikethrough. You can create your own handy strikethrough button as well if required. For this, follow the below steps.

Some of the objects in CamtasiaThe bundled objects include different styles of arrows and speech bubbles, and a square—but no circle. How to renew license for camtasia trial on mac free.