It’s really easy to remove strikethrough from a cell. Look at the below checklist where I have used a check box with conditional formatting to apply strikethrough.

Use Conditional Formatting to Apply StrikethroughĬonditional formatting is one of the best ways to apply formatting in a smart way. You can also assign it to a shape to create a button.

The above code will help you to apply strikethrough on selected cells. Macro codes work like a charm and, if you want to use a VBA for strikethrough here is the code for you. Want to know the best part? You can also access other formatting options which are nowhere on the ribbon through the same. You can apply it on multiple cells and on the partial text.

In the font tab, tick marks the strikethrough option.

Use shortcut key ctrl + 1 to open the format options.

Select all the cells on which you want to apply it.

Apply Strikethrough from Format OptionĪs I said there is no direct option in Excel for strikethrough, but actually, there’s an option that you can access from format options. But watch out for the amount the key combinations vary between programs and operating systems.This button also works if you want to apply it to a particular part of a text and on multiple cells. Prepped with this knowledge you’ll be one productive task master, satisfyingly scoring lines through that endless pile of tasks. After that close both windows and you’re good to go. Control-5 or Alt-Shift-5 are the most common so maybe the easiest to remember. Below ‘press new shortcut key’ enter a new shortcut for strike through. Click the strikethrough checkbox and this will open another window called ‘customise keyboard’. If done correctly, the cursor will turn into a clover. With that open hit Alt and Control at the same time and press +. Go back to that font customiser window mentioned above by pressing Control-D. If you want to create your own Strikethrough shortcut in Word for Windows you can. There you have it, the longest strikethrough shortcut known to man. This will check the strikethrough style, then press enter. Then press Control-D to open the font customiser window. Highlight that task you’ve just nailed or that mistake made by a colleague you’re about to humiliate. You may need to use a convoluted work around. However, if you’re using Word for Windows 10 the below shortcuts might not work. This is typically seen in Word documents that have been doing their rounds hoovering up amends and criticism. Other than marking something as complete strikethrough can be used to mark something as corrected.

Strikethrough shortcut excel mac