#Office word strikethrough shortcut full

They can even review these changes and accept or reject them. Why cross out words when you can just delete them? When you’re tracking changes in Word so you can collaborate with others, keeping that deleted text visible but crossed out lets them know what’s changed. Are you copy-editing a large pile of data or exploring different ways to strikethrough text? How about some conditional formatting? These methods will pretty much cover all the scenarios you can come across.It’s a good question. This was all about the different ways to strikethrough text in MS Excel. You will see that the cells with duplicate text have been formatted as strikethrough. Here you will see the Strikethrough option in the Effects section.

Set a condition and put formatting rules accordingly.įor example, if you want to strike through every cell with duplicate values, then you will have to select Format only unique values or duplicate values and select duplicate from the Format all drop down. In the Home tab, click on Conditional Formatting to open the submenu.įrom the options displayed, click on New Rule.Ī New Formatting Rule window will pop up. Step #3: Create a new ruleĬonditional formatting requires conditions set by users to format the selected cells. If you want to select text in multiple cells, just drag your cursor across and select all the cells. But it can come in handy if you have a large data set to work with and want to put many strikethroughs at one go. This will strikethrough the entire or part of the text in that cell.Ĭonditional formatting is not the most widely used method for strikethrough. You will find this icon right at the top of the window, above the menu tabs. Now that you have selected the cell or text to strikethrough, click on the Strikethrough icon ( ab) in the QAT. Step #5: Click on the Strikethrough option available in the QAT. This will add the Strikethrough command to the QAT. This will give the list of all the commands that QAT doesn’t have.įrom the list, select Strikethrough and then press the Add > button in the middle of the window. In the Choose commands from dropdown at the top, select Commands Not in the Ribbon. Go to the File option located in the top left corner of your Excel window.Ĭlick on Options and the Excel Options window will open up. Step #2: Access the settings for the Quick Access Toolbar If you already have an excel file you are working on and need to strikethrough text on it, you can open that. So we will start with the addition of the strikethrough option in the QAT since it’s not there by default. However, you need to enable this option to make it visible in the QAT. This option allows you to strikethrough text in MS Excel with the click of a button on the QAT. Method #3: Use the Quick Access Toolbar (QAT)

Once you’ve selected the Strikethrough option, either press Enter or click the OK button. Go to the Font section and click on the extend icon, which is a small arrow in the bottom right corner of that section, as shown below. Step #3: Open font settingsĬlick on the Home tab in the top menu bar to change the ribbon. The process is a bit lengthier compared to the earlier method. This method uses the normal ribbons to access the required commands. Knowing what is where in your ribbons will allow you to work with ease. If you have only selected a part of the text in the cell, then press Enter. This will strikethrough the text in the cell or the part of the text you have selected. Press the keyboard shortcut: Ctrl + 5 by pressing the Ctrl key on your keyboard and the number 5 at the same time. Select a cell with text in it or select a part of the text in the cell by dragging your cursor over it. Open an excel file to enter text and strikethrough it.

#Office word strikethrough shortcut full

Using this method, you can strikethrough full or partial text in a cell.

Using keyboard shortcuts is one of the simplest ways to do things in MS Excel. In this article, we will share 4 methods to cross out text in MS Excel.Ĥ Methods to strikethrough text in MS Excel: It is a basic copy-editing symbol used to indicate the deletion of an error or removal of certain text in a work. Strikethrough refers to a horizontal line running through text without affecting its readability.