How to Do Strikethrough in Microsoft Excel
Microsoft Excel empowers users with efficient data organization and visualization tools. Strikethrough is a typographical presentation of words with a horizontal line through their center, implying that an item has been completed or considered ‘done.’ In Excel, this feature is commonly used to track tasks or items in a list. We’ll walk you through applying a strikethrough in Excel, covering various methods and scenarios.
![how to do strikethrough in microsoft excel](https://images.template.net/wp-content/uploads/2023/12/How-to-Do-Strikethrough-in-Microsoft-Excel.jpg)
Strikethrough in Microsoft Excel
-
Using the Font Dialog Box
The first method of applying a strikethrough in Excel is using the Font dialog box. Select the cell or range of cells you want to apply the strikethrough. Then, navigate to the ‘Home’ tab in the Excel ribbon. In the ‘Font’ group, click on the dialog box launcher (the small arrow in the bottom right corner). This will open the Font dialog box. Under the ‘Effects’ section, you’ll see an option for ‘Strikethrough.’ Check this box, then click ‘OK’ to apply the strikethrough.
-
Using the Excel Ribbon
Another way to apply a strikethrough in Excel is by using the Excel ribbon. This method is even quicker than the first, eliminating the need to open the Font dialog box.
Start by selecting the cell or range of cells you want to apply the strikethrough. Then, navigate to the ‘Home’ tab in the Excel ribbon. You’ll see an icon for ‘Strikethrough’ in the’ Font’ group. Click this icon to apply the strikethrough to your selected cells.
You may also find valuable insights in the following articles offering tips for Microsoft Excel:
FAQs
How can I apply strikethrough to text in Microsoft Excel?
Select the cell or cells with the text, right-click, choose ‘Format Cells,’ go to the Font tab, and check the ‘Strikethrough’ option.
Is there a keyboard shortcut for applying strikethrough in Excel?
Yes, you can use the keyboard shortcut “Ctrl + 5” to quickly apply strikethrough to the selected text in Excel.
Can I apply strikethrough to a part of the text within a cell?
Yes, you can. Double-click the cell, select the text you want to strikethrough, and then follow the same steps to apply the strikethrough formatting.
How do I remove strikethrough from the text in Excel?
To remove strikethrough, select the cell or cells, right-click, choose ‘Format Cells,’ go to the Font tab, and uncheck the ‘Strikethrough’ option.
Can I customize the color of the strikethrough line in Excel?
No, Excel’s default strikethrough feature uses the font color of the text. To change the color, you need to change the font color of the text itself.