As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

Applying Strikethrough Formatting in Excel

In Microsoft Excel, you may have observed text with a line crossing through it, a formatting feature known as "strikethrough text." Its application spans various purposes, whether indicating irrelevance, completion, or simply for stylistic preference. Adding strikethrough text in Excel is straightforward.

To include strikethrough text

  1. Choose the cells where you wish to apply strikethrough.
  2. On the Home tab, within the Font group, select the Strikethrough option.
  3. That's all it takes! The chosen text will now display a line through it.

Removing strikethrough text involves similar steps

  1. Select cells containing the strikethrough text.
  2. On the Home tab, in the Font group, deselect the Strikethrough option.
  3. The strikethrough formatting will be removed.

Modifying the color or line thickness of the strikethrough in Excel is achievable

For color adjustment:

  1. Choose the cells with strikethrough text.
  2. On the Home tab, in the Font group, select the Strikethrough option.
  3. Proceed to the Strikethrough Color button.
  4. Choose the desired color, and the text will adopt the selected color for the strikethrough.

For adjusting line thickness:

  1. Select cells containing strikethrough text.
  2. On the Home tab, in the Font group, select the Strikethrough option.
  3. Click on the Strikethrough Weight button.
  4. Opt for the preferred thickness, and the strikethrough line will adjust accordingly.

Once familiar with adding, removing, and customizing strikethrough text in Excel, consider practical applications

  • Use strikethrough to mark completed tasks in a list, differentiating them from pending tasks.
  • Employ it in data spreadsheets to denote outdated information that requires updates, aiding in recognizing alterations.
  • Utilize strikethrough in product listings to show items no longer available, facilitating the identification of in-stock products.
  • Apply it in goal lists to differentiate achieved goals from pending ones, providing clarity on current priorities.