How to strikethrough in Excel: shortcut, button and conditional formatting

This tutorial shows you how to add, use, and remove strikethrough formatting in Excel (desktop, online, and Mac versions). While Excel excels at number crunching, text formatting isn't always intuitive; strikethrough is a prime example. Unlike Word's readily available strikethrough button, Excel requires a different approach. This guide details six methods.

Methods for Applying Strikethrough in Excel:

• Keyboard Shortcut: The quickest method is the keyboard shortcut: Ctrl 5 (Windows) or ⌘ SHIFT X (Mac). This works on single cells, cell ranges, or even parts of cell content (by double-clicking the cell to edit).

• Format Cells Dialog: Select your cells, press Ctrl 1 (or right-click > Format Cells), go to the Font tab, and check the "Strikethrough" box.

• Quick Access Toolbar Button: Add a strikethrough button to your Quick Access Toolbar for easy access. Click the arrow in the upper-left corner of Excel, select More Commands…, choose "Commands Not in the Ribbon," add "Strikethrough," and click OK.

• Ribbon Button: For more permanent access, add the button to the ribbon. Right-click the ribbon, select Customize the Ribbon…, create a new group, add "Strikethrough," and click OK.

• Conditional Formatting: Automate strikethrough based on cell content (e.g., "Done"). Use conditional formatting to apply strikethrough when a specific condition is met.

• VBA Macro: For advanced users, a VBA macro (Selection.Font.Strikethrough = True) can apply strikethrough to selected cells.

Excel Online and Mac:

Excel Online offers a strikethrough button on the Home tab, but selecting non-adjacent cells is limited. The keyboard shortcut remains efficient. Excel for Mac uses the shortcut ⌘ SHIFT X and offers the Format Cells dialog option.

Removing Strikethrough:

To remove manually added strikethrough, use Ctrl 5 (or ⌘ SHIFT X) again or uncheck the "Strikethrough" box in Format Cells. For conditionally formatted strikethrough, clear the formatting rule.

This comprehensive guide empowers you to master strikethrough formatting in Excel, regardless of your version or skill level.

The above is the detailed content of How to strikethrough in Excel: shortcut, button and conditional formatting. For more information, please follow other related articles on the PHP Chinese website!