How To Strike Through Text In Excel

To strike through text in Excel, you can select the desired cell or range of cells, navigate to the Home tab, click on the “Strikethrough” button in the Font section of the ribbon, and the text will appear with a strike-through line across it.

If you use Microsoft Excel regularly for data analysis or reports, you may have encountered situations where you wanted to emphasize certain text or strike through text to indicate changes or deletions. While Excel offers a wide range of formatting options, the ability to strike through text is often overlooked. In this blog post, we will explore how to efficiently strike through text in Excel, allowing you to visually communicate important information in your spreadsheets. Whether you are a beginner or an experienced Excel user, these techniques will help you enhance the visual presentation and convey the right message effectively. So, let’s dive in and discover how to strike through text in Excel.

How To Strike Through Text In Excel: Step-by-Step


Step 1: Open Excel Spreadsheet,

To begin, locate the Microsoft Excel application on your computer and double-click to launch it. Once open, navigate to the specific spreadsheet that contains the text you want to strike through.

Next Step

Step 2: Select Text to Strike Through,

Click and drag the mouse over the cell or group of cells containing the text that you want to strike through to easily apply formatting and visually indicate that the text has been crossed out or is no longer relevant.

Next Step

Step 3: Open Format Cells Dialog Box,

To format selected cells, right-click and choose ‘Format Cells…’ from the context menu. Alternatively, you can press ‘Ctrl+1’ to open this dialog box.

Next Step

Step 4: Select ‘Strike Through’,

The ‘Format Cells’ dialog box allows you to customize the appearance of text in Excel. By clicking on the ‘Font’ tab and selecting the ‘Strikethrough’ checkbox under the ‘Effects’ section, you can apply a line through the middle of the text.

Next Step

Step 5: Apply Strike Through Effect,

After selecting the text, simply click on the ‘OK’ button located at the bottom of the dialog box. This action will close the dialog box and instantly apply the strike-through effect to the text you have chosen.


In conclusion, learning how to strike through text in Excel can greatly enhance the visual appeal and clarity of your spreadsheets. Whether you want to demonstrate the completion of a task, highlight changes in data, or simply add emphasis, the strike-through feature is a handy tool to have at your disposal. Through this blog post, we have explored different methods of striking through text in Excel, such as using formatting options, conditional formatting, and custom formulas. By following the step-by-step instructions provided, you can easily incorporate this formatting technique into your Excel documents, making them more visually engaging and allowing your data to be effectively communicated. So go ahead, give it a try, and experience the impact that striking through text can have on your Excel spreadsheets!

Table of Contents