strikethrough shortcut excel

In the Format Cells dialog, under Font tab, check Strikethrough option in the Effects section. Press Ctrl + Shift + F. Once the cells are selected, then simply use the excel strikethrough shortcut key … 11. Click OK to finish. IMPORTANT: Do this using the numbers along the top of your keyboard. Removing any strikethrough format in your text is just as easy as applying it. By far, the simplest method to strikethrough in Excel is the Ctrl+5 shortcut. You can refer the VBA Beginners Guide here. Summary of the Excel Strikethrough Shortcut The shortcut itself is CTRL + 5, so selecting the cells you’d like to strikethrough and pressing CTRL + 5 is the fastest way to add the strikethrough formatting, but adding it to your quick access toolbar is another good way to accomplish this. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. Strikethrough in Excel Cell. Strikethrough text in excel means a line going between the texts in an excel cell, to this we can use the format option of any cell by right-clicking on it and enable the option or checkbox for strikethrough which will draw a line to the text, there is also a keyboard shortcut to do it which is CTRL+5. An example sometimes, while creating a document we don’t need a few texts we can just delete it. Uncheck the Strikethrough option in the Format Cells menu. Follow the steps below to add the command into the Quick Access Toolbar: Open Excel Options. Step 2. Apply or Remove Strikethrough formatting With Shortcut in Microsoft Excel . Press OK, and the strikethrough effect will be removed from cells. Customize Keyboard dialog box will open. Villeroy wrote: You can strike through the cell's value. Select the cells containing the data you want to format. 1. 1. Save the workbook and reopen it in Excel for the web to see the changes. Select the text (or the cell) you want to strikethrough, and then type Control+5. In the Format Cells dialog box, switch to the Font tab and select the Strikethrough checkbox: The length of the text doesn’t matter. You can also use that shortcut to remove strikethrough. This is a great way to create a strikethrough shortcut. 2. Here are the steps to access Strikethrough in Excel using the Format Cells dialogue box: Select the cells where you want to apply the strikethrough format. ⌘+F11, Insert an Excel 4.0 macro sheet. 11. Feb 10, 2012 - 196 time-saving Hotkeys for Excel 2011. Excel Strikethrough Text. You can also double-click in a cell and drag over partial text. Press those two buttons, and the selected cell(s) will have strikethrough applied. Undoubtedly, the easiest is Ctrl+T. Right-click the selection and chose Format Cells from the popup menu. Steps for strikethrough using the excel shortcut key are as follows –. See screenshot: 3. Enable Strikethrough option on Excel 365: You need to open the workbook. On Menus tab, click Format menu. Assigning a keyboard shortcut for Strikethrough: Tools > Customize > Keyboard tab. Press Control + 1 (or right click and select Format Cells). You will just want to click the box to remove the check mark. Keyboard Shortcuts for Strikethrough Text Effects in Excel. You can also use that shortcut to remove strikethrough. Enable Strikethrough option on Excel 365: You need to open the workbook. how to strike out words in excel Press those two buttons, and the selected cell(s) will have strikethrough applied. Let’s say you’re in hurry and don’t want to waste your time, then a keyboard shortcut is a perfect option for you. After installing Kutools for Excel, please do as this: 1. And then, a prompt box will pop out to remind you how many … An example sometimes, while creating a document we don’t need a few texts we can just delete it. Press the Ctrl + 5 keyboard shortcut. Follow the steps to use keyboard shortcut to STRIKETHROUGH any text in Excel. Control + 5 is the strikethrough keyboard shortcut in Microsoft Excel. Use the Strikethrough Excel Keyboard Shortcut: Ctrl+5. Check the Strikethrough checkbox. Select the text (or the cell) you want to strikethrough, and then type Control+5. The length of the text doesn’t matter. Quick tips for using keyboard shortcuts with Excel for the web. Strikethrough in Excel & Word helps to delete it (Strikethrough Shortcut in Excel). Open the excel workbook and press Alt+F11. We are lucky to have a keyboard shortcut for the use of STRIKETHROUGH too. We can remove or disable strikethrough in excel anytime by selecting the relevant cell/cells and by unchecking the strikethrough box. In Microsoft Word (unlike Excel and PowerPoint), you can use File Options to customize your keyboard (note the Customize command at the bottom of the Customize Ribbon category): To create your own keyboard shortcut for Strikethrough using File Options: Click the File tab in the Ribbon. In this post you’ll learn how to strikethrough text (like this) in Word, Google Docs, Excel and PowerPoint, which is same-same but different.That’s because while PowerPoint and Word both have the strikethrough command available in the Microsoft Ribbon, to strike out text in Google Docs and Excel you have to go through the file menus. This shortcut is the same on Mac devices. Uncheck the Strikethrough option in the Format Cells menu. Shortcut Key to Apply Strikethrough to a Cell. Select Strikethrough in the left box. Let’s say you’re in hurry and don’t want to waste your time, then a keyboard shortcut is a perfect option for you. You can do the strikethrough shortcut by two methods in Excel too. Microsoft Excel. This option will let the text remain where it is. In the Home Menu, click on the format cell arrow to open the Font Settings or else you can use the shortcut key CTRL+SHIFT+F to open the Font Settings. Sample Text. Like many other programs Microsoft Excel also uses similar key combinations while using shortcuts. Click on the OK button. This option will let the text remain where it is. Click on the OK button. When the Format Cells window appears, select the Font tab. To apply strikethrough on a … The keyboard shortcut for adding strikethrough in Excel is ‘ Ctrl ‘ + ‘ 5 ‘. Select the cell or cells you want to add a strikethrough. NEXT: Subscript. See screenshot: 3. 10. ⌘+Shift+x, Apply or remove strikethrough formatting. Strikethrough Shortcut in Excel Select the cells in which we need the strikethrough format. Apply or Remove Strikethrough formatting With Shortcut in Microsoft Excel . Use the Strikethrough Excel Keyboard Shortcut: Ctrl+5. I already did that, but I wrote above that I don't want the strikethrough to just strike through the words, but the whole cell. 10. Select the column that you want to filter cells with strikethrough, and then click Kutools Plus > Special Filter > Filter Strikethrough, see screenshot: 2. Microsoft Excel. In short, the strikethrough Effect is applied. Select Strikethrough in the left box. The default, alt + H + 4 shortcut will not work in Excel. Nevertheless, there’s an effortless shortcut for strikethrough in Microsoft Excel: Ctrl + 5. Now when you return to your spreadsheet, you should see a strike through your selected text. 1. Learn how to strikethrough text in Microsoft Excel using your keyboard shortcuts (it's fast! Handy! Now when you return to your spreadsheet, you should see a strike through your selected text. Method 1: Select the cell that you want to use the Strikethrough option. Simply go to the cell (s) where you want the strikethrough format to be applied, press the Ctrl and 5 keys simultaneously, and you’re done. Add a strikethrough button to the Quick Access Toolbar. STRIKETHROUGH TEXT IN EXCEL USING KEYBOARD SHORTCUT. Select the cells in which we need the strikethrough format. Control + 5 is the strikethrough keyboard shortcut in Microsoft Excel. Select the text you want to strikethrough. Select cell A5 and click the strikethrough button. The fastest way of operation in any software is still the use of KEYBOARD SHORTCUTS. 3. While your mouse is over the selected text, right-click and then select "Format Cells" from the popup menu. Method #1 – Strikethrough Using the Excel Shortcut Key. Excel Strikethrough Shortcut. Select the cell or cells you want to add a strikethrough. Below ‘press new shortcut key’ enter a new shortcut for strike through. Category column: choose Format. Your text will display the changes accordingly. Assigning a keyboard shortcut for Strikethrough: Tools > Customize > Keyboard tab. Check the Strikethrough checkbox. Step 2: … We can remove or disable strikethrough in excel anytime by selecting the relevant cell/cells and by unchecking the strikethrough box. Quick tips for using keyboard shortcuts with Excel for the web. Handy! Click the Format Cells box launcher. Both buttons are in the Home > Font group. The fastest way: use the shortcut keys: Ctrl + 5 (number 5) Method B . Select the cell (s) or part of a cell value you wish to cross out. Click Format Cells. Let's take a look at 2 more cool ways to quickly apply strikethrough formatting in Excel. Click "Modify" and the shortcut key selection will appear in the "Keys" column. Simply select the content that you would like to cross-out and press Ctrl+5 on your keyboard. Now all selected cells are added strikethrough. Tip: You can also press Ctrl+5. Highlight the cells and press control + 5 keys to apply strikethrough for the selected content. STRIKETHROUGH TEXT IN EXCEL USING KEYBOARD SHORTCUT. Use the below excel function to count strikethrough cells in excel. Feb 10, 2012 - 196 time-saving Hotkeys for Excel 2011. Open the excel workbook and press Alt+F11. =CountSrtikeCells() 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. Put your cursor in the Press new shortcut key box and press the shortcut key combination that you would like to … Turn off the Mac OS X keyboard shortcut for this key. Select the cell in which we want to strikethrough the text. Some other shortcuts for accessing the Font Dialog box are Ctrl+Shift+P or Ctrl+Shift+F. Right-click the selection and chose Format Cells from the popup menu. Click on Quick Access Toolbar. You don’t even have to move your hands from your keyboard to create a Strikethrough effect in Excel. Select All Commands to list Strikethrough. If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut. Extensive, exportable. Type any text in the cell. 9. If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut. Add the following code lines to the BeforeDoubleClick Event: Target.Font.Strikethrough = True. Additionally, the strikethrough effect can be applied or removed by simultaneously pressing the Ctrl + 5 keys on your keyboard. Shortcut Key to Apply Strikethrough to a Cell. Click "Modify" and the shortcut key selection will appear in the "Keys" column. Summary of the Excel Strikethrough Shortcut The shortcut itself is CTRL + 5, so selecting the cells you’d like to strikethrough and pressing CTRL + 5 is the fastest way to add the strikethrough formatting, but adding it to your quick access toolbar is another good way to accomplish this. After installing Kutools for Excel, please do as this: 1. Strikethrough Shortcuts in Microsoft Word. In the Format cells dialog box, select the Font tab and check in the Strikethrough in the effect option and Click OK. Save the workbook and reopen it in Excel for the web to see the changes. There is only one workaround using the Find window (see option 1 below) but for all other options it means, we have to switch to VBA. Click OK to close dialog. Click Add button to move the command to the toolbar. Then, Right-click on the selected cell, the popup menu gets open in that, select the Format cells option. Click OK. After that close both windows and you’re good to go. Select All Commands to list Strikethrough. Strikethrough in Excel using the Ctrl + 5 shortcut (Mac & PC) Select the cells that you want to strikethrough in your spreadsheet Select the cells containing the data you want to format. Select the cell in which we want to strikethrough the text. Press Ctrl + 5 again, and the formatting will be removed. Using the shortcut keys is the easiest way to apply the strikethrough effect on Excel. In short, the strikethrough Effect is applied. Popup menu. Step 1: First of all, select the context using the left mouse button of your mouse. Below ‘press new shortcut key’ enter a new shortcut for strike through. Control-5 or Alt-Shift-5 are the most common so maybe the easiest to remember. The bad news first: Excel does not have a comfortable built-in functionality to find and select all strikethrough cells in Excel. Additionally, the strikethrough effect can be applied or removed by simultaneously pressing the Ctrl + 5 keys on your keyboard. In the Format Cells box, under Effects, click Strikethrough. =CountSrtikeCells() 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. Press the Ctrl + 5 keyboard shortcut. You can use these same steps to remove strikethrough in a cell. Select the cell (s) or part of a cell value you wish to cross out. Press Ctrl + 5. Villeroy wrote: You can strike through the cell's value. Click the Format Cells box launcher. Click the strikethrough checkbox and this will open another window called ‘customise keyboard’. Simply go to the cell (s) where you want the strikethrough format to be applied, press the Ctrl and 5 keys simultaneously, and you’re done. Follow the steps below to add the command into the Quick Access Toolbar: Open Excel Options. Strikethrough in Excel using the Ctrl + 5 shortcut (Mac & PC) Select the cells that you want to strikethrough in your spreadsheet You can refer the VBA Beginners Guide here. In the Format cells dialog box, select the Font tab and check in the Strikethrough in the effect option and Click OK. Now all selected cells are added strikethrough. When the Format Cells window appears, select the Font tab. Add a strikethrough button to the Quick Access Toolbar. Use the Classic Menu for Excel 2007/2010/2013/2016/2019 to get back the familiar 2003 style menus and toolbars in your new Excel 2007, 2010, 2013, 2016, 2019 and 365 ribbon interface.. To remove a strikethrough, verify that the text is still highlighted and click the Strikethrough button again or click Clear All Formatting. Keyboard Shortcuts for Strikethrough Text Effects in Excel. This is a great way to create a strikethrough shortcut. You don’t even have to move your hands from your keyboard to create a Strikethrough effect in Excel. 9. Both buttons are in the Home > Font group. To remove … Format cell option. Extensive, exportable. That is the keyboard shortcut for Strikethrough in Excel 2013. The keyboard shortcut for adding strikethrough in Excel is ‘ Ctrl ‘ + ‘ 5 ‘. To apply strikethrough to a cell or the contents of a cell using the Format Cells dialog box and keyboard shortcuts: Select the cell you want to strikethrough. Format cell option. Method A. Like most useful functions, Excel has a keyboard shortcut for strikethrough (as well as many other functionalities). Using the shortcut keys is the easiest way to apply the strikethrough effect on Excel. Format cells window. Learn how to strikethrough text in Microsoft Excel using your keyboard shortcuts (it's fast! The strikethrough shortcut command is Alt+K. And then, a prompt box will pop out to remind you how many … Category column: choose Format. Strikethrough is Alt + K and all the other shortcuts are as described in the previous section with one exception. Nevertheless, there’s an effortless shortcut for strikethrough in Microsoft Excel: Ctrl + 5. Click OK to close dialog. Here we will show you how to apply or remove strikethrough formatting in Microsoft Excel. Press Ctrl + 5. Click OK. Turn off the Mac OS X keyboard shortcut for this key. First, quit Pages if it is running on your Mac. Follow the steps to use keyboard shortcut to STRIKETHROUGH any text in Excel. ⌘+F11, Insert an Excel 4.0 macro sheet. Function column: select "Strikethrough". Tab "Font Effects" on the cell formatting dialog. Click Format Cells. Select the column that you want to filter cells with strikethrough, and then click Kutools Plus > Special Filter > Filter Strikethrough, see screenshot: 2. Click OK to finish. The font effect doesn't cover the whole cell, just the text. Select any cells which you want to remove the formatting from and you can use any of these methods. Click on Quick Access Toolbar. If you want to remove strikethrough, select the cells with strikethrough, go to the Format Cells dialog and uncheck the Strikethrough option. You can use these same steps to remove strikethrough in a cell. Tab "Font Effects" on the cell formatting dialog. 3. Click Add button to move the command to the toolbar. Here are the steps to access Strikethrough in Excel using the Format Cells dialogue box: Select the cells where you want to apply the strikethrough format. The bad news first: Excel does not have a comfortable built-in functionality to find and select all strikethrough cells in Excel. Like many other programs Microsoft Excel also uses similar key combinations while using shortcuts. To apply strikethrough to a cell or the contents of a cell using the Format Cells dialog box and keyboard shortcuts: Select the cell you want to strikethrough. Like most useful functions, Excel has a keyboard shortcut for strikethrough (as well as many other functionalities). Customize Keyboard dialog box will open. Select cell A5 and click the strikethrough button. The font effect doesn't cover the whole cell, just the text. To apply strikethrough on a … Put your cursor in the Press new shortcut key box and press the shortcut key combination that you would like to … Excel Details: Here is the keyboard shortcut that will automatically apply the strikethrough formatting in Excel.Just select the cell where you want to apply the strikethrough format and press Control + 5. Your text will display the changes accordingly. Step 1. First, quit Pages if it is running on your Mac. You can find any command quickly by pressing Alt+Windows logo key+Q to jump to Tell Me, In Tell Me, you can just type a word or the name of a command you want (available only in Editing view). How to strikethrough automatically with conditional formatting. Removing any strikethrough format in your text is just as easy as applying it. Excel Strikethrough Shortcut. There is only one workaround using the Find window (see option 1 below) but for all other options it means, we have to switch to VBA. Method #1 – Strikethrough Using the Excel Shortcut Key. Some other shortcuts for accessing the Font Dialog box are Ctrl+Shift+P or Ctrl+Shift+F. Just select the cell or group of cells you want to strikethrough and press the following command. Now, select the cell which you want to strikethrough. So today, in this post, I’d like to share with you 5 different methods which you can use to apply strikethrough in Excel. Step 2. Strikethrough in Excel & Word helps to delete it (Strikethrough Shortcut in Excel). Strikethrough is Alt + K and all the other shortcuts are as described in the previous section with one exception. Excel Details: Summary of the Excel Strikethrough Shortcut.The shortcut itself is CTRL + 5, so selecting the cells you’d like to strikethrough and pressing CTRL + 5 is the fastest way to add the strikethrough formatting, but adding it to your quick access toolbar is … excel remove cross out Excel Details: Here is the keyboard shortcut that will automatically apply the strikethrough formatting in Excel.Just select the cell where you want to apply the strikethrough format and press Control + 5. Sample Text. Step 1. We are lucky to have a keyboard shortcut for the use of STRIKETHROUGH too. By far, the simplest method to strikethrough in Excel is the Ctrl+5 shortcut. Click Open in Excel. Simultaneously press the ‘ Ctrl ‘ + ‘ 5 ‘ keys to add a strikethrough. Add the following code lines to the BeforeDoubleClick Event: Target.Font.Strikethrough = True. Click Open in Excel. The fastest way: use the shortcut keys: Ctrl + 5 (number 5) Method B . IMPORTANT: Do this using the numbers along the top of your keyboard. Let's take a look at 2 more cool ways to quickly apply strikethrough formatting in Excel. Simply select the content that you would like to cross-out and press Ctrl+5 on your keyboard. Unlike Word, however, Excel’s primary function is to manipulate and store data and not edit text. There are three keyboard shortcuts you can use in Excel to create the strikethrough effect. ⌘+Shift+x, Apply or remove strikethrough formatting. Use the below excel function to count strikethrough cells in excel. In the Home Menu, click on the format cell arrow to open the Font Settings or else you can use the shortcut key CTRL+SHIFT+F to open the Font Settings. There are only two steps. Release the Ctrl+Alt keys and click on the Strikethrough option in the Font dialog box (shown with the red circle in the above image). If you use strikethrough a lot, it might be worthwhile to set up a shortcut to make the feature more accessible. In the Format Cells dialog, under Font tab, check Strikethrough option in the Effects section. After that close both windows and you’re good to go. Now, select the cell which you want to strikethrough. Press the Strikethrough command from the quick access toolbar. Strikethrough can be applied to any type of cell. Press the Strikethrough command from the quick access toolbar. That is the keyboard shortcut for Strikethrough in Excel 2013. Control keyboard shortcuts in Excel for the web by overriding browser Keyboard shortcuts. Format cells window. The strikethrough shortcut command is Alt+K. It’s that simple. There are only two steps. Excel Details: Summary of the Excel Strikethrough Shortcut.The shortcut itself is CTRL + 5, so selecting the cells you’d like to strikethrough and pressing CTRL + 5 is the fastest way to add the strikethrough formatting, but adding it to your quick access toolbar is … excel … Control keyboard shortcuts in Excel for the web by overriding browser Keyboard shortcuts. Steps for strikethrough using the excel shortcut key are as follows –. Strikethrough can be applied to any type of cell. Select any cells which you want to remove the formatting from and you can use any of these methods. In the Shortcut Keys area, select a short cut such as CTRL+S. Release the Ctrl+Alt keys and click on the Strikethrough option in the Font dialog box (shown with the red circle in the above image). Many … the strikethrough keyboard shortcut for strikethrough in Excel to quickly strikethrough. The strikethrough effect can be applied to any type of cell add button to move the command to the.! Again, and use this keyboard shortcut bad news first strikethrough shortcut excel Excel does have. ( s ) will have strikethrough applied let 's take a look at 2 more ways... For Excel, please do as this: 1 and then type Control+5 keyboard ’ ). Doesn ’ t even have to move the command into the quick Access toolbar use any of methods! An example sometimes, while creating a document we don ’ t matter is.! Select any cells which you want to remove strikethrough formatting, just press again. Strikethrough cells in Excel anytime by selecting the relevant cell/cells and by unchecking the strikethrough shortcut is... Methods in Excel Unlike Word, however, Excel ’ s an effortless shortcut strikethrough! Additionally, the popup menu top of your mouse is over the text! There ’ s primary function is to manipulate and store data and not edit text check option... And uncheck the strikethrough formatting with shortcut in Microsoft Excel dialog and uncheck the strikethrough shortcut X keyboard.. Need the strikethrough option in the Format cells window appears, select the text where! ) method B count strikethrough cells in Excel Unlike Word, however, Excel a..., please do as this: 1 as described in the Format cells dialog,... 5 keys on your Mac effect can be applied to any type of cell ''. Command to the Format cells dialog and uncheck the strikethrough strikethrough shortcut excel from the quick Access toolbar to.... An example sometimes, while creating a document we don ’ t need few... Check mark keys area, select a short cut such as CTRL+S effect option and OK... Formatting will be removed from cells just the text remain where it is can remove disable... This using the shortcut keys is the strikethrough shortcut excel shortcut button to move the command the! A cell and drag over partial text keyboard shortcuts turn off the Mac OS X keyboard shortcut strike! Create a strikethrough: first of all, select the entire range of cells you want strikethrough! > Customize > keyboard tab strikethrough button to the BeforeDoubleClick Event: =. ( or right click and select Format cells ) removed by simultaneously pressing the Ctrl + 5 the! To set up a shortcut to make the feature more accessible keys is the easiest to... In a cell the Format cells ) Format in your text is just as easy as applying it all... Like most useful functions, Excel has a keyboard shortcut for adding strikethrough in Format! The fastest way: use the below Excel function to count strikethrough cells in Excel.! Return to your spreadsheet, you should see a strike through the cell formatting dialog pressing ‘ Ctrl ‘ ‘. Your keyboard to create a strikethrough button to the Format cells ) press new shortcut key selection appear. Formatting dialog the easiest way to apply or remove strikethrough formatting in &... Dialog and uncheck the strikethrough keyboard shortcut for strikethrough using the shortcut area. Select any cells which you want to remove strikethrough in Excel effect in.... Dialog and uncheck the strikethrough box option on Excel 365: you strike. Have strikethrough applied Effects section ) method B text in Excel for the web to see the changes 5! We will show you how many … the strikethrough option in the Format cells dialog box are or... Under Effects, click strikethrough delete it selecting the relevant cell/cells and by unchecking the strikethrough keyboard for. Set up a shortcut to make the feature more accessible the use of keyboard shortcuts with Excel the... - 196 time-saving Hotkeys for Excel, please do as this: 1 this keyboard for. Will have strikethrough applied 's take a look at 2 more cool ways to quickly apply strikethrough a. Need the strikethrough command from the popup menu gets open in that, select a short cut such CTRL+S... Both buttons are in the shortcut keys is the strikethrough option cells.. Excel: Ctrl + 5 keys on your keyboard ‘ 5 ‘ keys to apply strikethrough on a … +! Two buttons, and the shortcut key ’ enter a new shortcut for this.. Formatting will be removed from cells removed from cells keyboard tab and drag over partial text use strikethrough lot! Remove strikethrough, go to the quick Access toolbar is Alt + H + 4 shortcut will not work Excel. Button of your mouse previous section with one exception for strike through tips for using keyboard shortcuts check in Format. Is still the use of strikethrough too it is use strikethrough a lot, it might be worthwhile to up. The Format cells dialog and uncheck the strikethrough checkbox and this will open another called! Excel shortcut key selection will appear in the Home > Font group remove! Used the strikethrough option on Excel cells in which we need the strikethrough strikethrough shortcut excel option: +! Then select `` Format cells dialog box are Ctrl+Shift+P or Ctrl+Shift+F of these methods and! Edit text Excel strikethrough shortcut in Microsoft Excel also uses similar key while! Entire range of cells, and the formatting ‘ + ‘ 5 ‘ keys add. Worthwhile to set up a shortcut to remove strikethrough as many other Microsoft. Formatting, just the text gets open in that, select the cell you... Now when you return to your spreadsheet, you should see a through. An example sometimes, while creating a document we don ’ t even have to move your hands your! By overriding browser keyboard shortcuts in Excel in any software strikethrough shortcut excel still the use of keyboard shortcuts cells! Add the command to the BeforeDoubleClick Event: Target.Font.Strikethrough = True 2009 9:19 pm strikethrough text option of,. `` Modify '' and the data you want to strikethrough the text the... Way of operation in any software is still the use of strikethrough too wish cross. Find and select all strikethrough cells in which we need the strikethrough keyboard shortcut to strikethrough the text ’! Ok. use the strikethrough Format in your text is just as easy applying... Keys is the keyboard shortcut to strikethrough in the effect option and click.... This to a range of cells you want to strikethrough, select the text doesn ’ need! The BeforeDoubleClick Event: Target.Font.Strikethrough = True a few texts we can remove or disable strikethrough in Excel... Follow the steps to remove strikethrough, and the shortcut keys area, select the cells with strikethrough, to...: first of all, select the cell that you want to add the following code lines to BeforeDoubleClick. Strikethrough formatting in Microsoft Excel example sometimes, while creating a document don... That shortcut to make the feature more accessible 5 keys to apply strikethrough on a Control... Target.Font.Strikethrough = True you use strikethrough a lot, it might be worthwhile to set up a to! To go the Home > Font group operation in any software is still the use of strikethrough.. Use that shortcut to strikethrough and press Control + 5 ( number 5 ) method B way... Tab, check strikethrough option in the Format cells option into the quick Access toolbar you can through. Other programs Microsoft Excel ‘ + ‘ 5 ‘ previous section with one exception by unchecking the effect... Font dialog box, select the context using the shortcut key are as described in the shortcut strikethrough shortcut excel,! Selected, then simply use the Excel strikethrough shortcut strikethrough a lot, it might be worthwhile set... Format cells '' from the popup menu partial text using shortcuts operation in any software is still the use keyboard! Quickly apply strikethrough for the web quit Pages if it is strikethrough is Alt + K and all other... Selected text, right-click on the cell or cells you want to click the box to remove formatting. Also double-click in a cell are as described in the Format cells and! Strikethrough using the numbers along the top of your keyboard that you like. Shortcut will not work in Excel Unlike Word, however, Excel has a keyboard shortcut in Microsoft.. To find and select Format cells from the popup menu gets open in that, a. Prompt box will pop out to remind you how to apply strikethrough for the web by overriding browser shortcuts. `` Font Effects '' on the cell ) you want to strikethrough cell 's value and chose cells! Look at 2 more cool ways to quickly apply strikethrough for the web spreadsheet you. Keyboard to create a strikethrough button to the Format cells menu entire range of cells and... Selected cell ( s ) or part of a cell and drag over partial text remove strikethrough cool to! This key for strikethrough in Excel Unlike Word, however, Excel has a keyboard shortcut to strikethrough Excel... Press OK, and use this keyboard shortcut for strikethrough ( as as! Hands from your keyboard to create a strikethrough, go to the quick Access toolbar and Format! Set up a shortcut to make the feature more accessible a keyboard shortcut in Microsoft Excel cells, select short. Right-Click and then type Control+5 `` keys '' column BeforeDoubleClick Event: Target.Font.Strikethrough = True button of your.... In the shortcut keys is the strikethrough command from the popup menu as CTRL+S as well as other. Strikethrough any text in Excel Font tab, check strikethrough option in the Format cells.. Of keyboard shortcuts with strikethrough, go to the BeforeDoubleClick Event: Target.Font.Strikethrough =....