How To Do Strikethrough In Excel

Use the strikethrough formatting option in the font menu to apply strikethrough to selected text or cells in Excel.

In the world of spreadsheets, Microsoft Excel stands as a powerful tool for organizing and analyzing data. As you dive deeper into Excel’s functionalities, you may come across the need to format your data in various ways to make it more visually appealing or to highlight certain information. One handy formatting option is the ability to apply strikethrough to cell contents. Whether you want to cross out completed tasks, highlight outdated information, or simply add a visual cue to your data, knowing how to do strikethrough in Excel will prove invaluable. In this blog post, we will guide you through the steps to easily apply and remove strikethrough in Excel, allowing you to present your data with clarity and purpose.

How To Do Strikethrough In Excel: Step-by-Step

1

Step 1: Open Excel,

First, open Excel and locate the desired spreadsheet. From there, navigate to the specific cell or range of cells where you wish to apply the Strikethrough effect, enhancing readability and highlighting important data.

Next Step
2

Step 2: Select Cells,

Once you have selected the cell or range of cells, simply right-click and choose the “Format Cells” option. In the Format Cells dialog box, navigate to the “Font” tab and check the “Strikethrough” box. Click “OK” to apply the effect.

Next Step
3

Step 3: Open Format Cells,

This will open a window where you can format the selected cells. To access it quickly, right-click on the selected cells and choose ‘Format Cells’ from the menu that appears.

Next Step
4

Step 4: Enable Strikethrough,

In the ‘Format Cells’ window, accessed by the previous step, navigate to the ‘Font’ tab if necessary. Checkmark the ‘Strikethrough’ option found in this tab. This action will activate the Strikethrough effect, causing the selected text to appear with a strike line through it.

Next Step
5

Step 5: Apply Changes,

To apply changes and close the window, click ‘OK’ at the bottom of ‘Format Cells’.

Conclusion

In conclusion, knowing how to apply strikethrough in Excel is a valuable skill that can enhance the clarity and organization of your data. Whether you need to mark completed tasks, indicate changes, or add a visual element to your spreadsheet, strikethrough can be a powerful tool. By following the simple steps outlined in this blog post, you can easily apply strikethrough to any cell or range of cells in Excel. So start incorporating this formatting feature into your spreadsheets and take your data presentation to the next level!

Table of Contents