Monday, May 23, 2022

Where is the font strikethrough option

If you'd like to draw a line through data in a cell to maybe show edits or completed tasks, the font strikethrough option isn't available in Excel for the web.

If you have the Excel desktop application, you can use it to open your workbook and apply the strikethrough formatting there. Here's how: 

  1. Click Open in Excel.

    Button to Edit in Excel

  2. Select the cells containing the data you want to format.

  3. Click the Format Cells box launcher.

    Font dialog box launcher button

    Tip:  You can also press Ctrl+5.

  4. In the Format Cells box, under Effects, click Strikethrough.

    apply strikethrough option to show font as crossed out.

  5. Save the workbook and reopen it in Excel for the web to see the changes. 

If you don't have the Excel desktop application, you can give it a try. Or you can buy it here, when you're ready to switch.  

For news about the latest Excel for the web updates, visit the Microsoft Excel blog.

No comments:

Post a Comment