Top 6 Easy Methods To Strikethrough Text In Excel Examples

Excel Strikethrough Text

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Strikethrough Text in Excel (wallstreetmojo.com)

6 Different Methods to Strikethrough Text in Excel

Strikethrough Text using Shortcut KeyStrikethrough Text Using the Format OptionsAdding Strikethrough Button to Quick Access ToolbarAdding the Strikethrough Button to the RibbonStrikethrough Text using Conditional FormattingAdding a Button for Strikethrough Using VBA

Now, let us discuss each of the methods with an example.

Method #1 – Strikethrough Text Using the Shortcut Key

Now, suppose we have a project. The steps for the project are given in the below image.

Method #2 – Using the Format Options

Suppose we have the following data for steps. We want to strikethrough the value as we complete each step.

Steps are:

Select one or more cells using the “Shift” key with the “Up,” “Down,” “Left,” and “Right” arrow keys and press the “Ctrl+5” keys. In our example, we do not have a requirement to highlight only some part of the value in 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. Press the “F2” key to enter edit mode or double-click on the cell. Press the “Ctrl+5” keys to strikethrough the text. Press the “Enter” key to get out of the edit mode.

In our example, we do not have a requirement to highlight only some part of the value in 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.

Step 1 – Select one or more cells on which we want to apply the strikethrough.
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 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.

Now, you can see the result as shown in the below image.

Adding the “Strikethrough” button to the Quick Access toolbarQuick Access ToolbarQuick Access Toolbar (QAT) is a toolbar in Excel that may be customized and is located on the upper left-hand side of the window. It enables users to save important shortcuts and easily access them when needed.read more is a one-time setup, and we can use the button from QAT (Quick Access Toolbar) whenever required.

To add the button to the QAT, the steps are:

Step 1 – Right-click on the ribbon and choose “Customize Quick Access Toolbar” from the pop-up menu.
Step 2 – The “Excel Options” dialog box appears. Now, choose “Commands Not in the Ribbon” for “Choose commands from.”
Step 3 – From the list, choose “Strikethrough” and click on the “Add” button to add the command button to the Quick Access Toolbar.
Step 4 – We can use the up and down arrow buttons on the right side to change the position of the strikethrough button. We have changed the position of the “Strikethrough” button to the fourth on the QAT. Click on “OK.”
Step 5 – We can find the “Strikethrough” command at fourth place on the QAT. As the command is at the fourth position, we can use Alt+4 as a shortcut excel keyShortcut Excel KeyAn Excel shortcut is a technique of performing a manual task in a quicker way.read more to apply the strikethrough format to the selected text.

Method #4 – Adding the Strikethrough Button to the Ribbon

The Strikethrough command is not available on the MS Excel ribbonExcel RibbonThe 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. This option was first introduced in the Microsoft Excel 2007.read more by default. We can find out the same only in the “Format Cells” dialog box. However, we can add the same command on the ribbon too. To do the same, the steps are:

Step 1 – Right-click anywhere on the ribbon and choose “Customize the Ribbon in excelRibbon In ExcelRibbons in Excel 2016 are designed to help you easily locate the command you want to use. Ribbons are organized into logical groups called Tabs, each of which has its own set of functions.read more from the pop-up menu.
Step 2 – Choose “Commands Not in the Ribbon” for “Choose commands from” and select “Strikethrough” from the list.
Step 3 – Before adding the “Strikethrough” command on the ribbon, first create the group using the “New Group” To make the new group, the steps are:Select the tab under which you want to create the group. (In this case, the tab is the “Home” tab)Click on “New Group.”Rename the group using “Rename.”
Step 4 – Add the “Strikethrough” command in thenew group (My Format (Custom).”
Step 5 – We can change the group’s position using the up and down arrow button on the right side of the dialog box, then click “OK.”
We can see a new “My Format” group under the “Home” tab.
Suppose we need to format some of the text with strikethrough.

To Strikethrough the values, the steps are:

Select the tab under which you want to create the group. (In this case, the tab is the “Home” tab)Click on “New Group.”Rename the group using “Rename.”
Select the cells we need to format, then choose the “Strikethrough” command from the “My Format” group under the “Home” tab.

Method #5 – Using Conditional Formatting to Strikethrough Automatically

We can Strikethrough the Text using conditional formatting in excelConditional Formatting In ExcelConditional formatting is a technique in Excel that allows us to format cells in a worksheet based on certain conditions. It can be found in the styles section of the Home tab.read more.

Suppose we have a task list that we need to accomplish. Then, we can update the status for the task as “Done,” We will format the task value with a strikethrough, and the font color will be changed to blue automatically.

To do the same, the steps are:

Step 1 – Select the cells to format.
Step 2 – Go to the “Home” tab. From the “Styles” group, choose “Conditional Formatting.” Next, select “New Rule” from the drop-down list in excelDrop-down List In ExcelA drop-down list in excel is a pre-defined list of inputs that allows users to select an option.read more.
Step 3 – Choose “Use a formula to determine which cells to format.”
Step 4 – For “Format values where this formula is true,” Specify =$B3=”Done” and set the format as below.
Step 5 – Click on “OK” for both the dialog boxes, “Format Cells” and “New Formatting Rules.”

Now, whenever we update the status for a task as “Done.” The value is formatted.

Method #6 – Adding a Button for Strikethrough Using VBA

We can also create a command button for the same using VBAUsing VBAVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more.

Step 1 – Choose the “Command button” from the “Insert” command available in the “Controls” group under the Developer tab excel.
Step 2 – Create the command button and change the ”Properties.”
Step 3 – Click on “View Code” from the “Controls” group after closing the properties dialog box. (Ensure the button is selected and “Design Mode” is activated.)
Step 4 – Choose “Strikethrough” from the list and paste the following code.
Step 5 – Save the file with .xlsm

Suppose we want to strikethrough two cells (A1 and A2). We can do the same by selecting the cells and pressing the command button (make sure the “Design Mode” is deactivated).

Select the cells and click on the button.

Excel Strikethrough Text#

6 Different Methods to Strikethrough Text in Excel#

Method #1 – Strikethrough Text Using the Shortcut Key#

Method #2 – Using the Format Options#

Method #4 – Adding the Strikethrough Button to the Ribbon#

Method #5 – Using Conditional Formatting to Strikethrough Automatically#

Method #6 – Adding a Button for Strikethrough Using VBA#

Recommended Articles#