We can create a strikethrough button by following the below steps. Method # 4 – Create and add a strikethrough button on Excel Ribbon. Now, press CTRL+5 and the selected cells will have a line passing through them like below. Finally, we will apply the breakthrough on the steps that are marked as “Done”.įor this, we need to select the marked “Done” steps, as shown below. Some are marked “Done”, some are” not done”. This example shows various steps in an HR Procedure. The fastest way to apply strikethrough on cell/cells is by pressing CTRL+5Įxample: Here is a sample data on which we will apply the breakthrough effect. Method # 3 – Strikethrough in excel through the keyboard shortcut Press OK, and the strikethrough effect will be removed from the selected cell/cells. In case you want to remove the strikethrough from the selected cell/cells, just follow the same procedure and uncheck the strikethrough box as shown below. Then, as shown above, select the strikethrough option under “Effects”, and all the selected cell/cells will have a line passing through them. Step 2 – Select the cell/cells and press CTRL+1, and you will see the Format Cell dialog box. Now, under Effects, you need to check the box for strikethrough and press OK. Now click on format cells, and the Format Cell dialog box will appear as below. Step 1 – Right-click on the selected cell/cells and then select the Format Cells option in the drop-down menu. Now, you can use any of the ways to bring the Format Cell dialog box as shown below.
Again, the help of previous sample data illustrates it.Įxample: Now, we will select all the cells under the Role column. Method #2 – Strikethrough in Excel using Format Cells Dialog BoxĪnother way to apply strikethrough in excel is by using the Format Cell dialog box. However, it is limited to text and can be any number, date, currency, or any other type. Strikethrough can be applied to any type of cell. Press OK, and the strikethrough effect will be removed from cells. We can remove or disable strikethrough in excel anytime by selecting the relevant cell/cells and by unchecking the strikethrough box. In short, the strikethrough Effect is applied. A line now passes through all the cells in column “Executive”.
0 kommentar(er)
