If the strikethrough format is one you’ll be using frequently, you may want to access it a bit more quickly. Method 3: Add to Quick Access Toolbar (QAT) When you click OK, the selected cell(s) will have the displayed text formatted with the strikethrough effect.You will see a preview of the strikethrough format in the Preview section of the window. This will open the Format Cells dialog box, from which you can select the Strikethrough checkbox.Go to the Home tab on the ribbon and click on the Font Settings button within the Font command group.Select the cell(s) which should have the strikethrough format.You can strikethrough an entire worksheet by selecting the worksheet tab and then pressing the shortcut key combination of Ctrl + 5.If that’s one too many shortcuts, and you’re not willing to memorize it, follow these steps instead: You can also strikethrough a row by selecting the row header and pressing the shortcut key combination of Ctrl + 5. You can strikethrough a column by selecting the column header and then pressing the shortcut key combination of Ctrl + 5. Once the range is selected, simply press the shortcut key combination of Ctrl + 5.ġ5. If you want to strikethrough a range of cells, you can do so by selecting the first cell in the range, holding down the Shift key, and then selecting the last cell in the range. You can also strikethrough multiple cells at once by selecting them all and then pressing the shortcut key combination of Ctrl + 5.ġ4. If you want to strikethrough a cell, you can do so by selecting the cell and pressing the shortcut key combination of Ctrl + 5. Once the text is selected, press the Enter key.ġ3. You can strikethrough text in an entire worksheet by selecting the worksheet tab, pressing the shortcut key combination of Ctrl + 5, and then using the arrow keys to select the text in each cell that you want to strikethrough. Once the text is selected, press the Enter key.ġ2. To strikethrough text in a row, simply select the row header, press the shortcut key combination of Ctrl + 5, and then use the arrow keys to select the text in each cell that you want to strikethrough. Once the text is selected, press the Enter key.ġ1. You can strikethrough text in a column by selecting the column header, pressing the shortcut key combination of Ctrl + 5, and then using the arrow keys to select the text in each cell that you want to strikethrough. Then, use the arrow keys to select the text in each cell that you want to strikethrough and press the Enter key.ġ0. Once the range is selected, press the shortcut key combination of Ctrl + 5. If you want to strikethrough text in a range of cells, you can do so by selecting the first cell in the range, holding down the Shift key, and then selecting the last cell in the range.
You can also strikethrough text in a cell by double-clicking on the cell, selecting the text that you want to strikethrough, and then pressing the shortcut key combination of Ctrl + 5.ĩ. Then, use the arrow keys to select the text that you want to strikethrough and press the Enter key.Ĩ. If you want to strikethrough text in a cell, simply select the cell and press the shortcut key combination of Ctrl + 5. You can strikethrough an entire worksheet by selecting the worksheet tab and then pressing the shortcut key combination of Ctrl + 5.ħ. To strikethrough a row, simply select the row header and press the shortcut key combination of Ctrl + 5.Ħ. You can strikethrough a column by selecting the column header and then pressing the shortcut key combination of Ctrl + 5.ĥ. Once the range is selected, simply press the shortcut key combination of Ctrl + 5.Ĥ. You can also strikethrough multiple cells at once by selecting them all and then pressing the shortcut key combination of Ctrl + 5.ģ. To quickly strikethrough a single cell, simply select the cell and press the shortcut key combination of Ctrl + 5.Ģ. In this article, we'll show you 15 different ways that you can use the strikethrough shortcut key in Excel.ġ. One of those shortcut keys is the strikethrough key, which allows you to quickly add a line through your text. If you work with Excel on a regular basis, then you know that there are certain shortcut keys that can make your life a whole lot easier.