Excel Functions Tutorials
- Excel Tips
- Excel vs Access
- Excel Rows vs Columns
- Apple Numbers vs Excel
- 3D Reference in Excel
- Absolute Reference in Excel
- Mixed References in Excel
- Excel Reference to Another Sheet
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- AutoCorrect in Excel
- AutoSave in Excel
- AutoRecover in Excel
- Bullet Points in Excel
- Break Links in Excel
- Barcode in Excel
- Change Case in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Column Lock in Excel
- Move Columns in Excel
- Custom List in Excel
- Consolidate in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Compare and Match Columns in Excel
- Compound Interest Formula in Excel
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Convert Excel to CSV
- Count Characters in Excel
- Count Rows in Excel
- Count Unique Values in Excel
- Countif not Blank in Excel
- Create Templates in Excel
- Family Tree in Excel Template
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Dashboard in Excel
- KPI Dashboard in Excel
- Date to Text in Excel
- Date Format in Excel
- Database in Excel
- Delta Symbol in Excel
- $ Symbol in Excel
- Excel Column to Number
- Edit Drop-Down List in Excel
- Equations in Excel
- Exponents in Excel
- Excel Extensions
- Excel Translate
- Excel Not Responding
- Excel Find and Replace
- Find and Select in Excel
- Excel Subtraction Formula
- Excel Formula for Grade
- Excel as Calculator
- Excel Formula Not Working (Updating)
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Excel Alternate Row Color
- Excel Worksheet Tab
- Extract Number from String Excel
- Evaluate Formula in Excel
- Find Duplicates in Excel
- Finding Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Format Numbers to Millions & Thousands in Excel
- Format Phone Numbers in Excel
- Formula Errors in Excel
- Fractions in Excel
- Frequency Distribution in Excel
- Group in Excel
- Group Worksheets in Excel
- Group Columns in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- Highlight Duplicates in Excel
- How to Create a Formula in Excel?
- How to Create an Excel Spreadsheet?
- How to Add Text in Excel Formula?
- How to Create Dashboard in Excel?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Calculate Percentage Increase in Excel?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Date in Excel
- Insert Calendar in Excel
- Import Data into Excel
- Insert Comment in Excel
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Insert New Worksheet in Excel
- Insert (Embed) an Object in Excel
- Insert Image in Excel Cell
- Insert Page Break in Excel
- Line Breaks in Excel
- Linear Interpolation in Excel
- Leading Zeros in Excel
- Last Day of the Month in Excel
- Logical Operators in Excel
- Lookup Table in Excel
- Mortgage Calculator in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Name Manager in Excel
- Page Numbers in Excel
- Page Break in Excel
- Personal Budget Template in Excel
- Project Management Template in Excel
- Percentage Difference in Excel (Increase / Decrease)
- Pivot Table Calculated Field & Formula
- Pivot Table Sort
- Pivot Table From Multiple Sheets
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Print Preview in Excel
- Print Area in Excel
- Print Titles in Excel
- Print Labels From Excel
- Project Timeline in Excel
- Protect Sheet in Excel
- Ratio in Excel Formula
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Duplicates from Excel Column
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Remove Leading Spaces in Excel
- Remove Watermark in Excel
- Row Limit in Excel
- Rows and Columns in Excel
- Rows to Columns in Excel
- Row Header in Excel
- Search in Excel
- Search For Text in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Separate Text in Excel
- Strikethrough in Excel
- Strikethrough Text in Excel
- Sum by Color in Excel
- Subscript in Excel
- Superscript in Excel
- Themes in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Word Count in Excel
- Word Cloud in Excel
- Watermark in Excel
- Weighted Average in Excel
- Wildcard in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tools (98+)
- VBA (162+)
Strikethrough means drawing a line in a cell, so strikethrough text 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.
Strikethrough Text Excel (Table of Contents)
- By Using the Shortcut Key
- By Using the Format Options
- By adding Strikethrough button to QAT
- By Adding the Strikethrough Button to the Ribbon
- By Using Conditional Formatting
- Using VBA
Excel Strikethrough Text
Strikethrough is to draw a line through a value or text in Excel. The Purpose of Strikethrough values in excel is
- To show edits
- To denote completed tasks
How to Strikethrough Text in Excel?
Below are the following ways to Strikethrough text in excel.
Method #1 – By Using the Shortcut Excel Key to Strikethrough
Now suppose, we have a project. The steps for the project are given in the below image.
As we will complete each step, we want to Strikethrough the step, for this, the steps are so simple.
- Select the cells, one or more using the Shift key with Up, Down, Left and Right arrow key and press Ctrl+5.
- In our example, we don’t have a requirement to highlight only some part of the value in the cell, otherwise, first, we need to go into edit mode for the particular cell by double-clicking on the cell or using the F2 key and then select the text and then pressing Ctrl+5.
Press F2 to enter into edit mode or double click on the cell.
Press Ctrl+5 to strikethrough the text.
Press Enter to get out of the edit mode.
Method #2 – By Using the Format Options
- Suppose, we have the following data for steps. We want to Strikethrough the value as we complete each step.
- Select one or more cells on which we want to apply the Strikethrough.
- Press the shortcut key Ctrl + 1 or we can right-click the selected cell(s) and choose ‘Format Cells’ from the pop-up menu.
- 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.
Method #3 – By adding Strikethrough button to Quick Access Toolbar
Quick Access toolbar is found at the top left corner of MS Excel Window. We can place various frequently used commands on the Quick Access Toolbar as this helps us to save time. We can use shortcut as well to access the commands on the Quick Access Toolbar.
With the combination of Alt key and number key, we can make the strikethrough excel shortcut key.
To add the Strikethrough button to the Quick Access toolbar is one time set up, and then we can use the button from QAT (Quick Access Toolbar) whenever required.
To add the button to the QAT, steps are:
- right-click anywhere on the ribbon and choose ‘Customize Quick Access Toolbar’ from the pop-up menu.
- The ‘Excel Options’ dialog box appears. Now choose ‘Commands Not in the Ribbon’ for ‘Choose commands from’.
- From the list, choose ‘Strikethrough’ and click on ‘Add’ button to add the command button to the Quick Access Toolbar.
- The up and down arrow buttons on the right side can be used to change the position of the Strikethrough button. We have changed the position of the ‘Strikethrough’ button to 4th on the QAT. Click on OK.
We can find out the ‘Strikethrough’ command at 4th place on the QAT. As the command is at 4th position, we can also use Alt+4 as a shortcut excel key to apply Strikethrough format to the selected text.
Suppose, we need to Strikethrough the Text as we learn the tabs of MS Excel Window.
As any tab is learned by the user, the user can Strikethrough the Text using the excel shortcut key (Alt+4) or the button placed on QAT.
- To select one or more cells (adjacent cells with the Shift key and non-adjacent cells using Ctrl key).
- Press Alt+ 4 or press Strikethrough button from the QAT.
Method #4 – By Adding the Strikethrough Button to the Ribbon
Strikethrough command is not available on the MS Excel ribbon 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:
- Right-click anywhere on the ribbon and choose “Customize the Ribbon“ from the pop-up menu.
- Choose “Commands not in the Ribbon” for “Choose commands from” and select “Strikethrough” from the list”
- Before adding Strikethrough command on the ribbon, first create the group using the “New Group” To create the new group, steps are:
- Select the tab under which you want to create the group. (In our case, the tab is “Home” tab.)
- Click on “New Group”.
- Rename the group using “Rename”.
- Now add the “Strikethrough” command in New group (My Format).
We can change the position of the group using the up and down arrow button on the right side of the dialog box then click ‘OK’.
Now we can see a new group “My Format” under the Home tab.
Suppose, we need to format some of the Text with Strikethrough.
To Strikethrough the values, steps are:
- Select the cells which we need to format then, choose ‘Strikethrough’ command from the ‘My Format’ group under the Home tab.
Method #5 – By Using Conditional Formatting to Strikethrough Automatically
We can Strikethrough the Text in excel using conditional formatting also.
Suppose we have a task list, which we need to accomplish. We can update status for the task as “Done”, the task value will be formatted with Strikethrough, and font color will be changed to blue automatically.
To do the same, the steps are:
- Select the cells to format.
- Go to the Home tab, from the “Styles” group choose “Conditional Formatting” from that choose “New Rule” from the drop-down list.
- Choose “Use a formula to determine which cells to format”.
- For “Format values where this formula is true”, Specify =$B3=”Done” and set the format as below.
- 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 – By Adding a Button for Strikethrough Using VBA
We can also create a command button for the same using VBA.
- Choose “Command button” from the “Insert” command available in the “Controls” group under “Developer” tab.
- Create the command button and change the properties.
- Click on “View Code” from the “Controls” group after closing the properties dialog box. (Make sure the button is selected and “Design Mode” is activated.)
- Choose “Strikethrough” from the list and paste the following code.
- Save the file with .xlsm
Now 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.
This has been a guide to Strikethrough Text in Excel. Here we discuss how to Strikethrough Text in Excel using 6 different ways along with shortcuts, examples and downloadable excel template. You may learn more about excel from the following articles –