How to strikethrough in Excel

In this guide, we’re going to show you how to strikethrough in Microsoft Excel.

If you prefer a hands-on approach, you can download the practice workbook from below:

Download Workbook

Strikethrough formatting in Excel serves as a valuable tool for decluttering spreadsheets by crossing out data that is no longer needed. This formatting feature allows users to easily identify and differentiate obsolete or irrelevant items within a dataset without deleting them, maintaining a record while visually streamlining the information. In order to utilize this functionality, we will explore three distinct methods to apply strikethrough formatting in Excel. These methods are straightforward and can be followed by users of any proficiency level, enabling them to incorporate strikethrough formatting into their data management practices seamlessly. By following the simple steps outlined, users can quickly learn how to apply this formatting and thus improve the organization and readability of their Excel spreadsheets.

Keyboard shortcut

Select the Cell/Text: Click on the cell or highlight the text where you want to apply the strikethrough.

Apply Strikethrough: Use the keyboard shortcut Ctrl+5 (Windows) or Command + Shift + X (Mac) to instantly apply strikethrough formatting.

Using the Format Cells Dialog Box

Strikethrough can be applied through the Format Cells window, just like other formatting options.

You can open the Format Cells window in a few ways. Select the cell(s) containing the text you want to format and use one of the following:

• Select the Cell/Text: Click on the cell or highlight the text where you want to apply the formatting.
• Open the Format Cells Dialog Box: Right-click on the selected cell, choose "Format Cells" from the context menu. Alternatively, you can press Ctrl+1 to open the Format Cells dialog box.
• Navigate to the Font Tab: Inside the Format Cells dialog box, go to the "Font" tab.
• Check the Strikethrough Box: Look for the "Effects" section, and check the box next to "Strikethrough."
• Click OK: Click the "OK" button to apply the strikethrough formatting.
• 
• Alternatively, Click the tiny arrow on Home > Font
  

Strikethrough using Quick Access Toolbar

The last approach in our list is using the Quick Access Toolbar. You can add the Strikethrough command button into the Quick Access Toolbar which can be found in the top section of the Excel window.

Follow the steps below to add the command into the Quick Access Toolbar:

1. Open Excel Options.
2. Click on Quick Access Toolbar
3. Select All Commands to list Strikethrough.
4. Select Strikethrough in the left box.
5. Click Add button to move the command to the toolbar.
6. Click OK to finish.
   

In conclusion, the three methods presented for applying strikethrough formatting in Excel offer a range of options to cater to different user preferences and workflow requirements. Whether you favor quick keyboard shortcuts, the straightforward use of the Format Cells dialog, or using Quick Access Toolbar, there is an approach that aligns with your specific needs. By providing these varied techniques, Excel empowers users to customize their data presentation in a way that best suits their individual or organizational style.