Select any text in a rich text editor and CTRL+Click (right-click) on it. The simplest solution is built into Mountain Lion. You will probably encounter a few exceptions where this will not work. This is sort of a painful workaround, but it should suffice in the majority of applications. 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.
Nevertheless, TextExpander does support rich text formatting. This is not a feature that all rich text editors provide, thus the inconsistencies you experienced. I hope you found this Excel tutorial helpful.Shortcuts created in System Preferences will only work globally with applications that have matching Strikethrough options in their menu. The fastest way would be to use the keyboard shortcut or add the strikethrough icon in the Quick Access Toolbar and then click on it to apply that.Īnd if you work with task lists and project status reports, you can also use the strikethrough format to visually show tasks that have been completed by using Conditional Formatting. In this tutorial, I showed you a few different ways to insert the strikethrough format in Excel. It’s not an elegant solution, and should only be used if you absolutely need this.īelow are the steps to insert a line and then give it a different color:Īs I mentioned, this is not an elegant solution, and if you need to do this for multiple cells, you would have to insert the line multiple times. You can use the Shapes option to insert a line over the text manually and then give any color you want to that line.
However, if you still need to have a separate color for the strikethrough line, there is a workaround.
When you apply a format on a cell (such as font size or font color), it is applied to the entire cell. Unfortunately, this is not something that can be done in Excel.
#Hotkey for strikethrough how to
How to Change Strikethrough Color in Excel?Ī common question for many people who want to apply the strikethrough format in Excel is whether you can have a different color for the strikethrough line and a different color for the text behind it.įor example, many people want the text to be in black color, but the strikethrough line in red color. The above steps would only apply the strike-off only the cell content that was selected. Use the keyboard shortcut Control + 5 (or use a strikethrough icon in the Quick Access Toolbar or Format Cells dialog box).Select the text on which you want to apply the strikethrough format.Double-click on the cell in which you want to apply the strikethrough format (or select the cell and hit the F2 key to get into the edit mode).Click on the ‘Customize the Quick Access Toolbar’ icon.You can add the strikethrough format icon in the Quick Access Toolbar (QAT) so that it’s always visible and you can use it with a single click whenever you want.īelow are the steps to add the strikethrough format icon in the Quick Access Toolbar: If you’re not a fan of using keyboard shortcuts in Excel, or you already have a lot of keyboard shortcuts that you need to memorize and don’t want another one, let me show you another quick way to apply the strikethrough format in Excel. If you select a range of cells and then use this keyboard shortcut, the strikethrough format would be applied to all the cells.īonus Tip: This strikethrough keyboard shortcut also works in Google Sheets Add Strikethrough Icon to Quick Access Toolbar The keyboard shortcut would work as a toggle, so if you use it once it would apply the strikethrough format on a cell, and if you use it again it would remove it. To use this, hold the Command and the Shift key and then press the X key.
#Hotkey for strikethrough mac
To use the shortcut, hold the Control key and then press the 5 key.Īnd if you’re using a Mac OS, here is the keyboard shortcut for strikethrough: Cmd+Shift+X Let’s start with the easiest way to apply strikethrough format on a cell in Excel – a keyboard shortcut.īelow is the keyboard shortcut for strikethrough in Excel (Windows): Control + 5
0 kommentar(er)
