How to do a Strikethrough in Excel

Select the cells containing the data you want to format. Click the Format Cells box launcher. Tip: You can also press Ctrl+5. In the Format Cells box, under Effects, click Strikethrough .

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.


How to do a strikethrough in Excel on Mac?
Select the cell(s) or part of a cell value you wish to cross out.Right-click the selection and chose Format Cells from the popup menu.In the Format Cells dialog box, switch to the Font tab and select the Strikethrough checkbox:
How do you put a line through text?
Select the text you want to strike through.Press Ctrl+D. A font dialog box will appear.Press Alt+K. The strikethrough feature should now be selected.Press OK. The text will now have a line through it.
What is the shortcut for strikethrough in Excel on a Mac?
Select the cells you want to strikethrough. Use the shortcut Command + Shift + X to strikethrough the selected cells. If you want to strikethrough a single cell, double-click on it to enter the cell editing mode. Then use the shortcut Command + Shift + X.