![excel keyboard shortcut striketrough excel keyboard shortcut striketrough](https://excelinexcel.in/ms-excel/wp-content/uploads/sites/2/2020/01/Apply-or-remove-strikethrough-1024x576.jpg)
The computer shortcut keys are a set of one or more keys that generate a particular command to be executed. Furthermore, by using shortcut keys, you can increase your productivity and reduce the strain caused by repetitive motions. The use of shortcut keys is beneficial for computer users, as it allows them to complete tasks accurately and in less time. If you use the computer frequently, you must have knowledge about the computer shortcut keys.Ĭomputer shortcut keys provide an easier way of navigating and performing commands in computer software.
EXCEL KEYBOARD SHORTCUT STRIKETROUGH 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.
EXCEL KEYBOARD SHORTCUT STRIKETROUGH 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.
![excel keyboard shortcut striketrough excel keyboard shortcut striketrough](https://cdn.ablebits.com/_img-blog/strikethrough-excel/add-strikethrough-button.png)
In the format cells dialogue box, select the font tab and check the Strikethrough option.Press Control + 1 (or right click and select Format Cells).Select the cells where you want to apply the strikethrough format.Here are the steps to access Strikethrough in Excel using the Format Cells dialogue box: While the earlier mentioned techniques (keyboard shortcut and icon) are faster ways to access strikethrough formatting, using format cells dialogue box gives you access to a lot of other formatting options as well. There is another way you can access strikethrough in Excel – Using Format Cells dialogue box. This will add the strikethrough icon in the quick access toolbar.Īccess Strikethrough Format from Format Cells Dialogue Scroll down and select Strikethrough from the list.In the Excel Options dialogue box, select All Commands from the drop-down.Right-click on any existing QAT icon or the ribbon tabs and select ‘Customize Quick Access Toolbar…’.Here are the steps to add strikethrough icon in the QAT: While the icon is not available in the ribbon or Quick Access Toolbar (QAT) by default, you can add it easily. Add Icon in QAT to Access Strikethrough in Excel You can also select non-adjacent ranges and then apply the strikethrough format. If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut. 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 EXAMPLE 2: Using Checkboxes (to show completed tasks).EXAMPLE 1: Using Conditional Formatting.Examples of Using Strikethrough in Excel.Access Strikethrough Format from Format Cells Dialogue.Add Icon in QAT to Access Strikethrough in Excel.Keyboard Shortcut to Apply Strikethrough in Excel.