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.
Wanted to represent numerical data in an attractive manner? Here is how to create charts in Excel. Along with that, you can also create the Bar graph in Excel.
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. 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.
Step 1: First, click on the icon placed at the right of the Quick Access Toolbar to open the list I have mentioned below.
Step 2: In the list, select the option More Commands.
Step 3: Once done, select the option Commands Not in the Ribbon. You will find the option in the Choose commands from drop-down list.
Now simply scrolls down until you find Strikethrough and select it. Once done, click the Add button, and then OK. And you are done.
Excel has a lot to explore and you don’t need any technical skills for that. You can easily manage your data using MS Excel. Here is some basic of excel that you should know for using excel. You can add numbers in excel, you can easily divide the numbers in Excel. For finding the average, you should see how to calculate Average in Excel. Using these basics, you can do a lot of work on Excel.
So this is how we apply strikethrough to the text in MS Excel. If you liked and enjoyed the guide share it on social media platforms.