How to Strikethrough in Microsoft Excel


    Microsoft Excel Logo

    Drawing a line crossing your text is easy with Microsoft Excel’s strikethrough option. You can use a keyboard shortcut or a graphical menu to strikethrough your text. We’ll show you both methods.

    RELATED: How to Apply Strikethrough to Text in Google Docs

    How to Strikethrough Text in Excel With a Keyboard Shortcut

    The quickest way to apply strikethrough to text in Excel is to use a dedicated keyboard shortcut.

    RELATED: All the Best Microsoft Excel Keyboard Shortcuts

    To use this method, first, open your spreadsheet with Microsoft Excel. In your spreadsheet, click the cell in which you want to apply strikethrough.

    Select a cell in Excel.

    While your cell is selected, press Ctrl+5 (Windows) or Command+Shift+X (Mac) to apply the strikethrough effect.

    Apply strikethrough with a keyboard shortcut in Excel.

    Your text now has a line crossing it. To remove strikethrough, select your cell and press Ctrl+5 (Windows) or Command+Shift+X (Mac).

    That’s a pretty good way to draw people’s attention to certain cells. You can also rotate text in your cells to make them stand out from other cells.

    RELATED: How to Rotate Text in Cells in Excel

    How to Apply Strikethrough From the Formatting Menu

    There’s also a graphical menu option to apply strikethrough in your cells.

    To use it, first, launch your spreadsheet with Microsoft Excel. In your spreadsheet, click the cell in which you want to draw a line crossing the text.

    Select a cell.

    At the top, in Excel’s ribbon, click the “Home” tab.

    Click the "Home" tab in Excel.

    On the “Home” tab, from the “Font” section, select the arrow icon.

    A “Format Cells” window will open. Here, in the “Effects” section, enable the “Strikethrough” option. Then, at the bottom, click “OK.”

    Enable "Strikethrough" and click "OK" on the "Format Cells" window.

    Your selected cell now has the strikethrough effect applied to it.

    Strikethrough text in Excel.

    And that’s how you check things off in your Microsoft Excel spreadsheets. Very handy!


    You can strikethrough text in Microsoft Word, too.

    RELATED: How to Draw a Line Through Words in Microsoft Word





    Source link

    Previous articleAfter record-breaking season, Harbes family makes massive apple donation
    Next articleGift card scams could be the biggest Grinch this holiday season