Excel Shortcut Key for Strikethrough: How to Cross Out Text in Excel

Understanding Excel Strikethrough Shortcut Key

Excel for Desktop

Excel for Desktop is a popular spreadsheet program that allows users to perform various tasks with ease. One of the essential features of Excel is the ability to format data. Strikethrough is a formatting option that allows users to cross out data in a cell.

To apply strikethrough in Excel for Desktop using a keyboard shortcut, follow these steps:

  1. Select the cell(s) you want to format.
  2. Press the “Ctrl” and “5” keys simultaneously.
  3. The selected cells will now have strikethrough formatting.

Excel Online

Excel Online is a web-based version of Excel that allows users to create and edit spreadsheets from anywhere with an internet connection.

To apply strikethrough in Excel Online using a keyboard shortcut, follow these steps:

  1. Select the cell(s) you want to format.
  2. Press the “Ctrl” and “5” keys simultaneously.
  3. The selected cells will now have strikethrough formatting.

Excel for Mac

Excel for Mac is a version of Excel designed specifically for Apple’s macOS operating system.

To apply strikethrough in Excel for Mac using a keyboard shortcut, follow these steps:

  1. Select the cell(s) you want to format.
  2. Press the “Command” and “Shift” and “X” keys simultaneously.
  3. The selected cells will now have strikethrough formatting.

It’s important to note that the keyboard shortcut for strikethrough in Excel may vary depending on the version of Excel and the operating system being used. However, the steps provided above should work for most versions of Excel.

Applying and Removing Strikethrough

Strikethrough formatting is a useful way to indicate completed tasks or to visually highlight text that is no longer relevant. Here’s how to apply and remove strikethrough formatting in Microsoft Excel:

Applying Strikethrough Formatting

  1. Select the cell or range of cells that you want to apply strikethrough formatting to.
  2. Navigate to the Home tab on the ribbon.
  3. Click on the Font tab in the Formatting group.
  4. Check the box next to Strikethrough or use the keyboard shortcut Ctrl + 5.

Removing Strikethrough Formatting

  1. Select the cell or range of cells that you want to remove strikethrough formatting from.
  2. Navigate to the Home tab on the ribbon.
  3. Click on the Font tab in the Formatting group.
  4. Uncheck the box next to Strikethrough or use the keyboard shortcut Ctrl + 5.

Adding the Strikethrough Icon to the Quick Access Toolbar

If you use strikethrough formatting frequently, you can add the Strikethrough button to the Quick Access Toolbar (QAT) for easy access. Here’s how:

  1. Right-click on the Strikethrough button in the Font group on the ribbon.
  2. Select Add to Quick Access Toolbar.
  3. The Strikethrough button will now appear in the QAT at the top of the Excel window.

Using Strikethrough in Excel for Mac

To apply or remove strikethrough formatting in Excel for Mac, follow these steps:

  1. Select the cell or range of cells that you want to apply strikethrough formatting to.
  2. Click on the Format Cells button in the Home tab on the ribbon.
  3. In the Format Cells dialog box, click on the Font tab.
  4. Check the box next to Strikethrough to apply strikethrough formatting.
  5. Uncheck the box next to Strikethrough to remove strikethrough formatting.

Using Strikethrough in Excel Online

To apply or remove strikethrough formatting in Excel Online, follow these steps:

  1. Select the cell or range of cells that you want to apply strikethrough formatting to.
  2. Click on the Formatting menu in the formula bar.
  3. Click on the Strikethrough button to apply strikethrough formatting.
  4. Click on the Strikethrough button again to remove strikethrough formatting.

Using Strikethrough in Visual Basic for Applications (VBA)

To apply or remove strikethrough formatting using VBA, use the following code:

' Apply strikethrough formatting to cell A1
Range("A1").Font.Strikethrough = True

' Remove strikethrough formatting from cell A1
Range("A1").Font.Strikethrough = False

Using Strikethrough with Conditional Formatting

You can use strikethrough formatting as part of conditional formatting to automatically apply it to cells based on certain criteria. Here’s how:

  1. Select the range of cells that you want to apply conditional formatting to.
  2. Click on the Conditional Formatting button in the Home tab on the ribbon.
  3. Select New Rule.
  4. Choose the type of rule you want to create (e.g. Highlight Cells Rules or Top/Bottom Rules).
  5. Set the criteria for the rule.
  6. Click on the Format button.
  7. Check the box next to Strikethrough in the Font tab of the Format Cells dialog box.
  8. Click OK to apply the conditional formatting rule.

Using Strikethrough with Comments and Tracking Changes

You can use strikethrough formatting in comments and when tracking changes to indicate changes to text. Here’s how:

  1. Select the text you want to apply strikethrough formatting to in the comment or tracked change.
  2. Navigate to the Font tab in the Formatting tool.
  3. Check the box next to Strikethrough to apply strikethrough formatting.
  4. Uncheck the box next to Strikethrough to remove strikethrough formatting.

Customizing Strikethrough Keyboard Shortcuts

If you prefer to use a different keyboard shortcut to apply or remove strikethrough formatting, you can customize the shortcuts in Excel. Here’s how:

  1. Click on the File tab in the ribbon.
  2. Click on Options.
  3. Select Customize Ribbon.
  4. Click on the Customize button next to Keyboard Shortcuts.
  5. In the Categories list, select Home Tab.
  6. In the Commands list, select Strikethrough.
  7. Click in the Press new shortcut key field.
  8. Press the keyboard shortcut you want to use (e.g. Ctrl + Shift + X).
  9. Click Assign.
    10

Advanced Uses of Strikethrough

Strikethrough is a versatile formatting tool that can be used for more than just crossing out completed tasks. Here are some advanced uses of strikethrough in Excel:

  • Workflow: Strikethrough can help streamline your workflow by indicating which cells or rows need attention. For example, you can use strikethrough to mark cells that contain invalid data or formulas that need to be updated.

  • Function: Strikethrough can also be used as part of a function. For example, you can use the CONCATENATE function to combine two or more cells and then apply strikethrough to the text in one of the cells. This can be useful for highlighting changes or revisions in a document.

  • Excel Courses: Learning how to use strikethrough effectively can be a valuable skill for anyone who works with Excel. Many Excel courses cover strikethrough as part of their curriculum, and there are also online tutorials and videos that can help you master this formatting tool.

  • Frequently Asked Questions: Some common questions about strikethrough in Excel include: How do I apply strikethrough to text in a cell? Can I use strikethrough in a formula? How do I remove strikethrough from a cell? Answers to these and other frequently asked questions can be found in Excel’s help documentation or through online forums and communities.

  • Efficiency: Using strikethrough can help you work more efficiently by quickly identifying completed tasks or highlighting areas that need attention. By mastering this formatting tool, you can save time and improve the accuracy of your work.

In summary, strikethrough is a powerful formatting tool that can be used in a variety of ways to improve your workflow, highlight changes, and increase efficiency in Excel. With practice and training, anyone can learn how to use strikethrough effectively and take their Excel skills to the next level.

Authors

  • Robert Miller

    Meet Robert James Miller, the meticulous editor at CostOfIncome, where precision meets passion. While his editorial skills have consistently elevated the platform's content, it's his profound expertise in Excel that sets him apart. Robert doesn't just know Excel; he commands it, transforming complex data into insightful narratives. His depth of understanding has not only aided in streamlining operations at CostOfIncome but has also positioned him as the go-to guru for all things Excel-related.

  • Collin Bennett

    eagle-eyed fact-checker at the heart of every post's accuracy. In an age where information is abundant and mistakes are costly, Samuel stands as the gatekeeper of truth for all Excel-related content. His meticulous approach ensures that every formula, every function, and every data-driven insight is both precise and verifiable.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.