- #Strikethrough in excel shortcut keys how to#
- #Strikethrough in excel shortcut keys manual#
This option was first introduced in the Microsoft Excel 2007. The Strikethrough command is not available on the MS Excel ribbon Excel Ribbon The ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs it is available at the top of the excel sheet. Method #4 – Adding the Strikethrough Button to the Ribbon read more to apply the strikethrough format to the selected text.
#Strikethrough in excel shortcut keys manual#
As the command is at the fourth position, we can use Alt+4 as a shortcut excel key Shortcut Excel Key An Excel shortcut is a technique of performing a manual task in a quicker way.
Step 5 – We can find the “Strikethrough” command at fourth place on the QAT. We have changed the position of the “Strikethrough” button to the fourth on the QAT. Step 4 – We can use the up and down arrow buttons on the right side to change the position of the strikethrough button. Step 3 – From the list, choose “ Strikethrough” and click on the “Add” button to add the command button to the Quick Access Toolbar. 
Now, choose “Commands Not in the Ribbon” for “Choose commands from.”
Step 2 – The “Excel Options” dialog box appears. Step 1 – Right-click on the ribbon and choose “Customize Quick Access Toolbar” from the pop-up menu. To add the button to the QAT, the steps are: read more is a one-time setup, and we can use the button from QAT (Quick Access Toolbar) whenever required. It enables users to save important shortcuts and easily access them when needed. Method #3 – By adding the Strikethrough button to Quick Access ToolbarĪdding the “Strikethrough” button to the Quick Access toolbar Quick Access Toolbar Quick Access Toolbar (QAT) is a toolbar in Excel that may be customized and is located on the upper left-hand side of the window. Now, you can see the result as shown in the below image. Step 3 – In the “Format Cells” dialog box, we need to go to the “Font” tab and tick off the “Strikethrough” option under “ Effects, ” then click on “OK” to save the change and close the dialog box. Step 2 – Press the shortcut key “Ctrl + 1,” or we can right-click the selected cell(s) and choose “Format Cells” from the pop-up menu. Step 1 – Select one or more cells on which we want to apply the strikethrough. We want to strikethrough the value as we complete each step. Suppose we have the following data for steps. Press the “Enter” key to get out of the edit mode. Press the “Ctrl+5” keys to strikethrough the text. 
Press the “F2” key to enter edit mode or double-click on the cell. Otherwise, we need to go into “Edit Mode” for the particular cell by double-clicking on the cell or using the “F2” key, selecting the text, and pressing the “Ctrl+5” keys. In our example, we do not have a requirement to highlight only some part of the value in the cell. Select one or more cells using the “Shift” key with the “Up,” “Down,” “Left,” and “Right” arrow keys and press the “Ctrl+5” keys. Now, let us discuss each of the methods with an example. Adding a Button for Strikethrough Using VBA. Strikethrough Text using Conditional Formatting. Adding the Strikethrough Button to the Ribbon. 
Adding Strikethrough Button to Quick Access Toolbar.Strikethrough Text Using the Format Options.Source: Strikethrough Text in Excel () 6 Different Methods to Strikethrough Text in Excel
#Strikethrough in excel shortcut keys how to#
You are free to use this image on your website, templates, etc, Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked
Method #6 – Adding a Button for Strikethrough Using VBA. Method #5 – Using Conditional Formatting to Strikethrough Automatically. Method #4 – Adding the Strikethrough Button to the Ribbon. Method #3 – By adding the Strikethrough button to Quick Access Toolbar. Method #1 – Strikethrough Text Using the Shortcut Key. 6 Different Methods to Strikethrough Text in Excel.
0 kommentar(er)
