Here are the available shortcuts: 1. Put text in asterisks to bold it. Use tilde on both ends to strikethrough your message. (Windows) or Command + Backspace (Mac OS) shortcuts. Alt - H - W works to wrap the text but then whats the shortcut to format the cell to auto fit row height? Use A Keyboard Shortcut To Wrap Text In Excel. Angus Kidman. On the Mac, use. To open a list of keyboard shortcuts in Google Docs, press Ctrl + / (Windows, Chrome OS) or ⌘ + / (Mac). You can also use menu access keys. Open any application menu using the keyboard, then type the underlined letter for the item you'd like to select. Select the text (or the cell) you want to strikethrough, and then type Control+5. You can also use that shortcut to remove strikethrough. You can also use that shortcut to remove strikethrough.
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.
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-contiguous 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.
- 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.
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:
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)
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).
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.
Download Example File
You May Also Like the Following Excel Tutorials:
- Data Formatting in Excel.
- Strikethrough in Excel – MS Help.
Session expired
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.
Active1 year, 2 months ago
We have ⌘B to bold, ⌘I to italicise, ⌘U to underline, but we don't (as far as I can tell) have a shortcut to strikethrough selected text in any OS X rich editor.
I added a keyboard shortcut into System Preferences, but that way doesn't work very consistently. I also tried using TextExpander, but it doesn't support rich text formatting.
Has anyone come up with a way to do this?
CyberSkull
1,5126 gold badges27 silver badges49 bronze badges
mmlammla
8 Answers
Hey I just came across this question because today I just started to use Stickies as a To-Do list for things I need to finish over the day and I also wanted to have that feature that you strikethrough items or text you are done with…
I think an easy workaround for this is that you have lets say 3 items, then you go to mark your first item with the strikethrough from the Fonts panel and then select that all the item and go to Font > Copy Style (Opt+Cmd+C) and then because it is copied in the Stickies app, after, anytime you use the shortcut Opt+Cmd+V (Paste Style) over a selected item it will paste the strikethrough style anytime later on the app, even if you have any other copied item in your clipboard.
Strikeout Text Code
M K
10.1k1 gold badge26 silver badges50 bronze badges
CarlosCarlos
Shortcuts created in System Preferences will only work globally with applications that have matching Strikethrough options in their menu. This is not a feature that all rich text editors provide, thus the inconsistencies you experienced.
Nevertheless, TextExpander does support rich text formatting. When creating a new snippet click the 'Content' header above the snippet and select 'Formatted Text, Pictures.' You could use this to store a small sample of strikethrough text to use the formatting of. This is sort of a painful workaround, but it should suffice in the majority of applications. You will probably encounter a few exceptions where this will not work.
The simplest solution is built into Mountain Lion. Select any text in a rich text editor and
CTRL+Click
(right-click) on it. Select the Font>StylesA new menu pops up. Select 'Favorite Styles' and then select 'Struck through' from the drop down menu. Now click Apply.
Your text will now be struck through. Keep in mind this Font menu may not appear in all rich text editors and others may not display struck through text at all.
harpermdharpermd
an even quicker way is to use the upper left corner with with the little drop down menu with the paragraph symbol.
user57574
M K
10.1k1 gold badge26 silver badges50 bronze badges
Jeremy R. CoxJeremy R. Cox
This one's what I do as a workaround.
- Write a 'struck-through text' on Word.
- Copy and paste that 'struck-through text' to the sticky note.
- Format the newly pasted 'struck-through text' the way you want on yoursticky note.
- Select the 'struck-through text' and click Opt+Cmd+C (or click Font >copy style)
- Highlight the item you want to strike through.
- Click Opt+Cmd+V (or click Font > paste style)
Tedious at first but works fine after.:)
Jayme del RosarioJayme del Rosario
You can cross through individual characters in Safari and other Mac docs by:
![Whats The Hotkey For Strikeout Text On Mac Whats The Hotkey For Strikeout Text On Mac](/uploads/1/2/6/4/126452877/928469319.jpg)
1 In Safari (or other) Toolbar, Click 'Edit' > 'Special Characters'
2 In pop-up's 'Search' box type: 'combining long stroke overlay' and click on the '-' that comes up under the 'Unicode' heading at the bottom of the central column in the box
3 Click 'Add to Favourites' box
4 The Special Characters pop-up can be left open and dragged to a convenient area of the screen whilst completing Safari docs etc (I use it for writing foreign language rules in Quizlet). Type the character you wish to show crossed out, then double click the '-' character in the Favourites section of the pop-up to strike through
TorixBearTorixBear
I just had the same problem and figured out you could if you went to the side bar (the format tab in Pages) and then clicked on character styles then held down strikethrough and liked shortcut you could set F1–F9 as shortcuts for the strikethrough effect!
Css For Strikeout Text
grg♦
145k25 gold badges229 silver badges340 bronze badges
kierakiera
Html Code For Strikeout Text
Jawa
2,2675 gold badges17 silver badges25 bronze badges
user68262user68262