This will add a custom group at the end of the ribbon in the Home tab. Since its strikethrough is a formatting option, we are going to add the new button on the ‘Home’ tab, so choose ‘Home’ in this case. So to create a new button, select the target tab and click the ‘New Group’ button. New buttons cannot be added to the pre-existing group, they can be only added to the custom groups. Here, to create a new button, you need to first create a new custom group. It will open up the Excel Options window. Here’s how you do this:įirst, right-click anywhere on the ribbon and select the ‘Customize the Ribbon…’ option from the pop-up menu. As with QAT, you only need to set it up once, then you can easily access the strikethrough command whenever you need it from the ribbon. Since the strikethrough option is not available on the Excel ribbon by default, you can add a Strikethrough option/button on the ribbon with a few clicks. Select the data which you want to strikethrough and click the newly added ‘Strikethrough’ button and the text will be immediately strike out. Now you’ll notice the strikethrough button added to the upper left corner of your Excel window as shown in the below Screenshot. You can also use the up and down arrow buttons on the right side of QAT commands to change the position of the ‘Strikethrough’ button on the QAT toolbar. Click ‘OK’ to save the changes and close the dialog box. Doing this will add ‘Strikethrough’ to the list of commands on the right panel and that means the button is added to the Quick Access Toolbar. Next, select ‘Strikethrough’ in the list of commands and click on the ‘Add’ button. From the ‘Choose commands from’ drop-down list, select ‘Commands Not in the Ribbon’ or ‘All Commands’. The Excel Options dialog box will appear. To add the strikethrough button to the QAT, click the small downward arrow in the upper left corner of the Excel window, and then click ‘More Commands…’ from the drop-down.Īlternatively, right-click anywhere on the ribbon and choose the ‘Customize Quick Access Toolbar’ option from the drop-down. Follow these steps to add a strikethrough button in the QAT. However, we can add a strikethrough button to the Quick Access Toolbar and access it with a single mouse click whenever you deemed it necessary. Strikethrough button or option is not available in Excel by default. Add a Strikethrough Button to Quick Access Toolbar You can also format font, number, borders, alignment, etc., using this dialog box. This method also gives access to many other formatting options in a single place. Now you can see the result as shown in the below: Then, click ‘OK’ to save the change and close the dialog box. Once the Format Cells dialog box is opened up, on the ‘Font’ tab, check the ‘Strikethrough’ option under the Effects section. Or you can also click on the small arrow on the bottom-right corner of the Font section in the ‘Home’ tab to open the Format Cells dialog box. Select the cells that you want to strikethrough and then right-click, and choose the ‘Format Cells’ option (or press Ctrl + 1 to open Format cells dialog). Strikethrough Text Using Format Cell OptionsĪnother easy method that you can use to strike out data in Excel is by using the Format Cells feature. To strikethrough, more than one cell, select the range or select the non-continues cells while holding the Ctrl key, and then press the strikethrough keyboard shortcut. If you want to strike out only a specific part of the cell value, double-click the cell to enter the Edit mode, then select the part of the text that you want to strikethrough, and press the same shortcut key ( Ctrl+5). Note: Do this using the number along the top of your keyboard. Once the cells are selected, then press the keyboard shortcut key: Ctrl+5 and the data inside the cell will be crossed out. To apply the strikethrough format, first select the cell or cells that you need to strikethrough. Now suppose we have the below to-do list for which we need the strikethrough format. Here’s the keyboard shortcut to apply the strikethrough in Excel: Ctrl + 5 If you want to quickly strikethrough text in Excel, then a shortcut key is best the option for you. Strikethrough in Excel Using Shortcut Key Strikethrough formatting is represented by words with a horizontal line through their center, which could show tasks have been completed or that the text is wrong and irrelevant.Īlthough Excel doesn’t provide us any direct Strikethrough option on the ribbon, you can still access the strikethrough effect by using any of the five methods described in this tutorial. Strikethrough (a.k.a strikeout) is a horizontal line drawn through the center of the text, often used to indicate a revision or edit or the deletion of an error.