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.


The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.

Comments


5 responses to “Use This Keyboard Shortcut For Strikethrough Text In Excel”