This site uses Akismet to reduce spam. Learn how your comment data is processed. By John MacDougall. This post will show you all the ways you can add strikethrough font to your Excel workbooks. Table of Contents. About the Author. You can find other interesting articles from John on his blog or YouTube channel.
Related Articles. Browse All Posts. Keeping your spreadsheet organized is important! A well organized spreadsheet Merged cells are one of the most popular options used by beginner spreadsheet You have probably used color coding in your Excel data or seen it in a Submit a Comment Cancel reply Your email address will not be published.
This button also works if you want to apply it to a particular part of a text and on multiple cells. This is what you need to do. It works the same as other options. You can apply it on multiple cells and on the partial text. Want to know the best part? You can also access other formatting options which are nowhere on the ribbon through the same.
Macro codes work like a charm and, if you want to use a VBA for strikethrough here is the code for you. The above code will help you to apply strikethrough on selected cells.
You can also assign it to a shape to create a button. Conditional formatting is one of the best ways to apply formatting in a smart way. Look at the below checklist where I have used a check box with conditional formatting to apply strikethrough.
Whenever you mark a check box, the text in the corresponding cell will get a cut-through line. If you use the Excel web app then you must be happy because there is an option thereon Ribbon which you can use to apply strikethrough.
You can also copy-paste strikethrough from one cell to another cell using format painter. If your Quick Access Toolbar is reserved only for the most frequently used commands, which strikethrough is not, place it onto the ribbon instead. As with QAT, it's also one-time setup, performed in this way:.
You can now cross out text in Excel with a single button click! And it will also remind you the keyboard shortcut in case you forget it :. In case you are planning to use a strikethrough to cross out the completed tasks or activities in a checklist or to-do list, you may want Excel to do it for you automatically as you enter some text in a related cell, for example "done":. The task can be easily accomplished with Excel Conditional Formatting :.
Instead of defining a task status with text, you can insert checkboxes , link them to some cells which you can hide later and base your conditional formatting rule on the value in the linked cells TRUE is a checkbox is checked, FALSE if not checked. As the result, Excel will check off the completed tasks automatically depending on whether the checkbox is selected or not.
If you'd like to create something similar in your worksheets, the detailed steps can be found here: How to create a checklist with conditional formatting. If you are not allergic to using VBA in your Excel worksheets, you can apply strikethrough on all selected cells with this line of code:.
The step-by-step instructions on how to insert VBA code in Excel can be found here. In Excel Online, the strikethrough option is exactly where you'd expect to find it - next to the other formatting buttons on the Home tab, in the Font group:. However, there's a fly in the ointment - it's not possible to select non-adjacent cells or ranges in Excel Online. So, if you need to cross out multiple entries in different parts of your sheet, you will have to select each cell or a range of contiguous cells individually, and then click the strikethrough button.
It can also be done from the Format Cells dialog in the same way as in Excel for Windows:. If strikethrough is added by a conditional formatting rule, then you need to remove that rule to get rid of strikethrough.
For more information, please see How to delete conditional formatting rules in Excel. That's how you can add and remove the strikethrough formatting in Excel. I thank you for reading and hope to see you on our blog next week!
0コメント