The Format Cells dialog box appears with the Font tab selected. You can also double-click in a cell and drag over partial text. Select the cell you want to strikethrough.To apply strikethrough to a cell or the contents of a cell using the Format Cells dialog box and keyboard shortcuts: Applying strikethrough using the Format Cells dialog box Press Ctrl + 5 if you want to remove strikethrough as well.
If you double-click in a cell and then highlight text or partial text in a cell, you can still use this shortcut. To apply strikethrough to a cell using a built-in keyboard shortcut: Applying strikethrough using a built-in keyboard shortcut If you double-click in a cell, you can drag over the text or values and apply strikethrough. Because it's a format, it can be removed easily. Strikethrough is a character format that can be applied to text or values in a cell where a line appears through the cell or selected text.
#How to strikethrough excel how to#
Recommended article: How to Delete Blank Rows in Excel (5 Easy Ways)ĭo you want to learn more about Excel? Check out our virtual classroom or live classroom Excel courses > What is strikethrough? There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Format Cells dialog box, or by adding a command to the Quick Access Toolbar.
You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. Apply or Remove Strikethrough Using Shortcuts in Excelīy Avantix Learning Team | Updated July 20, 2021Īpplies to: Microsoft ® Excel ® 2013, 2016, 2019 and 365 (Windows)
0 kommentar(er)
