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.
0 kommentar(er)
