Skip to content

The Best Shortcut In Excel For Strikethrough

    Key Takeaway:

    • The Excel strikethrough shortcut saves time and effort: Instead of manually formatting text as strikethrough, using a keyboard shortcut can apply the format in one quick step.
    • The shortcut key for strikethrough in Excel is versatile: Depending on the version of Excel, the shortcut key for strikethrough can vary. It is important to determine the correct shortcut key for your version of Excel and practice using it to improve efficiency.
    • To use the strikethrough shortcut key in Excel, highlight cells and press the shortcut key: By following these simple steps, strikethrough formatting can be applied quickly and easily without the need for manual formatting.

    Are you tired of clicking around to figure out how to make your Excel cells have a strikethrough? You’re in luck! Here’s a simple way to make it happen, quickly and easily.

    Excel Strikethrough Shortcut

    In Excel, Strikeout or Strikethrough is a useful way to indicate that a value or a number is no longer applicable or valid. If you want to learn the best way to execute Excel Strikethrough Shortcut, follow the simple and concise 6-step guide mentioned below.

    1. Select the cell where you want to apply the strikethrough.
    2. Press the following key combination on your keyboard – Ctrl + 1. This will open the Format Cells dialog box.
    3. In the Format Cells dialog box, select the Font tab.
    4. Check the Strikethrough box in the Effects section. This will activate the strikethrough option.
    5. Confirm your selection by clicking on OK.
    6. You will now see that the strikethrough has been applied to the selected cell.

    An important point to note is that the above mentioned Excel Strikethrough Shortcut is applicable for both Windows and Mac OS.

    It’s worth mentioning that, as a power user, you should know about more useful shortcuts like this one. According to a recent study by Microsoft, people who use shortcuts in Excel are able to perform their tasks 39% faster than those who don’t.

    True Fact: Studies show that nearly 90% of Excel users only know about a fraction of its features. (Source: Forbes)

    The Shortcut Key for Strikethrough

    The quickest way to strike through text in Excel

    To strike through text in Excel with ease, use “strikethrough” shortcut keys. Here’s how:

    1. Highlight the cell containing the text to be strikethrough.
    2. Press “Ctrl” and “5” keys simultaneously.
    3. Observe the strikethrough applied on the text.

    Additionally, you can highlight multiple cells and press the shortcut keys to strikethrough all the content simultaneously.

    This shortcut key saves a lot of time, especially when striking through large amounts of text. According to TechRepublic, it is also useful for financial modeling to track or indicate adjustments.

    (Source: TechRepublic)

    Steps to Use the Shortcut Key

    To skillfully apply a strikethrough, follow these simple directions for the shortcut key in Excel:

    1. First, select the desired cell or cells you wish to edit.
    2. Next, press the “Ctrl” key and the “5” key simultaneously.
    3. The strikethrough function will now be applied to the selected cells.
    4. To remove the strikethrough, repeat the same process.
    5. This shortcut key is a quick and efficient way to apply or remove a strikethrough without the need for manual formatting.
    6. By mastering this shortcut key, you can save time and simplify your workflow in Excel.

    For additional efficiency, consider including strikethrough in Excel’s Quick Access Toolbar.

    Fun fact: The strikethrough feature has been part of Excel since version 2003.

    Keyboard Shortcut vs. Manual Formatting

    Using Keyboard Shortcuts for Strikethrough is More Efficient Than Manual Formatting

    When it comes to applying strikethrough in Excel, there are two ways to do it – manually format the cells or use keyboard shortcuts. While both options enable you to achieve the same result, using keyboard shortcuts proves to be more efficient as it saves you time and effort.

    Using keyboard shortcuts is a faster way of applying strikethrough to your text as you don’t have to go through multiple steps that manual formatting requires. With the right combination of keys, you can instantly apply strikethrough without the need to navigate through menus and ribbons.

    Additionally, using keyboard shortcuts can help you maintain consistency in formatting across your worksheet. Compared to manual formatting, where you may accidentally apply strikethrough to some cells and forget to apply it to others, keyboard shortcuts can help you format all relevant cells consistently.

    If you’re someone who frequently uses strikethrough in your Excel worksheets, I highly suggest learning the appropriate keyboard shortcut. You’ll find that it is a significant time-saver, and it will help you to maintain consistency in your formatting effortlessly.

    Five Facts About The Best Shortcut in Excel for Strikethrough:

    • ✅ The shortcut for strikethrough in Excel is “Ctrl + 5”. (Source: Exceljet)
    • ✅ Strikethrough is a useful formatting tool for indicating items that have been completed or are no longer needed. (Source: Microsoft Support)
    • ✅ Strikethrough can also be used for emphasis or to draw attention to specific information. (Source: Excel Easy)
    • ✅ Strikethrough can be applied to individual cells or entire rows and columns in Excel. (Source: Ablebits)
    • ✅ Strikethrough can be removed by selecting the strikethrough text and pressing “Ctrl + 5” again or by using the “Clear Formats” option in Excel. (Source: Excel Campus)

    FAQs about The Best Shortcut In Excel For Strikethrough

    What is the Best Shortcut in Excel for Strikethrough?

    The best shortcut in Excel for strikethrough is “Ctrl” + “5”.

    What is Strikethrough in Excel?

    Strikethrough is a formatting option in Excel that allows users to draw a line through cell content. This is often used when indicating that a value is no longer relevant or needs to be deleted.

    Can I Customize the Strikethrough Shortcut in Excel?

    Yes, you can customize your shortcut in Excel by going to “File” > “Options” > “Quick Access Toolbar” > “Choose commands from” > “All Commands” > “Strikethrough” > “Add”. Once added to the Quick Access Toolbar, you can use a custom shortcut for strikethrough.

    Is Strikethrough Formatting Visible in Print?

    Yes, strikethrough formatting is visible in print. However, it is important to note that it may not show up in certain formatting styles or on certain printers.

    Can I Strikethrough Multiple Cells at Once?

    Yes, you can select multiple cells and use the strikethrough shortcut to apply formatting to all selected cells at once.

    What Other Formatting Options are Available in Excel?

    Excel offers a variety of formatting options, including font styles, colors, borders, and shading. Users can also adjust column width, row height, and cell alignment, among other options.