
Now you have a new template you can use with any expression. Select the template you have built and save it as a new equation.

Right-click on the placeholder, select Border property, and remove one by one each side of the border finally insert the desired strike through, from the same menu.Ĥ. Open Accent menu and select Boxed formulas.ģ. You can then click the OK button at the bottom of the window to apply your changes and close the window.Īre there a lot of other formatting changes that have been applied to your spreadsheet, and you would like to get rid of all of those settings at once? Learn how to clear cell formatting in Excel 2013 by following just a few simple steps.I have been trying to find a way to put a diagonal strikethrough over a number or expression (as in cancelling fractions) within the Equation Editor of Word 2007.Ģ. Click the box to the left of Strikethrough to remove the effect from your selected cells.Click the small Font Options button at the bottom-right corner of the Font section in the navigational ribbon.Click the Home tab at the top of the sheet.You can also select the entire sheet by clicking the box above row 1 and to the left of column a.

You can select an entire row or column by clicking the row number at the left side of the sheet, or the column letter at the top of the sheet. Select the cells containing the strikethrough text.If you would prefer to add a strikethrough line through your text instead, then you can follow these same steps and select the Strikethrough option instead of removing it. The steps in this article will direct you to select cells that contain data with a line drawn through it, then adjust the font settings so that that line is removed. Removing the Strikethrough Effect in Excel 2013 Our guide below will show you where to find this option so that you can turn it off.

This is typically used to indicate that data is no longer being used, or that is has already been used for its purpose.īut if you have a spreadsheet that contains unwanted strikethrough text, then it is possible to remove that effect.

One formatting option you can use is Strikethrough, which will draw a horizontal line through the data in a cell. Whether you wish to format your text as currency or a date, or with a different color font, there is typically an option that will allow you to achieve the desired look. There are a lot of different formatting choices that you can make for the data in your Excel 2013 worksheets.
