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. One of those shortcut keys is the strikethrough key, which allows you to quickly add a line through your text. In this article, we’ll show you 15 different ways that you can use the strikethrough shortcut key in Excel.
1. To quickly strikethrough a single cell, simply select the cell and press the shortcut key combination of Ctrl + 5.
2. You can also strikethrough multiple cells at once by selecting them all and then pressing the shortcut key combination of Ctrl + 5.
3. 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. Once the range is selected, simply press the shortcut key combination of Ctrl + 5.
4. You can strikethrough a column by selecting the column header and then pressing the shortcut key combination of Ctrl + 5.
5. To strikethrough a row, simply select the row header and press the shortcut key combination of Ctrl + 5.
6. You can strikethrough an entire worksheet by selecting the worksheet tab and then pressing the shortcut key combination of Ctrl + 5.
7. If you want to strikethrough text in a cell, simply select the cell and press 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.
8. 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.
9. 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. Once the range is selected, press the shortcut key combination of Ctrl + 5. Then, use the arrow keys to select the text in each cell that you want to strikethrough and press the Enter key.
10. 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. Once the text is selected, press the Enter key.
11. 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.
12. 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.
13. If you want to strikethrough a cell, you can do so by selecting the cell and pressing 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.
14. 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. Once the range is selected, simply press the shortcut key combination of Ctrl + 5.
15. You can strikethrough a column by selecting the column header and then pressing the shortcut key combination of Ctrl + 5. You can also strikethrough a row by selecting the row header and pressing 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.
Excel is a powerful tool that can help you manage and analyze data with ease. However, it can be time-consuming to navigate through the various menus and options to find the features you need. That’s where keyboard shortcuts come in handy. In this article, we’ll focus on one specific shortcut: strikethrough. Strikethrough is a formatting option that allows you to cross out text in a cell. It’s a useful tool for indicating completed tasks or canceled items. Here are 15 Excel shortcut keys for strikethrough that will save you time and effort.
Shortcut Keys for Strikethrough
1. Ctrl + 5
The easiest way to apply strikethrough formatting to a cell is to use the Ctrl + 5 shortcut. Simply select the cell or cells you want to format and press Ctrl + 5. This will apply strikethrough formatting to the text in the cell.
2. Alt + H, H, S
If you prefer using the ribbon, you can access the strikethrough option by pressing Alt + H, H, S. This will open the Font dialog box, where you can select the Strikethrough option.
3. Alt + H, F, S
You can also access the Font dialog box by pressing Alt + H, F, S. This will open the Format Cells dialog box, where you can select the Strikethrough option under the Font tab.
4. Ctrl + Shift + 5
If you want to remove strikethrough formatting from a cell, you can use the Ctrl + Shift + 5 shortcut. Simply select the cell or cells you want to remove formatting from and press Ctrl + Shift + 5.
5. Ctrl + 1
The Ctrl + 1 shortcut opens the Format Cells dialog box. From there, you can select the Strikethrough option under the Font tab.
6. Alt + H, F, N, S
If you want to apply strikethrough formatting to a specific word or phrase within a cell, you can use the Alt + H, F, N, S shortcut. This will open the Find and Replace dialog box, where you can search for the text you want to format and apply strikethrough to it.
7. Alt + H, H, 5
You can also use the ribbon to apply strikethrough formatting. Press Alt + H, H, 5 to apply strikethrough to the selected text.
8. Alt + H, F, N, R
If you want to remove strikethrough formatting from a specific word or phrase within a cell, you can use the Alt + H, F, N, R shortcut. This will open the Find and Replace dialog box, where you can search for the text you want to remove formatting from and clear the Strikethrough option.
9. Alt + H, F, N, A
If you want to apply strikethrough formatting to all cells in a range that contain a specific value, you can use the Alt + H, F, N, A shortcut. This will open the Find and Replace dialog box, where you can search for the value you want to format and apply strikethrough to all cells that contain it.
10. Alt + H, F, N, O
If you want to remove strikethrough formatting from all cells in a range that contain a specific value, you can use the Alt + H, F, N, O shortcut. This will open the Find and Replace dialog box, where you can search for the value you want to remove formatting from and clear the Strikethrough option.
11. Alt + H, B, S
If you want to apply strikethrough formatting to all cells in a range, you can use the Alt + H, B, S shortcut. This will open the Borders dropdown menu, where you can select the Strikethrough option.
12. Alt + H, B, T
If you want to remove strikethrough formatting from all cells in a range, you can use the Alt + H, B, T shortcut. This will open the Borders dropdown menu, where you can clear the Strikethrough option.
13. Alt + H, B, D
If you want to apply a diagonal strikethrough to all cells in a range, you can use the Alt + H, B, D shortcut. This will open the Borders dropdown menu, where you can select the Diagonal Down or Diagonal Up option.
14. Alt + H, B, B
If you want to apply a double strikethrough to all cells in a range, you can use the Alt + H, B, B shortcut. This will open the Borders dropdown menu, where you can select the Double option.
15. Alt + H, B, H
If you want to apply a thick strikethrough to all cells in a range, you can use the Alt + H, B, H shortcut. This will open the Borders dropdown menu, where you can select the Thick option.
These are just a few of the many Excel shortcut keys for strikethrough formatting. By using these shortcuts, you can save time and work more efficiently in Excel. Try them out and see how they can improve your workflow!
