fbpx

Strikethrough in Excel & Word | Strikethrough Shortcut

Strikethrough in Excel & Word helps to delete it (Strikethrough Shortcut in Excel). An example sometimes, while creating a document we don’t need a few texts we can just delete it. But when we want to show the unwanted text we used Strikethrough text option. This option will let the text remain where it is. But simply it will put a horizontal stroke on the text. This will describe that the text is no longer need or relevant.



Strikethrough in Excel

There are various shortcuts assign to each function in MS Office. Strikethrough too is assigned some shortcuts. This makes our work easy and saves time. There are lots more shortcuts in Excel. Click here

Excel Power Users Ebook

Be Smart at Excel | New Skills for New JOB

This eBook will help you to get Excel Skills & Boost your career

How to do Strikethrough In Excel

There is no icon for this function or option in any of the ribbon in Excel. You need to go through few steps to assign Strikethrough in Excel:

  1. Select the cell or range of cells you want to Strikethrough in Excel.
  2. In the Home Ribbon > Font Group > Click on the small arrow sign at the right bottom corner of the Font Group

ARE YOU STRUGGLING WITH EXCEL FORMULAS?
Become a "Hero at Office"• 200+ Video Lessons • Real-life Case studies • Lifetime Access

OR

Right-click and click on Format cell.

  1. Go to the Font tab in the Format Cell dialog box.
  2. In the effects, put a tick on Strike through.

Result: You will see a horizontal strike on the text in the cell. i.e ( E̶x̶a̶m̶p̶l̶e̶ )

However, this procedure would be too time consuming. So the shortcut to Strike through the text is Excel is PRESS CTRL +5.

You can learn such tips & tricks in our Free Excel Course Lessons

Procedure: Select the cell or range of cell and Press the Strikethrough Shortcut CTRL + 5

Strikethrough in Excel

How to do Strikethrough in Word

Now, Steps to assign Strikethrough in Word:

  1. Select the text or texts and click on the Strikethrough button which is available in Home Tab, Font group
  2. Ctrl + D (Opens the Format cell dialog box)
  3. Alt + K (Tick on Strikethrough)
  4. ENTER.

You can even customize or put a strikethrough button on your ribbon. You can put this button on Quick Access Toolbar. Also, whenever you want to put a strike on non-adjacent cells in Excel. You press the Ctrl key and select the cell and then press the Shortcut Ctrl + 5.



Strikethrough in Word

Strikethrough Shortcut Key for Excel or Word

Excel has a keyboard shortcut for strikethrough as follows:

  • Select the cells in Excel for which you want to Strikethrough
  • Press Ctrl + 5 as Strikethrough Shortcut Key in Excel
  • Strikethrough in excel will be applied it’s simple.
The Ultimate EXCEL GUIDE LIBRARY
• Get Excel VBA Automation Course and Outlook Course as FREE • Lifetime Access • eBook

 

Similarly, for Microsoft Word a keyboard shortcut for Strikethrough as follows:

  • Select the word for which you want to Strikethrough
  • Press Ctrl + 5 as Strikethrough Shortcut Key in Word
  • Strikethrough in a word will be applied it’s simple.

Still, if you want an automatic task to create strikethrough. Click Here and Copy-Paste it. You are done with strikethrough shortcut. If you want to learn more about Excel Tips & Tricks then kindly join Excel Ninja Training Program. This training program offers high-quality video lectures and 24×7 support.