Step-by-Step Guide: Implementing Strikethrough Text Feature in Microsoft Excel

Step-by-Step Guide: Implementing Strikethrough Text Feature in Microsoft Excel

Richard Lv13

Step-by-Step Guide: Implementing Strikethrough Text Feature in Microsoft Excel

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.

Nero Burning ROM:
The ultimate burning program for all your needs!

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

Select the arrow icon in the "Font" section of the "Home" tab.

TubeDigger - online video downloader from mostly any site

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.

OtsAV DJ Pro

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

  • Title: Step-by-Step Guide: Implementing Strikethrough Text Feature in Microsoft Excel
  • Author: Richard
  • Created at : 2024-08-28 01:07:04
  • Updated at : 2024-08-29 01:07:04
  • Link: https://win11-tips.techidaily.com/step-by-step-guide-implementing-strikethrough-text-feature-in-microsoft-excel/
  • License: This work is licensed under CC BY-NC-SA 4.0.