Something as shown below:ĭownload Example File EXAMPLE 3: Using Double Click (VBA) You can also use check-boxes to cross off items. 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. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |