How to Strikethrough in Microsoft Excel
It seems sensible that you should be able to strike through text and numbers in Excel as the strikethrough is a traditional formatting technique that mimics content that has been crossed out.
Although Excel also has this formatting option, you can't access it directly from the ribbon commands. However, there are several methods to access it. And you may, even though there isn't a strikethrough tool available in the formatting settings on the ribbon, so it might not be immediately apparent. This Excel tutorial will show you how to strike through any text or figures, so don't let that stop you.
How to Apply a Strikethrough Using the Font Section in Excel
This method will destroy the contents of the chosen cells.
1. To strikethrough a cell (or set of cells), click it.
2. In the ribbon at the top of the screen, choose the Home tab.
3. In the Font section, choose the Font Settings option by clicking the little arrow to the section's bottom right.
4. Select the Strikethrough checkbox in the Format Cells dialogue box, then click OK.
How to Apply a Strikethrough Using a Keyboard Shortcut in Excel
Instead of utilising the Font Settings on the ribbon, you may use a keyboard shortcut to achieve the same result—a strikethrough.
Press Ctrl + 5 for Windows or CMD + Shift + X for the Mac to strikethrough a selected cell (or group of cells).
In Excel, how to apply a partial strikethrough.
There may be occasions when you wish to just strike through a portion of the text in a cell, even though you should usually strike through the entire cell. To strike through the text, just pick it and follow the exact instructions as before.
1. Double-click a cell to put it in edit mode.
2. Pick the text that you want to be struck through.
3. Use the keyboard shortcut (Ctrl + 5 or CMD + Shift + X) or the Font Setting button on the Home tab of the ribbon to choose Strikethrough.
Conclusions
Even though this helpful formatting feature isn't immediately accessible from the ribbon, there are still a lot of applications for it. You can choose whether you like the keyboard or the mouse.
