- How to strikethrough excel 2010 how to#
- How to strikethrough excel 2010 for mac#
- How to strikethrough excel 2010 code#
This tutorial is a part of our Basic Excel Skills, and if you want to sharpen your existing Excel Skills, checkout these Excel Tips and Tricks. And, please don’t forget to share this tip with your friends. Do you have any other method to apply strikethrough? And, which one is your favorite method? Share with me the comment section, I would love to hear from you. I hope this tip will help you get better at Excel. You have 5 + 1 different methods for this and all are easy to apply. So, that’s the whole story about applying strikethrough in Excel.
You can also copy-paste strikethrough from one cell to another cell using format painter. Important Note: If you have applied it through conditional formatting then you can’t remove it with the shortcut key unless you remove the entire formatting from the cell. (As you move the mouse pointer to get ready to click, the mouse pointer may change back to an arrow instead of a clover this is OK.) When you click, Word displays the Customize Keyboard dialog box with the insertion point blinking in the Press New Shortcut Key box. You just need to use the shortcut key (Control + 5) again. Click on the Strikethrough check box in the Font dialog box. 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.
How to strikethrough excel 2010 code#
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. It features more tabs and the one you are looking for is Font.This button also works if you want to apply it to a particular part of a text and on multiple cells. This window is a bit different than in Excel and Word.
How to strikethrough excel 2010 for mac#
Hit Ctrl + 1 (Control + 1 for Mac users) to access the Format Cells window, but don’t forget to select the cells you wish to strikethrough first. Keep in mind, this is only an option for PC users. If you want to remove the strikethrough press the shortcut again or hit Ctrl + Z. Select one or more cells you wish to strikethrough and press Ctrl + 5.
How to strikethrough excel 2010 how to#
So, let’s see how to apply the shortcuts. And yes, Excel has its own version of the Font dialog box which is called Format Cells. Excelīy now, it’s not hard to guess that there are two methods/shortcuts to apply strikethrough in Excel. Offset is the function that’s not available in Word and the shortcut for it is Alt + E.Įxtra Shortcuts: You can also press Ctrl + Shift + F or Ctrl + Shift + P to access the Font dialog box. Strikethrough is Alt + K and all the other shortcuts are as described in the previous section with one exception. Press Ctrl + T (cmd+T on a Mac) to access the Font dialog box and, same as with Word, press Alt + the corresponding letter.
0 kommentar(er)
