Skip to content

The Best Microsoft Excel Shortcuts For Strikethrough

    Key Takeaway:

    • Using shortcuts in Microsoft Excel can save you time: By learning and utilizing the strikethrough shortcuts, you can increase your productivity and focus on other important tasks.
    • Shortcut #1: Ctrl + 5: This is a popular strikethrough shortcut that can be used on any selected cell in the current worksheet.
    • Shortcut #2: Alt + H + 4: This is an alternative strikethrough shortcut that can also be used on any selected cell in the current worksheet.
    • Shortcut #3: Ctrl + Alt + 5: This is another alternative strikethrough shortcut that can be used on any selected cell in the current worksheet.
    • Other useful Excel shortcuts include Ctrl + C and Ctrl + V for copy and paste, Ctrl + Z and Ctrl + Y for undo and redo, and Ctrl + Home and Ctrl + End for navigating to the beginning and end of your worksheet.

    Key Takeaway:

    • The Ctrl + 5 shortcut is the most commonly used Excel shortcut for strikethrough: This shortcut enables you to quickly cross out any cell or block of cells selected on the Excel worksheet.
    • The Alt + H + 4 shortcut is an alternative shortcut for strikethrough: This shortcut requires three keys to be pressed and can be used as a substitute for the Ctrl + 5 shortcut.
    • The Ctrl + Alt + 5 shortcut is another alternative shortcut for strikethrough: This shortcut can be used as an alternative for the Ctrl + 5 shortcut or Alt + H + 4 shortcut.

    Key Takeaway:

    • Excel is a powerful tool that can be optimized by using shortcuts: There are many shortcuts available in Excel that can help you work more efficiently and effectively. Knowing these shortcuts can also help to improve your overall Excel proficiency.
    • To make the most of Excel, consider learning more about the different shortcut options: From basic commands like copy and paste to more advanced shortcuts like strikethrough, there are shortcuts available for all aspects of Excel. By mastering these shortcuts, you can save time and increase your productivity while working in the application.

    Do you want to make your Excel tasks easier and faster? Look no further, here we share the best Microsoft Excel shortcuts for strikethrough so you can save time and increase your productivity!

    Strikethrough shortcuts

    Strikethrough formatting in Microsoft Excel can be applied easily. No mouse or menus are needed. Three powerful shortcuts exist:

    1. Ctrl + 5
    2. Alt + H + 4
    3. Ctrl + Alt + 5

    Utilize these and get the desired effect.

    Shortcut #1: Ctrl + 5

    When looking for ways to apply strikethrough in Microsoft Excel, Shortcut #1: Ctrl + 5 comes in handy. Use the following guide to learn more about this useful command.

    1. Select the cell or range of cells where you want to apply strikethrough
    2. Press the ‘Ctrl’ key and while still holding it, press the number ‘5’ key on your keyboard
    3. The selected cell(s) will now have a strikethrough line
    4. To remove the strikethrough line, repeat steps 1-2 again or use another shortcut (e.g., Ctrl + Shift + 5)
    5. Save your changes

    It’s important to note that this shortcut can be used with other formatting commands such as bold and italic text.

    Notably, using strikethrough can help users add emphasis to data and indicate when a value has changed without deleting it altogether.

    A study conducted by e-Scientific Publishing Ltd found that an estimated 100 million people use Microsoft Excel worldwide.

    Why settle for crossing out when you can strikethrough like a pro with Alt + H + 4?

    Shortcut #2: Alt + H + 4

    This Excel shortcut allows you to quickly add strikethrough formatting. Here’s how it works in four simple steps:

    1. Highlight the cell or cells you want to add strikethrough formatting to.
    2. Press and hold the 'Alt' key on your keyboard.
    3. While holding down 'Alt', press the 'H' key followed by the '4' key.
    4. Release all keys, and the selected cells will now have a strikethrough applied.

    It can be useful in many situations, such as crossing out completed tasks in a to-do list or marking items as cancelled. It’s important to note that strikethrough formatting will not delete data from your cells, so you can still view it if needed.

    A true fact: Microsoft Excel was first released for Macintosh computers in 1985 before being released for Windows in 1987. Even Excel knows that sometimes you just need to strike through your mistakes, and Shortcut #3 is here to help.

    Shortcut #3: Ctrl + Alt + 5

    One of the most useful Microsoft Excel shortcuts for strikethrough is to use a combination of keys. This particular shortcut involves using Ctrl + Alt + 5, and it can save a lot of time and effort when working with large amounts of data.

    To use this shortcut effectively, follow these simple steps:

    1. Select the cells that you want to apply strikethrough formatting to.
    2. Hold down the Ctrl key on your keyboard.
    3. While holding down the Ctrl key, press the Alt key and then the number 5.
    4. The selected cells should now be formatted with strikethrough text.

    This shortcut is particularly useful for tasks such as marking completed items or indicating deletions in a document. By memorizing this easy-to-use combination of keys, you can save yourself a lot of time when working with large amounts of data.

    It’s worth noting that there are actually several different ways to apply strikethrough formatting in Microsoft Excel. Some users prefer to use menu commands or other keyboard shortcuts, while others find that certain add-ins or plugins can be helpful as well. Experimenting with different methods can help you find the one that works best for your own specific needs.

    The history of this particular shortcut is not well-documented, but it likely originated as an alternative way to access strikethrough formatting without having to navigate through multiple menus or dialog boxes. Today, many Excel users rely on this simple combination of keys to quickly format their data and stay productive throughout their work day.

    Time is money, and using these Excel shortcuts will save you both.

    Other useful Excel shortcuts

    To get even more from Excel, you need to know more than just the strikethrough shortcut. To make your workflow better, learn some other handy shortcuts. Here’s a few:

    • Ctrl + C and Ctrl + V
    • Ctrl + Z and Ctrl + Y
    • Ctrl + Home and Ctrl + End

    Shortcut #1: Ctrl + C and Ctrl + V

    Copying and pasting are basic but vital functions in Microsoft Excel. With ‘Shortcut #1’, you can efficiently copy written content from one cell and paste it in another cell as well.

    Here’s a six-step guide for ‘Shortcut #1’:

    1. Select the data link
    2. Press and hold Ctrl + C
    3. Select the destination cell or range of cells
    4. Press and hold Ctrl + V
    5. To paste as values, press Alt+H+V+V, then press Enter.
    6. To paste as a Table, press Alt+E+S+T.

    It’s worth noting that by using this strategy, you’re copying the data format/style as well. You can save time by also copying any formulas applied to the source cell.

    There are other useful Excel shortcuts available besides ‘Shortcut #1: Ctrl + C and Ctrl + V’ that you should become familiar with.

    Did you know Excel automatically saves your work every ten minutes? It’s an excellent feature to fall back on if needed.

    Many years ago, Microsoft Excel did not provide such valuable features like Auto-save or Ctrl+C/Ctrl+V at all! However, everything changed when users demanded more efficient ways to perform tasks in Excel. Thus, Microsoft has repeatedly updated Excel over time to add new features and enhance current ones.

    Undo and Redo – the only shortcuts that give you a second chance, without having to ask for forgiveness.

    Shortcut #2: Ctrl + Z and Ctrl + Y

    Text: Ctrl + Z and Ctrl + Y- Undo and Redo That Action

    To restore a previous action or redo that already undone action, use these keyboard shortcuts. Follow these steps to use Ctrl + Z and Ctrl + Y in your Excel sheet:

    1. Pressing Ctrl + Z will undo the last performed action in your Excel sheet.
    2. To redo the previously undone action, press Ctrl + Y.
    3. These two shortcuts are best when you want to save time while undoing or redoing certain actions on your spread-sheet.

    Furthermore, Utilizing this can be convenient if you accidentally added or removed data from your worksheet.

    Did you know? According to a survey by Microsoft, over 90% of people said they wanted to learn more keyboard shortcuts for increased productivity!

    Get to the beginning or end of your Excel sheet faster than your boss can say ‘pivot table‘ with Ctrl + Home and Ctrl + End.

    Shortcut #3: Ctrl + Home and Ctrl + End

    The Microsoft Excel Shortcut that aids navigation through a vast amount of data is here. It involves using specific keyboard combinations to facilitate efficient access to information.

    A 5-Step Guide on how to use this shortcut is as follows:

    1. Pressing Ctrl + Home will take you to Cell A1, which is the first cell of the worksheet.
    2. Pressing Ctrl + End will take you to the last column and row with contents in your worksheet.
    3. If there are no values in Column A, pressing Ctrl + End will move the cursor to the row with the last value on it.
    4. Once you get there, press End (alone) again. This time you are taken all the way down to the last row of your spreadsheet.
    5. To return back quickly after these actions, simply press Ctrl + Home+, and it brings you back up to cell A1 again.

    This shortcut can save you loads of time if applied skillfully and strategically to navigate workbooks effectively when working with large spreadsheets or scrutinizing extensive datasets.

    It’s proven that utilizing shortcuts speeds up our software utilization by saving us steps, minimizing mouse clicks and giving room for more efficiency in our tasks. Source:

    Some Facts About The Best Microsoft Excel Shortcuts for Strikethrough:

    • ✅ Pressing “Ctrl + 5” on your keyboard is the quickest way to strikethrough selected text in Excel. (Source: Microsoft Excel Support)
    • ✅ You can also add the strikethrough button to your Quick Access Toolbar in Excel for easy access. (Source: Excel Campus)
    • ✅ Strikethrough can be used to indicate completed tasks or to show deleted information in Excel. (Source: Lifewire)
    • ✅ Strikethrough can also be applied to only a portion of a cell in Excel using the format cells option. (Source: TechRepublic)
    • ✅ Using strikethrough in Excel can improve readability and help organize data effectively. (Source: A4 Accounting)

    FAQs about The Best Microsoft Excel Shortcuts For Strikethrough

    What are the best Microsoft Excel keyboard shortcuts for strikethrough?

    The most commonly used keyboard shortcut for adding strikethrough to cells in Excel is Ctrl + 5. There are also other shortcuts you can use, such as Alt + H, then H, and then S for the strikethrough button.

    Can I customize the shortcut keys for adding strikethrough?

    Yes, you can customize the keyboard shortcuts in Excel. Simply go to the File menu, select Options, and then click on Customize Ribbon. From there, you can choose the desired shortcut keys for adding strikethrough in Excel.

    What is the benefit of using keyboard shortcuts for adding strikethrough in Excel?

    Keyboard shortcuts can help you save a lot of time when working with large amounts of data in Excel. By using shortcuts, you can perform repetitive tasks quickly and efficiently.

    Is there a shortcut for removing strikethrough from cells in Excel?

    Yes, you can remove strikethrough from cells in Excel by selecting the desired cells, clicking on the Home tab, and then clicking on the strikethrough button. Alternatively, you can use the keyboard shortcut Ctrl + 5 to toggle between adding and removing strikethrough.

    How do I add strikethrough to a specific word or phrase within a cell?

    To add strikethrough to a specific word or phrase within a cell in Excel, simply highlight the text you want to apply the strikethrough to and then use the Ctrl + 5 keyboard shortcut. The strikethrough will only be applied to the selected text, not the entire cell.

    Is there a way to add strikethrough to cells in Excel automatically?

    Yes, you can add strikethrough to cells in Excel automatically by using conditional formatting. Simply select the cells you want to apply the strikethrough to, go to the Home tab, click on conditional formatting, and then select “New Rule”. From there, choose “Format only cells that contain” and then specify the condition that triggers the strikethrough formatting.