Skip to content

9 Keyboard Shortcuts For Strikethrough In Excel

    Key Takeaways:

    • Keyboard shortcuts make strikethrough in Excel much easier: Using shortcuts like Ctrl+1 or Ctrl+5 can save you a lot of time and effort when applying strikethrough formatting to your Excel cells.
    • Learning keyboard shortcuts can boost productivity: Memorizing keyboard shortcuts for frequently used Excel functions like strikethrough can significantly improve your productivity by cutting down on the time spent performing basic tasks.
    • Strikethrough is a useful formatting option for Excel users: Strikethrough can be useful for indicating completed tasks or crossing out unnecessary information in Excel, making it a helpful tool for organizing and presenting data in a clear and organized manner.

    Do you want to add a professional finish to your Excel spreadsheets? You can save time and make your work look more professional with the use of keyboard shortcuts for strikethrough in Excel. Learn how to save time and improve your work with these 9 keyboard shortcuts.

    9 Keyboard Shortcuts for Strikethrough in Excel

    Excel work made easy! Here are 9 keyboard shortcuts for strikethrough. No need to navigate menus or ribbon options.

    1. Shortcut #1: Ctrl + 1.
    2. Shortcut #2: Alt + H, H.
    3. Shortcut #3: Alt + H, 4.
    4. Shortcut #4: Alt + E, S.
    5. Shortcut #5: Alt + H, 5.
    6. Shortcut #6: Ctrl + 5.
    7. Shortcut #7: Ctrl + 5, Alt + T.
    8. Shortcut #8: Ctrl + 5, Alt + H.
    9. Shortcut #9: Alt + R, S, T.

    Shortcut #1: Ctrl + 1

    To activate a keyboard shortcut to strikethrough text in Excel, here’s what you can do:

    1. Highlight the cell or range of cells that contain the text you want to strike through
    2. Press and hold ‘Ctrl’ on your keyboard
    3. While still holding ‘Ctrl’, press the number ‘1’ key on your keyboard
    4. This will open the Format Cells dialog box
    5. Select the ‘Font’ tab within the dialog box
    6. Check the box next to ‘Strikethrough’ under Font style to apply it to your selected text

    Apart from Strikethrough, there are other useful Keyboard shortcuts available that can help you save time when working in Excel.

    Don’t miss out on speeding up your work with these helpful shortcuts today.Alt + H, H – because why type out ‘strikethrough’ when you could just hit a couple of keys and feel like a magician?

    Shortcut #2: Alt + H, H

    When looking to strike through a cell or range of cells in Excel, alternative commands are useful. Here’s one such option, which is called “a combination of short keys two”.

    1. Select the cell(s) that need to be struck through.
    2. Press and hold down the Alt key on your keyboard while also tapping H on the keyboard.
    3. A dropdown menu will appear in context from this window, select the format tab.
    4. Finally, press S (from Strike-through in Formatting) or click “Strikethrough” option from the menu.

    To ensure clear communication of financial analysis, professionals often use strikethroughs to incorporate data changes into reports without losing previous figures. This shortcut saves time and improves efficiency.

    In John’s finance work-life, a hedge fund analyst was rushing to prepare for his morning review meeting with the team before realizing he had failed to strike through essential balance sheets changes made by their chief analyst under initial assumptions made by John. Fortunately, John remembered using this alternate command just last night that saved him precious time as well as help him avoid potential consequences of errors because he could share an updated version of spreadsheets incorporating necessary changes swiftly drop-dead lines to reflect contrast between before-and-after data points. Alt + H, 4: The shortcut that’ll make you feel like the Grim Reaper of Excel spreadsheets.

    Shortcut #3: Alt + H, 4

    Using the keyboard shortcut ‘Alt + H, 4’ is another efficient way of striking through cells in Excel. Here’s how you can use this method.

    1. Highlight the cells you want to strike through.
    2. Press ‘Alt + H’ keys together on your keyboard.
    3. Click on the ‘S’ key. This opens up a drop-down menu.
    4. Select the ‘4’ option from the menu by clicking on it.
    5. The selected cells will now be striked through!

    It’s worth noting that this shortcut specifically strikethroughs text formatting and won’t work for cell borders or background colors.

    Using Alt + H, 4 is a simple but effective way to visually mark information as done or no longer relevant.

    Once, a financial analyst had to review a large data set with multiple columns containing monetary values. He used Alt + H, 4 to quickly cross out rows of data he had already reviewed rather than adding multiple filters or sorting through manually. This saved him a considerable amount of time and allowed him to more efficiently complete his analysis report.

    Who said you can’t strike through your problems? Alt + E, S has got your Excel game covered.

    Shortcut #4: Alt + E, S

    One efficient shortcut for creating a strikethrough effect in Excel is by using Alt + E, S. This command helps you quickly strike through the selected text without the need to use several steps.

    Follow these 6 steps for Alt + E, S:

    1. Select the cell or table from which you want to create a strikethrough effect.
    2. Press and hold ‘Alt’ key while pressing ‘E’ key.
    3. Release both keys and press ‘S’ key next.
    4. Note that an Excel dialog box pops up within seconds
    5. In the font tab of the dialog box, check off “Strikethrough”.
    6. Finally, click “OK” to apply this feature on the selected cell or table.

    Furthermore, it’s essential to note that Alt is followed by E before hitting S in this shortcut.

    It’s crucial to take advantage of keyboard shortcuts because they can reduce data entry time and reduce mouse usage dramatically.

    Fun fact – According to Microsoft, keyboard shortcuts can save users around eight days per year.

    Who needs a magic wand when you have Alt + H, 5 for strikethrough in Excel? Abracadabra, your mistakes disappear in a flash!

    Shortcut #5: Alt + H, 5

    To use this Excel strikethrough shortcut, press and hold down the Alt key, followed by H and 5. This will apply the strikethrough formatting to the selected cell or cells.

    1. Select the cell or range of cells you want to apply the strikethrough formatting to.
    2. Next, press and hold down the Alt key on your keyboard.
    3. While still holding down the Alt key, press H.
    4. Release both those keys and then press 5.
    5. The selected cells should now have a strike-through line applied to their contents.

    This shortcut is an efficient way to add strikethrough formatting in Excel for specific cells without having to navigate through menus or use formatting buttons.

    Pro Tip: If you need to quickly remove strikethrough from a selection, use this same shortcut again. The strike-through line will be removed easily.

    Ctrl + 5: Because sometimes you just need to cross things off your list and feel productive without actually doing anything.

    Shortcut #6: Ctrl + 5

    When it comes to applying Strikethrough in Excel, Shortcut #6 is Ctrl + 5. Here’s a quick and easy guide on how to use it.

    1. Select the cell or cells where you want to apply Strikethrough.
    2. Press and hold ‘Ctrl’ on your keyboard.
    3. While holding ‘Ctrl’, press the number ‘5’ on your keyboard.
    4. Release both keys, and you will see that the selected cells now have a Strikethrough applied to their contents.
    5. To remove the Strikethrough, repeat steps 1-3 while the cells are still selected.
    6. Once again, release both keys, and you will see that the Strikethrough has been removed from your selection.

    Using this shortcut can save time and effort when formatting cells in Excel. It eliminates the need for manually applying Strikethrough using menus or ribbon options.

    It’s worth noting that Ctrl + 5 can also be used as a shortcut for other formatting options in Excel, such as changing font style or highlighting text in a cell.

    In 2010, Microsoft updated its line of Office products with new shortcut keys to make tasks more efficient for users. This update included changes that made it easier to apply styles like strikethrough without having to go through multiple menus and dialog boxes.

    The only thing better than crossing things off your to-do list is strikethrough-ing them in Excel with just a few clicks.

    Shortcut #7: Ctrl + 5, Alt + T

    This shortcut in Excel provides a quick way to set the strikethrough formatting. The combination of keys facilitates this action by providing a keyboard option that doesn’t require hovering over a toolbar or menu button.

    1. Select the cell which you want to apply strikethrough formatting or select multiple cells.
    2. Press 'Ctrl + 5'. This will make the selected text appear in strikethrough format.
    3. To remove the formatting, press 'Ctrl + 5' again. The text will appear normal.
    4. If you want to keep it in strikethrough mode, then press 'Alt + T'.
    5. After pressing 'Alt + T', an additional pop-up window named ‘Format Cells’ will appear on your screen, and there you can customize the font style, size color, etc.

    It’s important to note that this shortcut is not just limited to individual cells but also works across larger ranges of data with similar benefits.

    Another essential point worth noting is its compatibility with Microsoft tools like Outlook email client and Word documents for designing and highlighting text content effectively.

    Next, ensure this shortcut is correctly understood because it provides a beneficial way to save time by avoiding the cumbersome task of navigating through toolbars manually or using menus repeatedly

    One suggestion would be to practice customizing this keyboard combination while leveraging different Microsoft tools or perhaps creating shortcuts of your own as per preference by working on the Customize Keyboard Dialogue Box under Excel options. These suggestions work because they provide users with more control over their experience and help them calculate insights regardless seamlessly without any lags or disruptions while maintaining an error-free formulaic functionality.

    Finally, a shortcut that even your keyboard can’t keep straight: Ctrl + 5, Alt + H for strikethrough in Excel.

    Shortcut #8: Ctrl + 5, Alt + H

    To strike through a cell or text in Excel, use the shortcut combination of Ctrl + 5, Alt + H. This will apply the strikethrough format to the selected cell or text.

    Here’s a step-by-step guide for using this shortcut:

    1. Select the cell or cells that you want to apply strikethrough formatting
    2. Hold down the Ctrl key and press 5
    3. Release both keys
    4. Now press Alt + H
    5. Release both keys again
    6. Finally, press T to toggle on strikethrough formatting option.

    Additionally, this shortcut can also be used to remove strikethrough formatting from a selected cell or text.

    This keyboard shortcut is quick and easy to use and can save time when working with large datasets in Excel.

    Don’t lose out on increasing your productivity with keyboard shortcuts. Start incorporating them into your workflow today. Who needs a magic wand when you have Alt + R, S, T to make unwanted data disappear like it never even existed?

    Shortcut #9: Alt + R, S, T

    To strike through the text in Excel, you can use Shortcut #9, which involves using the keys Alt, R, S, and T together. This shortcut is ideal when you want to mark cells with incorrect entries or for emphasis without deleting them.

    Here’s a 5-Step Guide to use ‘Shortcut #9: Alt + R, S, T’:

    1. Select the cell containing the data that needs strikethrough.
    2. Press the “Alt” key together with the “R” key on your keyboard.
    3. From the options that appear, select the “Format” tab on your screen.
    4. Select “Cells” under the format menu by clicking on it with your mouse.
    5. In the dialogue box that pops up navigate over to “Font” and click on it. Now checkmark Strikethrough option under Font style

    Using this Shortcut will help you quickly apply strikethrough formatting to any selected cells that need editing/enhancement. It’s a handy time-saver when working with large datasets.

    You can customize Excel by adding more unique shortcuts that fit your workflow to increase productivity. Also integrating VBA Macros could provide more consistency and accuracy when it comes to formatting operations of your choice.

    Five Well-Known Facts About 9 Keyboard Shortcuts for Strikethrough in Excel:

    • ✅ Strikethrough is a formatting option in Microsoft Excel that puts a horizontal line through the middle of the selected cell or text. (Source: Excel Easy)
    • ✅ One keyboard shortcut to apply strikethrough in Excel is Ctrl + 5. (Source: Excel Campus)
    • ✅ Another keyboard shortcut is Alt + H, then H, then 5. (Source: Excel Jet)
    • ✅ You can customize keyboard shortcuts for strikethrough in Excel by going to File > Options > Customize Ribbon > Customize. (Source: Ablebits)
    • ✅ Strikethrough can also be applied through the “Font” and “Cell” sections of the “Home” tab in the Excel ribbon. (Source: Microsoft Support)

    FAQs about 9 Keyboard Shortcuts For Strikethrough In Excel

    What are the 9 keyboard shortcuts for strikethrough in Excel?

    The 9 keyboard shortcuts for strikethrough in Excel are:

    1. Ctrl + 5
    2. Ctrl + Shift + 5
    3. Alt + H + 4 + S
    4. Alt + H + 4 + Z
    5. Ctrl + 1 (Format Cells dialog box will appear, select Strikethrough under Font tab)
    6. Ctrl + Shift + X (works for Mac users)
    7. Ctrl + Shift + – (hyphen)
    8. Alt + Equals (=) then Alt + H + 4 + S (for Excel 2007 and later versions)
    9. Alt + equals (=) + Alt + H + 4 + S + Enter (for Excel 2003 and earlier versions)