How to Strikethrough in Excel (Menus, Tools, and Shortcuts)

Microsoft Excel is a powerful spreadsheet application commonly used for data management, analysis, and visualization. One useful feature of Excel is the strikethrough function, which allows users to indicate completed tasks, corrections, or changes in their data entries. Knowing how to effectively use the strikethrough option can enhance the clarity of your spreadsheets and improve overall organization.

This article will cover various methods to apply strikethrough formatting in Excel, including navigating through menus, using formatting tools, and utilizing keyboard shortcuts. Whether you’re a novice user or have previous experience with Excel, you’ll find actionable steps that cater to different preferences.

How to Strikethrough in Excel?

To strikethrough text in Excel, you can use the Format Cells dialog, Quick Access Toolbar, or keyboard shortcuts. Each method varies but ultimately allows you to mark text visibly as struck through within your spreadsheet. Keep reading to learn about these approaches in detail.

Understanding the Strikethrough Feature in Excel

Strikethrough is a formatting option in Excel that draws a horizontal line through the center of a text string. This feature is particularly useful in numerous situations, such as:

Marking completed tasks in to-do lists.
Indicating revisions or deletions in data sets.
Highlighting changes made to original data entries.

By incorporating strikethrough formatting, you can keep your data organized and visually clear, leading to better understanding for both yourself and collaborators.

Prerequisites for Using Strikethrough in Excel

Before you start using the strikethrough feature, ensure you have:

A computer with Microsoft Excel installed (the instructions apply to Excel 2010 and later versions).
A workbook open with some data entered for practice.

Strikethrough in Excel Using the Format Cells Dialog

The Format Cells dialog provides a detailed view of various formatting options, including strikethrough. Follow these steps to access and use this feature:

Select the cell or range of cells containing the text you wish to strikethrough.
Right-click on the selected cell(s) and choose Format Cells from the context menu. Alternatively, you can navigate to the Home tab on the Ribbon, find the Format dropdown, and choose Format Cells.
In the Format Cells dialog that appears, click on the Font tab.
Locate the Strikethrough checkbox and check it.
Click OK to apply the changes. You should see the selected text now displayed with a strikethrough.

Using the Quick Access Toolbar to Strikethrough in Excel

Another efficient way to apply strikethrough formatting is through the Quick Access Toolbar. If this tool is not customized, you may need to add the strikethrough option initially. Here’s how:

Open Excel and click on the small arrow in the Quick Access Toolbar located above the Ribbon.
Select More Commands… from the dropdown menu.
In the Excel Options dialog, under the Choose commands from dropdown, select All Commands.
Scroll through the list until you find Strikethrough and highlight it.
Click the Add >> button to include it in your Quick Access Toolbar.
Click OK to finalize your settings. You should now see the strikethrough icon in your Quick Access Toolbar.
To use it, simply select the text you wish to strikethrough and click the strikethrough icon.

Applying Strikethrough Using Keyboard Shortcuts

Keyboard shortcuts can save you time and make the process of formatting text in Excel quicker. You can use the following keyboard shortcuts to strikethrough text:

For Windows: Press Ctrl + 5 after selecting the cells you want to strikethrough.
For Mac: Press Command + Shift + X after selecting the cells you want to strikethrough.

This method is particularly handy when making numerous formatting adjustments in a short period.

Using Strikethrough in Conditional Formatting

Conditional Formatting in Excel allows you to apply formats based on cell values or certain conditions. Interestingly, you can use strikethrough for visual efficiencies in your data presentation. To set up conditional formatting with strikethrough:

Select the range of cells you want to format.
Navigate to the Home tab and click on Conditional Formatting.
Select New Rule… to define your criteria.
In the New Formatting Rule dialog, choose Use a formula to determine which cells to format.
Enter a formula that returns TRUE for the conditions you want to apply strikethrough. For example: =A1="completed".
Click on the Format… button, go to the Font tab, and check the Strikethrough option.
Click OK on both dialog boxes to finalize your new rule.

The selected cells will now automatically show a strikethrough when their values meet the specified conditions.

Common Errors and Troubleshooting

While using strikethrough in Excel is generally straightforward, you may encounter a few common issues. Here are some troubleshooting tips:

Strikethrough Not Appearing: Ensure that the cells are not locked or protected. If the worksheet is protected, you won’t be able to apply formatting.
Keyboard Shortcuts Not Working: Confirm that no other Excel options are interfering with the shortcuts. Restarting Excel can help resolve temporary glitches.
Strikethrough Isn’t Saving: Check if your workbook is saved in a compatible format. Save it as an Excel Workbook (.xlsx) when dealing with formatting issues.

Alternatives to Strikethrough

If you find that strikethrough doesn’t quite meet your needs, consider these alternatives:

Highlighting Cells: Instead of strikethrough, you might want to use a different cell background color to indicate completed tasks.
Using Comments: Adding comments to cells can provide additional context without altering the actual cell content.
Creating Separate Columns: If tracking completed tasks, a separate column labeled “Completed” may work better for clarity.

Practical Applications of Strikethrough

Strikethrough can be applied in various practical scenarios within Excel:

Project Management: Mark off tasks as they are completed in project tracking sheets.
Inventory Management: Indicate items that have been sold or are no longer in stock.
Data Revisions: Show which entries require updates or deletions in data logs.

Conclusion

Learning how to strikethrough in Excel can significantly improve the way you manage and present your data. Whether you use menus, the Quick Access Toolbar, or keyboard shortcuts, you have multiple options to achieve effective formatting. Apply what you’ve learned and explore creative ways to improve your spreadsheets further.

If you want to expand your skill set, consider learning how to do strikethrough on Google Docs or exploring more about striking through text in Excel. Enhance your productivity and make your data clearer and more organized!