Want to apply a strikethrough effect to text in Excel? All you need is this simple keyboard shortcut.
In Word 2013 (and 2010 and 2007), striking through text is easy and obvious: there’s a button for it on the Home tab of the Ribbon, near the icons for Bold, Italic and Underline:
However, if you look in the same area in Excel, there’s no strikethrough option — instead, you’ll see a shortcut for the Borders tool:
To apply strikethrough in Excel, you actually need to access the Font tab of the Format Cells dialog box:
There are several ways to get to Format Cells: you can click the small arrow in the bottom-right corner of the Font section of the Home tab; click on the Format dropdown in the Cells section of the Home tab and then select Format Cells; or type Control+1 (the fastest option and the one I always use).
However, there’s an even faster way to produce strikethrough. Select the text (or the cell) you want to strikethrough, and then type Control+5. You can also use that shortcut to remove strikethrough. Handy! Note this doesn’t work in Word; if you want a strikethrough shortcut there, you’ll have to set one up yourself.
For more handy Excel keyboard wizardy, check out our roundup of the most useful Excel keyboard shortcuts.