3 Best Ways to Strikethrough Text in Microsoft Excel
Striking through text in Microsoft Excel is a handy way to mark items as done or to indicate that a piece of information is no longer relevant, without actually removing the text. There are several methods to apply strikethrough formatting in Excel, and here are three of the best ways to do so:
1. Using the Ribbon:
The most straightforward method to apply strikethrough in Excel is by using the Ribbon.
– First, select the cells containing the text you want to strikethrough.
– Then, go to the ‘Home’ tab on the Ribbon.
– In the ‘Font’ group, you will find a button with a ‘Strikethrough’ icon (it looks like a capital ‘T’ with a line through it).
– Click on this button, and the selected text will be struck through.
2. Using Format Cells Dialog:
– Highlight the cell or range of cells that you want to format.
– Right-click on the highlighted area and select ‘Format Cells’ from the context menu, or press `Ctrl + 1` on your keyboard as a shortcut to open the ‘Format Cells’ dialog box.
– In the dialog box, navigate to the ‘Font’ tab.
– Under ‘Effects,’ you will see an option for Strikethrough.
– Check this box and then click ‘OK.’ The strikethrough will be applied to your selected text.
3. Using Excel Keyboard Shortcuts:
– If you prefer using keyboard shortcuts for speed and efficiency, Excel has got you covered for applying strikethrough formatting too.
– First, select the cells where you need strikethrough formatting.
– Once selected, press `Alt + H + 4` on your keyboard. For Mac users, after selecting the cell content, use `Cmd + Shift + X`.
By using these methods, you can quickly and easily apply strikethrough formatting to your text in Excel. Depending on how often you need to use this feature or your preference for using either the mouse or keyboard shortcuts, one of these ways might become your go-to method for striking through text in Microsoft Excel.