Excel as I always say is a great blessing for those who understand how important it is in almost every field of life. You can play with numbers using Excel but it does not clearly show how you can format text values the way you need.
Did you ever try using Strikethrough?
With this feature, you can cross any text, number, or data given in the sheet. Doing this is purely simple with Microsoft Word. By clicking on the strikethrough button from the ribbon, you can do this. Users tend to find the same button in the ribbon on Excel but never find it. So, the question is how you can apply this feature in Excel.
Let’s find out how you can do this:
What is Strikethrough?
A character format is used for text or values in a given cell where a line appears through the cell or text you have selected. Since it is a format, you can simply remove it by double-clicking in a cell.
How to Apply Excel Strikethrough Shortcut Keys
Let’s first learn about using built-in keyboard shortcuts to apply strikethrough.
Choose a cell in which you need to apply strikethrough.
Press CTRL + 5.
By double-clicking, on a cell, you can highlight text or partial text in a cell. Using the same shortcut will let you remove the strikethrough.
Excel Strikethrough Shortcuts
Apart from the above shortcut, we have come up with a few more keyboard shortcuts you can follow:
CTRL + SHIFT + 5
Using this shortcut will let you strikethrough any selected text. It also lets you delete a current strikethrough formatting. In case, if you remove the strikethrough quickly you can use this shortcut.
CTRL + ALT + 5
By using this shortcut command, you can strikethrough any selected text while applying new color to the text. With this shortcut command, you can simply add visuals to the document.
Select the text you need to apply strikethrough on and then press CTRL + SHIFT + 5 from the keyboard. From the drop-down menu, you will be able to choose a new color for the text.
CTRL + 6
By using this shortcut, you can apply strikethrough to any selected text while applying a new style to the text. It will enhance the beauty of your text which makes the document appealing.
Select the text you need to apply this strikethrough setting and press CTRL + 6 from the keyboard. From the drop-down menu, you will be able to choose new font styles for the text.
CTRL + 7
While applying strikethrough to any selected cell, you can apply a new font size to the text by using this shortcut key command. You can make your text eye-catching once this setting is applied.
Select the text you need to add strikethrough on and press CTRL + 7 from the keyboard. From the drop-down menu, you can choose a new font size for the text.
How to Apply Strikethrough with Format Cells Option?
Follow the steps given below:
- Choose the cells you need for this format and right-click on the cell.
- Click on the Format Cells option.
- Open the Font tab and choose the Strikethrough option. Press OK.
- Once you press OK, you will notice the cell gets the strikethrough format.
Summary
Here you have learned how to apply Excel Strikethrough shortcuts. In this post, more than one shortcut is explained with its benefits. Each method has its different function that lets you make a document outstanding.
