![Skyrim how to install enboost step](https://knopkazmeya.com/12.png)
#Strikethrough in excel shortcut keys code
This method disables getting into the edit mode on double click and simply applies the strikethrough format as soon as you double click in the cell (VBA code available in the download file). If you are cool with using Excel VBA macros, you can also use the double-click event to cross off items simply by double-clicking on it. Something as shown below:ĭownload Example File EXAMPLE 3: Using Double Click (VBA) You can also use check-boxes to cross off items.
#Strikethrough in excel shortcut keys how to
See Also : How to create a drop-down list in Excel.ĭownload Example File EXAMPLE 2: Using Checkboxes (to show completed tasks) We can use conditional formatting to strikethrough a cell as soon as it is marked as completed. Here are three practical examples where you can use the strikethrough format in excel. Strikethrough in Excel can be used to show completed tasks. For example, you can also change color, font type, font size, border, number format, etc., using this dialogue box. While this option is longer as compared to a keyboard shortcut or using the icon, it also gives access to many other formatting options at a single place. This would apply the strikethrough format to the selected cells.
![strikethrough in excel shortcut keys strikethrough in excel shortcut keys](https://nutsandboltsspeedtraining.com/wp-content/uploads/2019/01/Nuts-Bolts-Training-Strikethrough-Shortcut-Key-1.jpg)
Just select the cell where you want to apply the strikethrough format and press Control + 5. Here is the keyboard shortcut that will automatically apply the strikethrough formatting in Excel. Keyboard Shortcut to Apply Strikethrough in Excel
![Skyrim how to install enboost step](https://knopkazmeya.com/12.png)