KEYBOARD SHORTCUT LINE THROUGH TEXT HOW TO

Here, we discuss how to strikethrough in Excel using a keyboard shortcut, practical examples, and a downloadable Excel template. This article has been a guide to Strikethrough Shortcuts in Excel. We cannot add this option to the “Font” tab, as this is a default tab that we cannot edit in any way. While adding the shortcut of the strike, we should keep in mind that we cannot edit the tabs that Excel creates.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.If we only want a certain part of cell value to strikethrough, we have to select that part instead of the complete cell.The same steps are to be followed to remove strikethrough to apply this.For example, “TEXT” is the same as “TEXT” for Excel and formulas. It does not change the value of the cell. Excel strikethrough shortcut is only a way to display the text in the cell.Step 3: After the option is added in a “New Tab,” this will appear below in the ribbon.Step 2 : From the “Excel Options” tab, choose to add “New Tab,” choose the “Strikethrough” option and click on “OK.”.Step 1: Right-click on the “Font” tab and choose the option of “Customize the Ribbon.”.This option was first introduced in the Microsoft Excel 2007.

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

It will strikethrough the selected cells.

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

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

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

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

It enables users to save important shortcuts and easily access them when needed.

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

Ribbons are organized into logical groups called Tabs, each of which has its own set of functions. This option is not available in the ribbon and in the Quick Access toolbar Ribbon And In The Quick Access Toolbar Ribbons in Excel 2016 are designed to help you easily locate the command you want to use. Method #3 – Strikethrough Using this option from Quick Access Toolbar Let us discuss each method in detail with an example.

Using it from 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.

Top 5 Methods to use Strikethrough in Excelīelow are the different methods of using the strikethrough shortcut in Excel.

Method #5 – Using the dynamic conditional formatting option.

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

Method #2 – Strikethrough Using the Format Cells Option.

Method #1 – Strikethrough Using the Excel Shortcut Key.

Top 5 Methods to use Strikethrough in Excel.

Keyboard shortcut line through text