Productivity

Use This Keyboard Shortcut For Strikethrough Text In Excel

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.


Have you subscribed to Lifehacker Australia's email newsletter? You can also follow us on Facebook, Twitter and YouTube.