what to do if quick analysis button doesnt show up

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. You will then see the below result.Ī line now passes through all the cells in column “Executive”. Under “Effects”, check the box adjacent to strikethrough, press OK to save changes. Once you have clicked the above option on the Font tab, you will see this window opened.

Suppose we select Executives to strikethrough. Here is the sample data on which strikethrough is applied. You can download this Strikethrough Excel Template here – Strikethrough Excel Template Method #1 – Strikethrough Manually from Home Button

What to do if quick analysis button doesnt show up