ngonoob.blogg.se

How to strikethrough excel
How to strikethrough excel














There are two methods to remove strikethrough:

How to strikethrough excel how to#

Output: Cross out cells through Format Cells How to remove strikethrough

  • In Format Cells, click Font tab > tick Strikethroughįigure 7.
  • Right-click and select Format Cells or press Ctrl + 1 to launch the Format cells dialog box.
  • Select the cells we want to strikethrough.
  • Strikethrough can also be applied through the Format Cells options. Output: Strikethrough within a cell Strikethrough in Format Cells
  • Highlight the text that we want to strikethroughįigure 4.
  • Select the cell and double-click or press F2 for cell Edit Mode.
  • When we want to strikethrough only a part of the contents of a cell, we follow these steps: Output: Strikethrough in multiple cells Strikethrough within a cell Afterwards, we press the hotkey for strikethrough: įigure 3. In the case of non-adjacent cells, we press the Ctrl key then click the cells that we want strikethrough. We simply highlight several adjacent cells.

    how to strikethrough excel

    The strikethrough keyboard shortcut can also be applied to multiple cells. Output: Strikethrough in one cell Strikethrough in multiple cells Select any cell that we want to strikethroughįigure 2.The strikethrough keyboard shortcut in Excel is. Strikethrough keyboard shortcut : Ctrl + 5 Strikethrough in one cell Although Strikethrough in Excel is not readily available on the ribbon, it can be applied through a keyboard shortcut or in Format Cells.įigure 1. Excel is great in creating and maintaining lists, and it also allows us to easily cross out items in the list through the Strikethrough tool.














    How to strikethrough excel