Strikethrough is a highly useful formatting feature in Excel that allows you to cross out text in cells. It’s especially handy for checklists, marking items as complete. This guide will navigate you through various methods to apply strikethrough in Excel, ensuring your Excel assignment looks polished and professional.
✅ AI Essay Writer ✅ AI Detector ✅ Plagchecker ✅ Paraphraser
✅ Summarizer ✅ Citation Generator
Strikethrough is a text formatting option that draws a line through the middle of the text in a cell. It’s often used to indicate that a task is complete or to mark items that are no longer relevant without removing them from the cell. Let’s delve into how to apply, modify, and remove strikethrough formatting in Excel.
Basic Strikethrough Formatting in Excel
Using the Format Cells Dialog
- Select the cell or range of cells you want to apply strikethrough to.
1to open the Format Cells dialog.
- Go to the Font tab.
- Under Effects, check the Strikethrough box and click OK.
Utilizing Excel’s Ribbon
Excel’s Ribbon interface provides a quick and convenient way to access various formatting options, including strikethrough. To apply strikethrough using the Ribbon, first, highlight the text you want to cross out in the selected cell. Then, go to the “Home” tab in the Excel Ribbon. In the “Font” group, locate and click the “Strikethrough” button (it looks like an ‘ab’ with a horizontal line through it).
Employing Keyboard Shortcut
Excel offers keyboard shortcuts for frequently used formatting options, and strikethrough is no exception. To apply strikethrough using a keyboard shortcut, select the text you want to cross out in the cell, and then press “Ctrl + 5” on your keyboard to apply strikethrough instantly.
For Excel for Mac users, the keyboard shortcut is
In Excel Online, the process of applying strikethrough is slightly different as some features might not be available. To add strikethrough in Excel Online, first, select the cell you want to format. Then, go to the “Home” tab and in the “Font” group, click the Strikethrough button.
Do you want to add strikethrough to the Quick Access Toolbar? Here’s how:
- Click the small arrow in the Quick Access Toolbar.
- Choose ‘More Commands’.
- From the ‘Choose commands from’ drop-down, select ‘All Commands’.
- Scroll down and select ‘Strikethrough’.
- Click ‘Add’ and then ‘OK’.
You can now use the Strikethrough button from the Quick Access Toolbar to cross out text in Excel.
Conditional Formatting with Strikethrough
Excel allows you to apply strikethrough automatically based on cell values using conditional formatting. This can be helpful for creating dynamic checklists or to-do lists. To use conditional formatting with strikethrough, first, select the cells you want to format. Then, go to the “Home” tab, click “Conditional Formatting” in the Styles group. Choose “New Rule,” and select “Use a formula to determine which cells to format.” Enter the formula that represents the condition for the strikethrough. Click the “Format” button, check the “Strikethrough” option under Effects, and click OK.
Your strikethrough formatting will now be applied automatically based on the cell values.
How to Remove Strikethrough in Excel
Removing strikethrough is as simple as applying it. To remove strikethrough, first, select the cell with the strikethrough you want to remove. Then, go to the “Home” tab and click the Strikethrough button again to deactivate it. Alternatively, you can use the Format Cells dialog (Ctrl + 1) and uncheck the Strikethrough option.
If you have applied strikethrough using conditional formatting, you can remove it by clearing the rules. To do this, select the cells with conditional formatting, go to the “Home” tab, click on “Conditional Formatting,” and choose “Clear Rules” from the menu.
Tips for Efficiently Using Strikethrough in Excel
- Use keyboard shortcuts for a faster way to apply or remove strikethrough.
- Add the strikethrough button to the Quick Access Toolbar if you use it frequently.
- Use conditional formatting for dynamic strikethrough based on cell values.
Strikethrough in Excel is a versatile tool that helps in various scenarios such as creating to-do lists or marking items as complete. With shortcuts, conditional formatting, and Quick Access Toolbar customization, using strikethrough becomes an even more powerful and efficient task. Whether you are using Excel on Windows, Mac, or online, understanding and utilizing the strikethrough formatting will surely add to your Excel proficiency.
You can find more STEM Guides in our designated category here at A*Help!
What is the shortcut to strikethrough in Excel?
In Excel for Windows, you can use the shortcut
5 to apply strikethrough to the selected text or cell. For Excel on Mac, the shortcut is
Can I apply strikethrough via format options?
Yes, you can apply strikethrough via format options. To do this, select the cells you want to format, then press
1 to open the Format Cells dialog. Go to the Font tab, check the Strikethrough option, and click OK.
How to Cross out text in Excel?
To cross out text in Excel, select the cells containing the text you want to cross out, go to the Home tab, and in the Font group, click the Strikethrough button. You can also use the keyboard shortcut
5 for Windows or
X for Mac.
How to Cross out completed tasks automatically in Excel?
You can cross out completed tasks automatically in Excel by using Conditional Formatting. Select the cells with tasks, go to the Home tab, click on ‘Conditional Formatting’ in the Styles group, and choose ‘New Rule’. Select ‘Use a formula to determine which cells to format’, enter the formula representing the condition for completed tasks, click the ‘Format’ button, check the ‘Strikethrough’ option under Effects, and click OK.
Can I Strikethrough entire rows based on a condition in Excel?
Yes, you can strikethrough entire rows based on a condition using Conditional Formatting. Select the rows you want to apply the formatting to, go to the Home tab, and click on ‘Conditional Formatting’. Choose ‘New Rule’ and select ‘Use a formula to determine which cells to format’. Enter a formula to identify the rows that meet your condition, click ‘Format’, check the ‘Strikethrough’ option, and click OK.
How to Apply strikethrough format to multiple cells in Excel?
To apply the strikethrough format to multiple cells, select all the cells you want to format by clicking and dragging or by holding down
Ctrl and clicking on individual cells. Then, go to the Home tab and click the Strikethrough button in the Font group. Alternatively, you can use the
5 keyboard shortcut after selecting the cells.
Follow us on Reddit for more insights and updates.