You can use any method to remove strikethrough.Things to Remember about Strikethrough in Excel You can remove strikethrough formatting by following the below process. Check the strikethrough box.Ĭlick “OK” and then again click “OK” to close the new formatting rule window. Now, write=$b2=”Done” then go to “Format”. Select all the cells in the HR procedure column now go to Conditional Formatting>New Formatting Rule> Use a formula to determine which cells to format. Now, if we want to strikethrough the HR procedure step where the status is “Done”, we can do it by conditional formatting. Taking one of our previous examples, where we had HR procedure steps and their status. Method 6 – Applying strikethrough using conditional formatting.īelow is an example showing as to how can we do this. You can now apply the strikethrough by clicking on the button after you have selected the cells. Clicking again on it will remove the strikethrough. And you will find a new button on the upper left corner of the worksheet.
Now click on “Add”, this will add Strikethrough in the commands list on the right block. Step 2 – Now, under “Choose Commands From”, select “Commands Not in the Ribbon” from the dropdown. Then click “More Commands”, as shown below. Step 1 – Click on the downward arrow that you will find on the upper left of the Excel window. To add the button, follow the below steps.
Method 5 – Adding Strikethrough button to Quick Access Toolbar. To remove strikethrough, again click on the button. You can now just select the cells/cells and click on the Strikethrough button on the ribbon, and the cells will have the strikethrough effect. Step 3 – Once you press “OK”, you will see the Strikethrough button added on the ribbon as shown. Next, find and then select “Strikethrough” in the commands list, then as shown below. And in the Dropdown, we will select “Commands Not in the Ribbon”. Now since the new group is selected, we will go to “Choose Commands from”. For this, select Home and click “New Group” under the heading “customize the ribbon”>Main Tabs. Step 2 – Now, we will create a new button to be added to the custom group. Once you have selected it, you will see the below window. Step 1 – Press right-click anywhere on the Excel ribbon, and you then select the “Customize the Ribbon” option as shown. 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)
