How To Do Strikethrough In Excel

Introduction

Excel is a powerful tool for data analysis and visualization, but sometimes you need to indicate that certain data is no longer relevant or has been corrected. One way to do this is by using a strikethrough, which adds a line through the text or numbers in a cell. This visual indicator helps you and others working with the spreadsheet understand the context and status of the data. In this guide, we’ll walk you through the steps to apply a strikethrough in Excel, whether you’re using the desktop version or working in the online app.

Applying Strikethrough in Excel Desktop

To add a strikethrough to a cell or range of cells in Excel Desktop, follow these simple steps:

Step 1: Select the Cells

  • Begin by opening your Excel workbook and navigating to the worksheet where you want to apply the strikethrough.
  • Click on the cell or drag your cursor to select a range of cells that you want to format.

Step 2: Apply the Strikethrough Format

  • With the cells selected, go to the “Home” tab on the Excel ribbon.
  • In the “Font” group, you’ll find a variety of formatting options. Look for the “Font” dropdown menu, which has a small arrow next to it.
  • Click on the arrow to open the “Font” dialog box. Alternatively, you can use the keyboard shortcut “Ctrl + 1” to open the “Format Cells” dialog box directly.
  • In the “Font” dialog box, navigate to the “Effects” section.
  • Check the box next to “Strikethrough.”
  • Click “OK” to apply the strikethrough format to the selected cells.

Working with Strikethrough in Excel Online

Excel Online, the web-based version of Excel, also allows you to apply a strikethrough to your data. Here’s how you can do it:

Step 1: Open Excel Online and Select Cells

  • Access Excel Online through your web browser by going to the Microsoft Office website or logging in to your Microsoft account.
  • Open the spreadsheet you want to work with or create a new one.
  • Click on the cell or drag your cursor to select a range of cells that need the strikethrough format.

Step 2: Apply the Strikethrough Format in Excel Online

  • With the cells selected, look for the “Font” group on the Excel Online ribbon.
  • Click on the “Font” dropdown menu, which is usually located next to the “Font Color” and “Font Size” dropdowns.
  • In the “Font” dropdown menu, you’ll find various formatting options. Scroll down or use the search bar to find the “Strikethrough” option.
  • Click on “Strikethrough” to apply the format to the selected cells.

Advanced Strikethrough Techniques

Now that you know the basics of applying a strikethrough in Excel, let’s explore some advanced techniques to enhance your data visualization:

Using Conditional Formatting with Strikethrough

  • Conditional formatting allows you to apply strikethrough based on specific conditions or rules.
  • For example, you can set up a rule to strikethrough cells that contain a specific value or meet certain criteria.
  • To do this, select the cells you want to format, go to the “Home” tab, and click on “Conditional Formatting.”
  • Choose the type of rule you want to apply, such as “Cell Value” or “Formula,” and set the conditions.
  • In the “Format cells that meet any of these criteria” section, select “Custom Format” and navigate to the “Font” tab.
  • Check the “Strikethrough” box and click “OK” to apply the conditional formatting.

Combining Strikethrough with Other Formats

  • You can combine the strikethrough format with other text effects to create more complex visual indicators.
  • For instance, you might want to use both strikethrough and italics to emphasize corrected data.
  • To do this, follow the steps to apply the strikethrough format, and then select the “Font” dropdown menu again.
  • In the “Font” dialog box, go to the “Effects” section and check the box next to “Italic.”
  • Click “OK” to apply both formats to the selected cells.

Customizing Strikethrough Appearance

  • Excel allows you to customize the appearance of the strikethrough to match your preferences or the style of your spreadsheet.
  • To customize the strikethrough, open the “Font” dialog box as described earlier.
  • In the “Effects” section, you’ll find options to change the color and style of the strikethrough.
  • You can choose a different color for the strikethrough line or select a style, such as “Single Accounting,” to adjust the thickness and position of the line.

Conclusion

Applying a strikethrough in Excel is a simple yet effective way to indicate changes or corrections in your data. Whether you’re using Excel Desktop or Excel Online, the process is straightforward and can be customized to meet your specific needs. Remember to explore conditional formatting and combine strikethrough with other formats to create meaningful visual indicators in your spreadsheets. With these techniques, you can enhance data clarity and communication within your team or organization.

FAQ

Can I apply a strikethrough to multiple non-adjacent cells at once?

+

Yes, you can apply a strikethrough to multiple non-adjacent cells by holding down the “Ctrl” key while selecting the cells. Then, follow the steps to apply the strikethrough format as usual.

How do I remove the strikethrough format from cells in Excel?

+

To remove the strikethrough format, select the cells with the strikethrough and follow the same steps to apply the format. However, this time, uncheck the “Strikethrough” box in the “Font” dialog box or the “Font” dropdown menu. Click “OK” to remove the strikethrough.

Can I use strikethrough in Excel for Mac?

+

Yes, the process for applying a strikethrough in Excel for Mac is similar to the desktop version. You can find the “Font” dialog box or dropdown menu in the “Home” tab and follow the same steps to apply or remove the strikethrough format.