how to do strikethrough in excel shortcut

#How to do strikethrough in excel shortcut how to#
#How to do strikethrough in excel shortcut for mac#
#How to do strikethrough in excel shortcut Pc#
#How to do strikethrough in excel shortcut free#

It features more tabs and the one you are looking for is Font. This window is a bit different than in Excel and Word.

#How to do strikethrough in excel shortcut 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.

#How to do strikethrough in excel shortcut Pc#

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 do strikethrough in excel shortcut 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.

#How to do strikethrough in excel shortcut 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.Press Ctrl + T (cmd+T on a Mac) to access the Font dialog box and, same as with Word, press Alt + the corresponding letter. Public Function CountStrikeCells(pWorkRng As Range) As Long Step-4: There you will find a drop-down menu and. Step-3: From the Insert menu, go to the Shapes icon. Step-2: Select the Insert menu from the ribbon. Step-1: First, locate the texts you would like to strikeout in the word file. Strikethrough with your created line in word. Click Insert Module (Step 1 of this example) and Copy & Paste the below VBA code. Double Line Strike-Through Keyboard Shortcut Alt+L. Then, open your Excel menu by right-clicking anywhere within your selected cells. Choose the cell (or cells) you want to apply the strikethrough effect to. One way to do this is by using your right-click menu. Open the excel workbook and press Alt+F11. You can also use the strikethrough formatting option on your cells by bypassing the Home tab completely. 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. 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 our above example since there are only 6 cells with strikethrough value its easy to count manually. You will see a preview of the strikethrough. This will open the Format Cells dialog box, from which you can select the Strikethrough checkbox. Go to the Home tab on the ribbon and click on the Font Settings button within the Font command group. Now that you know how to do strikethrough in excel, the next question would be how to count strikethrough cells. Select the cell (s) which should have the strikethrough format. 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. This shortcut toggles strikethrough on and off for the current selection. Press Alt + K to select Strikethrough (note that k is the underlined letter). To access the Font dialog box using a keyboard shortcut and then apply Strikethrough: Select the text you want to strikethrough. Now let’s see how this has been done in different Excel versions. Using keyboard shortcuts to access the Font dialog box. You have to select entire row/cell/character as required to apply the Strikethrough Effect. In the above example row 8 & 9 are completely stroked off and in row 2 only few characters in the cell are stroked off. You can draw a strikethrough line on a complete word or only on a selected character in a cell. Below is an example of how strike through looks like in excel. Open FONT SETTINGS WINDOW or RIGHT CLICK > FORMAT CELL. Select the cells from which you want to remove Strikethrough. Strikethrough will be removed.Similarly, we can easily remove strikethrough by. In this tutorial you will learn how to strikethrough a word/vale in Excel cell. Simply select the cell or text and click CTRL+5. To apply strikethrough, you can use a VBA Code.

Strikethrough is a Font Effect in Excel Format Cells options. Click on the Format tab, and tick the mark for the strikethrough excel option. How to Strikethrough in excel and Count Strikethrough Cells What is Strikethrough in Excel: