The strikethrough option in Excel is a font formatting feature that puts a horizontal line through the text or numbers in a cell. Here's where and how you can find and use it:
- Keyboard Shortcut: The quickest way to apply or remove strikethrough is by selecting the cell(s) and pressing Ctrl + 5 on Windows or Command + 5 on Mac. This works for text, numbers, and ranges of cells
- Format Cells Dialog:
- Select the cell(s) you want to format.
- Press Ctrl + 1 (Windows) or Command + 1 (Mac) to open the Format Cells dialog.
- Go to the Font tab.
- Check the Strikethrough box under Effects.
- Click OK to apply
- Ribbon / Quick Access Toolbar:
- In Excel Online, the strikethrough button is located on the Home tab in the Font group next to other formatting buttons
* In desktop Excel, the strikethrough button is not shown by default on the ribbon, but you can add it to the Quick Access Toolbar for easy access
This formatting does not affect the actual values in the cells; it is purely a visual effect to indicate completed tasks or mark data as obsolete without deleting it
. In summary, the easiest method is to use Ctrl + 5 to toggle strikethrough on and off, or use the Format Cells dialog under the Font tab to find the strikethrough option.
