Where is strikethrough in excel 2011

Inside the Font tab , you will also find a few other text effects that you can apply using your keyboard shortcuts. To use these shortcuts, simply hold the Alt key and hit the underlined letter as pictured below. There are two different shortcuts you can use to put a line through your text in Microsoft Word like this. Which one is better depends on what you are doing and how many formatting options you want to put at your fingertips like the double strikethrough effect.

Instead, simply hit and let go of the Alt key, then hit and let go of the H key and finally hit and let go of the 4 key. Note: If you are using the strikethrough shortcut to add recommendations and comments to your Word document, a better method is to use Comment commands. To learn how to properly add and navigate comments in Word, read our guide here.

Note: PowerPoint and Word both have a dedicate superscript and subscript shortcuts. To learn how to superscript and subscript in Word, Excel and PowerPoint including their keyboard shortcuts , read our guide here. Just like the Word strikethrough shortcuts, there are two different keyboard strikethrough shortcuts you can use to put a line through your text in Microsoft PowerPoint like this. Hitting the command once applies the crossed out text effect. Applying it a second time takes the text effect away.

Note: To make the Alt, H, 4 shortcut for strikethrough work, you do not need to hold the keys down. Share on linkedin. You can draw a strikethrough line on a complete word or only on a selected character in a cell. How to strikethrough in excel How to strikethrough in excel for Mac. How to count strikethrough cells. Now that you know how to do strikethrough in excel, the next question would be how to count strikethrough cells.

Anson Antony. Outside business and technology, he is a movie buff who spends hours together watching and learning Cinema and a Film Maker too! Great post you have covered versions as well best part is how well you explain. Leave a Reply Cancel reply Your email address will not be published. Recent Posts. Read More ». AI Tools. Cloud Computing. Data Science. Angular 7. Machine Learning. Data Structures. Operating System. Computer Network.

Compiler Design. Computer Organization. Discrete Mathematics. Ethical Hacking. Computer Graphics. Software Engineering. Web Technology. Cyber Security. C Programming. Control System. Data Mining. Data Warehouse. Javatpoint Services JavaTpoint offers too many high quality services. We will discuss the given topic below - What is strikethrough Features of strikethrough Excel does not have strikethrough option Apply strikethrough on Excel data Shortcut key to apply strikethrough Add strikethrough option in Quick Access Toolbar Strikethrough Examples Example 1: Strikethrough with conditional formatting What is strikethrough?

This text looks like this, as shown in the below screenshot - Features of strikethrough Know the following features about strikethrough in MS Excel - Strikethrough can be applied on any type of data, such as text, number, date, etc.

It is a formatting feature that is not directly available in MS Excel. So, the big question is that how can we apply strikethrough in Excel. Apply strikethrough on Excel data There is a long way to apply the strikethrough on Excel data as it is not directly available in Excel like MS Word. Each time you have to follow the same steps if you want to apply strikethrough. Shortcut key to apply strikethrough Excel does not have the strikethrough option but has a shortcut key to apply the strikethrough on the text stored in Excel cell.

Press this shortcut key to apply the strikethrough on the selected Excel data automatically. Tip: If you want to apply the strikethrough text formatting on multiple cells data. Data before applying Strikethrough See, we have some data stored in an Excel worksheet that is currently normal without applying strikethrough formatting. Date after applying strikethrough Now, we have applied strikethrough formatting on column A a range of cells and you will see that a line crossed through the data over it.

Data with strikethrough looks like this - Similarly, you can apply strikethrough on numeric data. Add Strikethrough option in Quick Access Toolbar Every time you don't remember the shortcut key, that is are rarely needed.

Strikethrough Examples Till now, we have explained the strikethrough and how to apply it on Excel cells data. Example 1: Strikethrough with conditional formatting In this example, we will use conditional formatting to strikethrough the cell data like the color formatting.

Scenario We will make a list of some tasks in a column and its corresponding column, we will create a dropdown list of the task status. Now, the point is - how will do.