Excel is a powerful tool for organizing data, but sometimes you need to make changes to your data that are not immediately obvious. One such change is applying a strikethrough to text in your Excel worksheet. Unlike other Microsoft Office programs, Excel does not have an easy-to-use strikethrough command that you can access directly from your ribbon. However, there are two keyboard shortcuts that you can use to apply and remove strikethrough formatting.
The first shortcut is a simple one: Control + 5. When you select text in your worksheet and press this combination of keys, Excel will apply a strikethrough formatting to your text. If you have already applied a strikethrough to an item in a list and you want to remove it, simply select the item and press Control + 5 again.
The second shortcut is a bit more involved, but it offers more formatting options. First, select the cells where you want to apply strikethrough. Then, press Control + 1. This will open the Format Cells dialog box. Depending on where the dialog box opens, you will need to use your shortcut keys to jump to different tabs. For example, pressing “F” on your keyboard will take you to the Font tab, where you will see the three different text effects available in Excel.
The key to this method is to notice the underline letters that appear on the different tabs of the dialog box. These letters are Alt shortcuts that you can use to quickly apply text effects. For example, if you want to apply strikethrough to your selected cells, hold down the Alt key and press “K.” This will apply the strikethrough effect to your text.
If you want to apply other text effects, such as superscript or subscript, you can use other Alt shortcuts, such as Alt + E for superscript. Once you have applied your formatting, you can close the dialog box and your changes will be saved. If you want to remove the strikethrough formatting, simply select the text and press Control + 5 again.
Using these keyboard shortcuts to apply and remove strikethrough formatting in Excel can save you time and effort. With a little practice, you’ll be able to format your data quickly and easily, without having to navigate through menus or use your mouse.