Follow these steps to add a strikethrough button in the QAT. However, we can add a strikethrough button to the Quick Access Toolbar and access it with a single mouse click whenever you deemed it necessary.
![how to do strikethrough in excel how to do strikethrough in excel](https://yodalearning.com/wp-content/uploads/Strikethrough-in-Excel.jpg)
Strikethrough button or option is not available in Excel by default. Add a Strikethrough Button to Quick Access Toolbar You can also format font, number, borders, alignment, etc., using this dialog box. This method also gives access to many other formatting options in a single place. Now you can see the result as shown in the below: Then, click ‘OK’ to save the change and close the dialog box. Once the Format Cells dialog box is opened up, on the ‘Font’ tab, check the ‘Strikethrough’ option under the Effects section. Or you can also click on the small arrow on the bottom-right corner of the Font section in the ‘Home’ tab to open the Format Cells dialog box. Select the cells that you want to strikethrough and then right-click, and choose the ‘Format Cells’ option (or press Ctrl + 1 to open Format cells dialog). Strikethrough Text Using Format Cell OptionsĪnother easy method that you can use to strike out data in Excel is by using the Format Cells feature. To strikethrough, more than one cell, select the range or select the non-continues cells while holding the Ctrl key, and then press the strikethrough keyboard shortcut. If you want to strike out only a specific part of the cell value, double-click the cell to enter the Edit mode, then select the part of the text that you want to strikethrough, and press the same shortcut key ( Ctrl+5).
![how to do strikethrough in excel how to do strikethrough in excel](https://4.bp.blogspot.com/-BAdQDqzh1GU/VxNHtTpHRHI/AAAAAAAARnQ/CCrYod8z7kA8CfT73eqIPGPJ8oktmRutQCLcB/w1200-h630-p-k-no-nu/How%2BTo%2BDo%2BA%2BStrikethrough%2BIn%2BExcel%2B%2528Excel%2B2016%2529%2B%2B%25E0%25B8%2581%25E0%25B8%25B2%25E0%25B8%25A3%25E0%25B8%2582%25E0%25B8%25B5%25E0%25B8%2594%25E0%25B8%2586%25E0%25B9%2588%25E0%25B8%25B2%25E0%25B8%2595%25E0%25B8%25B1%25E0%25B8%25A7%25E0%25B8%25AD%25E0%25B8%25B1%25E0%25B8%2581%25E0%25B8%25A9%25E0%25B8%25A3%25E0%25B8%2594%25E0%25B9%2589%25E0%25B8%25A7%25E0%25B8%25A2%2BExcel%2B2016.png)
Note: Do this using the number along the top of your keyboard. Once the cells are selected, then press the keyboard shortcut key: Ctrl+5 and the data inside the cell will be crossed out.
![how to do strikethrough in excel how to do strikethrough in excel](https://cdn4syt-solveyourtech.netdna-ssl.com/wp-content/uploads/2015/06/excel-2010-remove-strikethrough-3.jpg)
To apply the strikethrough format, first select the cell or cells that you need to strikethrough. Now suppose we have the below to-do list for which we need the strikethrough format. Here’s the keyboard shortcut to apply the strikethrough in Excel: Ctrl + 5 If you want to quickly strikethrough text in Excel, then a shortcut key is best the option for you. Strikethrough in Excel Using Shortcut Key Strikethrough formatting is represented by words with a horizontal line through their center, which could show tasks have been completed or that the text is wrong and irrelevant.Īlthough Excel doesn’t provide us any direct Strikethrough option on the ribbon, you can still access the strikethrough effect by using any of the five methods described in this tutorial. Strikethrough (a.k.a strikeout) is a horizontal line drawn through the center of the text, often used to indicate a revision or edit or the deletion of an error.