What is Strikethrough in Excel?

Top 5 Methods to use Strikethrough in Excel

Below are the different methods of using the strikethrough shortcut in Excel.

  • Using Excel Shortcut KeyUsing Format Cell OptionsUsing from Quick Access ToolbarUsing it from 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 moreUsing Dynamic Conditional Formating

Let us discuss each method in detail with an example.

Method #1 – Strikethrough Using the Excel Shortcut Key

Method #2 – Strikethrough Using the Format Cells Option

  • Step 1: Select the cells that need this format and then right-click on the cell and choose the option of “Format Cells.”

  • Step 2: Now, go to the “Font” tab, select the “Strikethrough” option and Click “OK.”

Step 3: After clicking on “OK,” the cell will get the strikethrough format.

  • First, select the cells in which we need the strikethrough format. Once the cells are selected, use the Excel strikethrough shortcut key, “Ctrl+5.” The data will strike out.

Method #3 – Strikethrough Using this option from Quick Access Toolbar

This option is not available in the ribbon and in the Quick Access toolbarRibbon And In The Quick Access ToolbarRibbons 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. So, we will now add this to the toolbar.

  • Step 1: Click on the ribbon and go to the “Customize 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.

  • Step 2: From the “Choose commands from” option, choose “Commands Not in the Ribbon.

  • Step 3: Select the “Strikethrough” command, click on “Add,” and click on “OK.”

  • Step 4: After the option is added, it will appear below.

  • Step 5: Select the data you want to strikethrough and click on “Strikethrough,” as shown in the screenshot below.

  • It will strikethrough the selected cells.

Method #4 – Using it from 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

  • Step 1: Right-click on the “Font” tab and choose the option of “Customize the Ribbon.”

  • Step 2: From the “Excel Options” tab, choose to add “New Tab,” choose the “Strikethrough” option and click on “OK.”

  • Step 3: After the option is added in a “New Tab,” this will appear below in the ribbon.

Step 4:

  • Select the cells you want to strikethrough.Go to the “New tab.”Click on “Strikethrough” from the “New Group.”

Method #5 – Using the dynamic conditional formatting option

  • Step 1: Choose the range where we want to apply the conditional formattingApply The Conditional FormattingConditional 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, click on the “Conditional Formatting” option, and then click on “New Rule.”

  • Step 2: Click on “Use a formula to determine which cells to format” and write the formula as (=B2=” Yes”), then click on “Format.”

Step 3: Go to “Font” then, check the “Strikethrough” option and click on “OK.”

Step 4: After the conditional formatting is done, Excel will automatically strike out the text.

Things to Remember

  • Excel strikethrough shortcut is only a way to display the text in the cell. It does not change the value of the cell. For example, “TEXT” is the same as “TEXT” for Excel and formulas.The same steps are to be followed to remove strikethrough to apply this.If we only want a certain part of cell value to strikethrough, we have to select that part instead of the complete cell.If we are using conditional formatting for strikethrough, we should keep in mind that the reference of the range must not be an absolute range or a relative range reference.While adding the shortcut of the strike, we should keep in mind that we cannot edit the tabs that Excel creates. We cannot add this option to the “Font” tab, as this is a default tab that we cannot edit in any way.

This article has been a guide to Strikethrough Shortcuts in Excel. Here, we discuss how to strikethrough in Excel using a keyboard shortcut, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –

  • Strikethrough Text in ExcelStrikethrough Text In ExcelIn Excel, strikethrough text refers to a line that runs between the text in a cell. To do so, right-click on any cell and select the strikethrough option or checkbox, which will draw a line through the text. CTRL+5 is the keyboard shortcut for this.read moreFormula with Text in ExcelFormula With Text In ExcelText in Excel Formula allows us to add text values to using the CONCATENATE function or the ampersand (&) symbol.read more“Save As” Excel ShortcutInsert Row Excel ShortcutInsert Row Excel ShortcutThe insertion of an excel row is simply the addition of a new (blank) row to the worksheet. The insertion of a row is eased with the help of shortcuts.read more