Windows Strikethrough Shortcutsolofasr

Posted : admin | On 21-04-2021

Strikethrough Text Shortcut Pc
Outlook Strikethrough Shortcut
Windows Shortcut Strikethrough Outlook
Windows Shortcut For Strikethrough Text

Watch Video – How to Apply Strikethrough format in Excl

What comes to your mind when you see text with a strikethrough in Excel (something as shown below)?

In most cases, it means that the task or activity has been completed and has been checked off.

Those who work with Microsoft Word use this extensively, and there is strikethrough icon right there in the ribbon.

However, there is no icon in Excel ribbon to do this.

I accidentally hit some key in the shortcuts when I was trying to just type a #1. Now everything has a strike through the middle and I can't figure out how to get rid of it!!! I don't know what I hit. I've tried going to the pref's but can't get rid of the strike through in all my text. Strikethrough: Alt + K; Double strikethrough: Alt + L; Superscript: Alt + P; Subscript: Alt + B; Small caps: Alt + M; All caps: Alt + A; Hidden: Alt + H; To remove a strikethrough in Word, simply select the text and either use the shortcut again to remove it or hit Ctrl + Spacebar to remove all formatting. Ctrl + Spacebar reverts your text formatting back to the default formatting of your document.

In this tutorial, I will share various ways to access the strikethrough option and apply it to text in Excel.

Keyboard Shortcut to Apply Strikethrough in Excel

Here is the keyboard shortcut that will automatically apply the strikethrough formatting in Excel.

Just select the cell where you want to apply the strikethrough format and press Control + 5.

If you want to apply this to a range of cells, select the entire range of cells, and use this keyboard shortcut. You can also select non-adjacent ranges and then apply the strikethrough format.

Add Icon in QAT to Access Strikethrough in Excel

While the icon is not available in the ribbon or Quick Access Toolbar (QAT) by default, you can add it easily. Here are the steps to add strikethrough icon in the QAT:

Right-click on any existing QAT icon or the ribbon tabs and select ‘Customize Quick Access Toolbar…’.

In the Excel Options dialogue box, select All Commands from the drop-down.

Strikethrough Text Shortcut Pc

Scroll down and select Strikethrough from the list. Click on Add.

Click OK. This will add the strikethrough icon in the quick access toolbar.

Access Strikethrough Format from Format Cells Dialogue

There is another way you can access strikethrough in Excel – Using Format Cells dialogue box.

While the earlier mentioned techniques (keyboard shortcut and icon) are faster ways to access strikethrough formatting, using format cells dialogue box gives you access to a lot of other formatting options as well.

Here are the steps to access Strikethrough in Excel using the Format Cells dialogue box:

Select the cells where you want to apply the strikethrough format.
Press Control + 1 (or right click and select Format Cells).
In the format cells dialogue box, select the font tab and check the Strikethrough option.
Click OK. This would apply the strikethrough format to the selected cells.

Outlook Strikethrough Shortcut

While this option is longer as compared to a keyboard shortcut or using the icon, it also gives access to many other formatting options at a single place. For example, you can also change color, font type, font size, border, number format, etc., using this dialogue box.

Examples of Using Strikethrough in Excel

Strikethrough in Excel can be used to show completed tasks.

Here are three practical examples where you can use the strikethrough format in excel.

EXAMPLE 1: Using Conditional Formatting

We can use conditional formatting to strikethrough a cell as soon as it is marked as completed. Something as shown below: Perfect photo suite v. 6.

Atheros wireless drivers windows 7 64 bit selfie quiet mode. Download Example File

EXAMPLE 2: Using Checkboxes (to show completed tasks)

You can also use check-boxes to cross off items. Something as shown below:

Download Example File

EXAMPLE 3: Using Double Click (VBA)

Windows Shortcut Strikethrough Outlook

If you are cool with using Excel VBA macros, you can also use the double-click event to cross off items simply by double-clicking on it. Something as shown below:

This method disables getting into the edit mode on double click and simply applies the strikethrough format as soon as you double click in the cell (VBA code available in the download file). Jason vs freddy movie.

While the idea behind applying the strikethrough format in excel remains the same, you can get as creative as you want.

Here is a creative example where I used the strikethrough format in a Task Prioritization Matrix template.

Windows Shortcut For Strikethrough Text