It features more tabs and the one you are looking for is Font. To start, heres a featured formatting shortcut you might not have known about: The Excel strikethrough shortcut will. This window is a bit different than in Excel and Word. Hit Ctrl + 1 (Control + 1 for Mac users) to access the Format Cells window, but don’t forget to select the cells you wish to strikethrough first. Excel’s strikethrough effect is a useful formatting tool for any business. Keep in mind, this is only an option for PC users. In the Effects area check strikethrough, click OK and see the effect. If you want to remove the strikethrough press the shortcut again or hit Ctrl + Z. In order to use the strikethrough, select text and use the Ctrl + Shift + F keyboard shortcut. Select one or more cells you wish to strikethrough and press Ctrl + 5.
#Shortcut for strikethrough in excel how to
So, let’s see how to apply the shortcuts. And yes, Excel has its own version of the Font dialog box which is called Format Cells. Excelīy now, it’s not hard to guess that there are two methods/shortcuts to apply strikethrough in Excel.
![shortcut for strikethrough in excel shortcut for strikethrough in excel](https://www.spreadsheetweb.com/wp-content/uploads/2021/06/How-to-strikethrough-in-Excel-01-min.gif)
Offset is the function that’s not available in Word and the shortcut for it is Alt + E.Įxtra Shortcuts: You can also press Ctrl + Shift + F or Ctrl + Shift + P to access the Font dialog box. So, I love to cross things off and the way to cross things off is to press CONTROL+5. When it comes to using strikethrough in Excel, Excel has multiple shortcuts to help us. The best thing in Excel is using most of the built-in features using quick shortcuts.
![shortcut for strikethrough in excel shortcut for strikethrough in excel](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_6-9.png)
I keep so many to-do lists in Excel, it is crazy. MS Excel or Microsoft Excel is powerful spreadsheet software by Microsoft, and it has a distinct range of built-in features and functions.
![shortcut for strikethrough in excel shortcut for strikethrough in excel](https://fisunguner.com/wp-content/uploads/2017/07/Graham-Sutherland-Two-Trees-1947-768x1082.jpg)
Strikethrough is Alt + K and all the other shortcuts are as described in the previous section with one exception. Learn Excel From MrExcel, Podcast 2118: Control+5 For Strikethrough. Press Ctrl + T (cmd+T on a Mac) to access the Font dialog box and, same as with Word, press Alt + the corresponding letter.