Microsoft Word allows users to apply strikethrough and double strikethrough using the options available as part of Font dialog.
#Ms word strikethrough shortcut 2010 free
Enter the CountSrtikeCells function in any blank cell and you will get the count of cells with strikethrough.įeel Free to ask if you need to know anything more about strikethrough in excel. Apply single/double strikethrough in Word 2010, 2013 & 2016. Public Function CountStrikeCells(pWorkRng As Range) As Long Click Insert Module (Step 1 of this example) and Copy & Paste the below VBA code. Open the excel workbook and press Alt+F11. You can refer the VBA Beginners Guide here. There is no default excel function to count strikethrough cells in excel hence for the above function to work you need to input the a VBA Code. Use the below excel function to count strikethrough cells in excel. MS Word 2016 Hyperlink ShortCut in Windows: MS Word 2016 Choose the Thesaurus command (Review tab, Proofing group). If the excel sheet has lots of rows and columns with many strikethrough cells and you want to know the exact count then you need a shortcut. In Windows, press the Alt+Tab keyboard shortcut. In our above example since there are only 6 cells with strikethrough value its easy to count manually. For a web page image, right-click and choose the Copy or Copy Image command.
#Ms word strikethrough shortcut 2010 how to
Now that you know how to do strikethrough in excel, the next question would be how to count strikethrough cells. Along with shortcut key to strike out text in excel.Īs mentioned earlier Strikethrough is a Font Effect in Excel Format Cells options hence you can use the shortcut key Ctrl+Shift+F to launch the Format Cells: Font option in Excel. Now let’s see how this has been done in different Excel versions. Heres how to get Microsoft Word for your own computer. converts the selected text to capital letters or vice versa. You can also apply strikethrough formatting using the Font window.
Press Control + 1 (or right click and select Format Cells). You have to select entire row/cell/character as required to apply the Strikethrough Effect. In order to work faster and improve your productivity, here is a short list of shortcuts available in Word 2010. Select the cells where you want to apply the strikethrough format.
In the above example row 8 & 9 are completely stroked off and in row 2 only few characters in the cell are stroked off. Word displays the Font tab of the Font dialog box. All you need to do is follow these steps: Press Ctrl+D. You can define your own shortcut key for strikethrough by customizing Word. You can draw a strikethrough line on a complete word or only on a selected character in a cell. Most people add it by displaying the Font dialog box and then selecting Strikethrough in the Effects area of the dialog box. Below is an example of how strike through looks like in excel. In this tutorial you will learn how to strikethrough a word/vale in Excel cell. Strikethrough is a Font Effect in Excel Format Cells options. How to Strikethrough in excel and Count Strikethrough Cells What is Strikethrough in Excel:
0 kommentar(er)
