If the task is set to Completed, it is strikethrough by a line and if not, it will be the same as earlier. This dropdown list will contain two options: Completed and Not Completed. We will make a list of some tasks in a column and its corresponding column, we will create a dropdown list of the task status. In this example, we will use conditional formatting to strikethrough the cell data like the color formatting. Example 1: Strikethrough with conditional formatting We will show you an example of conditional formatting with strikethrough. It can be used to show the complete task in Excel. Till now, we have explained the strikethrough and how to apply it on Excel cells data. Now, you can directly perform strikethrough action from here. Step 5: See that the Strikethrough option is added in Quick Access Toolbar. Step 4: When the Strikethrough option is moved to the right side list, click the OK button to save the changes. Step 3: Scroll down the list, select Strikethrough command and click the Add button to move it to Excel ribbon. Step 2: A panel will open where choose Commands not in Ribbon in Choose command from field. Step 1: Click on the small icon in Quick Access Toolbar and then click the More Commands in the list.
Next time, whenever you need you can directly use it from there. So, it is best to add the strikethrough option (icon) in Excel Quick Access Toolbar (QAT). Add Strikethrough option in Quick Access ToolbarĮvery time you don't remember the shortcut key, that is are rarely needed. Similarly, you can apply strikethrough on numeric data. Now, we have applied strikethrough formatting on column A (a range of cells) and you will see that a line crossed through the data over it.ĭata with strikethrough looks like this. Select a cell or range of cells and press the Ctrl+5 shortcut key to apply strikethrough on the selected data range. See, we have some data stored in an Excel worksheet that is currently normal without applying strikethrough formatting. Select that range of cells and then apply strikethrough using the Ctrl+5 shortcut key. Tip: If you want to apply the strikethrough text formatting on multiple cells data. Press this shortcut key to apply the strikethrough on the selected Excel data automatically. You just have to select the data on which you want to apply the strikethrough formatting. Shortcut key to apply strikethroughĮxcel does not have the strikethrough option but has a shortcut key to apply the strikethrough on the text stored in Excel cell. Step 4: Now, you see that all three selected data is crossed through by a line over it.Įach time you have to follow the same steps if you want to apply strikethrough. Step 3: A Format Cell panel will open, where mark the Strikethrough option and click OK. Step 2: In the Home tab, go to the Font section and click on the small down arrow icon (Font Setting button) present in its bottom right corner. Step 1: Select the data in the given dataset on which you like to apply strikethrough. We have taken some data in an Excel worksheet on which we will apply the strikethrough formatting. But you can apply it by following few simple steps. There is a long way to apply the strikethrough on Excel data as it is not directly available in Excel like MS Word. In this chapter, we will go through several other methods to apply as well as remove strikethrough in MS Excel. So, the big question is that how can we apply strikethrough in Excel. There is no option to strikethrough the text in Excel. Those who worked with MS Word know that MS Word has an option Strikethrough in the Home tab of MS Word ribbon while MS Excel does not have such option. It is a formatting feature that is not directly available in MS Excel.Strikethrough can be applied on any type of data, such as text, number, date, etc.Know the following features about strikethrough in MS Excel. This text looks like this, as shown in the below screenshot - Features of strikethrough You can use strikethrough on a single Excel cell data or a range of cells. It usually applies to the text stored in Excel cells. Strikethrough is a text formatting method that you can apply to Excel data. Strikethrough cross something by drawing a line through it. Example 1: Strikethrough with conditional formattingĪs we described that the strikethrough is a type of formatting option to draw a line through a value in Excel.Add strikethrough option in Quick Access Toolbar.
Excel does not have strikethrough option.In this chapter, we are going to learn about strikethrough, features, advantages of using it and its examples. Basically, strikethrough refers to drawing a line through a value in the Excel cells. But now you are thinking that what does it mean. Strikethrough is a type of formatting option in Excel. First of all, it is important to understand that what is strikethrough and why it needs.
0 kommentar(er)
