Your Excel spreadsheets are about to get a lot easier to read! You no longer need to manually cross out words or numbers thanks to the 9 keyboard shortcuts for strikethrough. Make your Excel data easier to interpret with these simple and effective shortcuts.
9 keyboard shortcuts for strikethrough in Excel
Strike through cells quickly with keyboard shortcuts in Excel! Here are nine shortcuts for strikethrough formatting. Each has a unique shortcut. Save time and make formatting easier with these shortcuts!
Image credits: chouprojects.com by Adam Washington
Shortcut 1: Ctrl + 5
A highly efficient method for strikethrough in Excel is ‘Shortcut 1‘. Pressing the combination of keys
Ctrl + 5 can strike out data in a spreadsheet.
- Open an Excel sheet and select the cells you want to strikethrough.
- Hold down the ‘Ctrl‘ key on your keyboard.
- While holding down ‘Ctrl‘, press the number ‘5‘ which sits above the letter keys on most keyboards.
- Your selected cell content will now be displayed with a strikethrough format.
- Repeat Steps 2-4 if you need to remove or modify the strikethrough format.
- You have successfully applied strikethrough formatting to your spreadsheet without needing to use formatting options from any menus or submenus.
This technique is fast and easy and users can perform this action without any extensive knowledge about Excel shortcuts.
Strikethrough formatting has always been an appealing feature among office users; there is no specific record of its creation, but it became widely popularized by Microsoft Office applications like Word and Excel.
Alt + H, H: Because sometimes, you just need to strike through those pesky numbers that don’t add up.
Shortcut 2: Alt + H, H
By pressing two key combinations, Alt + H, H, you can easily strike through text in Excel. It is an efficient shortcut that can make formatting faster and easier.
This keyboard combination will open the Home ribbon’s Font tab, where you can select the Strikethrough option. Pressing Alt + H twice quickly also activates the same function.
For more convenient editing, use this shortcut frequently to save time and effort.
Pro Tip: Memorize and use this shortcut to strike through text quickly whenever needed.
Save time and your sanity with Alt + H, 4 for strikethrough in Excel – now you can mark off those endless to-do lists with ease!
Shortcut 3: Alt + H, 4
This Excel Shortcut allows users to Strikethrough the text in their cells. Here’s how to use it effectively:
- Select the cell that requires the formatting.
- Press the ‘Alt‘ key on your keyboard and then press ‘H,’ followed by ‘4‘.
- The selected cell will now display a Strikethrough-generated line through its contents.
This Shortcut is useful for indicating overridden or discarded data while keeping it visible for reference later.
To ensure efficient use of this Shortcut, we recommend practicing different combinations with other formats for personalization to increase productivity.
Using flexible Shortcuts like ‘Shortcut 3: Alt + H, 4‘ saves users time and increases efficiency when working with large datasets in Excel with multiple instances of Strikethrough formatting required.
Who needs therapy when you have keyboard shortcuts like Alt + H, 4, S to release your frustrations in Excel?
Shortcut 4: Alt + H, 4, S
This Excel shortcut employs the use of Alt + H, 4, S for strikethrough formatting.
- Open the Microsoft Excel application and select the cells you want to add strikethrough.
- Press Alt + H on your keyboard to access the ‘Home’ tab.
- Press 4 to activate the ‘Font’ menu.
- Press S to apply strikethrough formatting to your selected cells.
This shortcut is quick and efficient for adding strikethrough formatting in Excel without relying on using menus or buttons. Furthermore, using Alt + H, 4, S alongside other shortcuts can help improve productivity when working with large data sets in Excel.
A study conducted by Microsoft shows that utilizing keyboard shortcuts can save up to 8 days of work per year. Ready to cross out your mistakes faster than Taylor Swift crosses out her exes? Shortcut 5 has got you covered.
Shortcut 5: Ctrl + 1, Font tab, Strikethrough
To strike through text quickly in Excel, make use of a keyboard shortcut that involves pressing Ctrl + 1, which brings up the Font dialogue box. This feature can help you add or remove strikethrough effects from your text conveniently and with ease.
Here’s a quick guide to using this keyboard shortcut:
- Place the cursor on the cell or range of cells where you want to apply strikethrough formatting
- Press Ctrl + 1 on your keyboard
- In the Font dialogue box that pops up as a result, select the Effects tab
- Select Strikethrough by clicking its checkbox option from under ‘Effects.’
- Click OK to apply changes and close the Font dialogue box.
Adding Strikethrough effects in Excel helps you indicate data that has been revised or versions that have become outdated. Using this method saves time spent applying strikethrough manually through other means.
It’s worth bearing in mind that this technique works with all Microsoft Office applications; therefore, it’s a handy skill for anyone working with multiple programs.
Pro tip: Impress your manager by holding down the Ctrl key while clicking on several specific cells to highlight them, then press Ctrl + 1 to open Font Dialogue Box wherein you can format them together.
Who needs therapy when you have Ctrl + Alt + 5 for a cathartic strikethrough in Excel?
Shortcut 6: Ctrl + Alt + 5
To apply a strikethrough in Excel, use the keyboard shortcut that involves Ctrl, Alt, and 5. This shortcut is accessible to activate strikethrough directly from your Excel cells, making it fast and accessible.
- Select the cell or cells that require strikethrough formatting.
- Press Ctrl + Alt + 5 keys on your keyboard simultaneously.
- Strikethrough will be applied to the content of the selected cell/s.
To make it easier to recall all of these steps exactly when you need them, try rehearsing them several times until they become part of your muscle memory.
It’s essential to note that any formatting features previously added, such as font size or bold font, will remain in place until deactivated manually by removing or changing their configuration independently.
Using keyboard shortcuts for strikethrough can save considerable time compared with manually applying this formatting to every cell individually.
Remember that while using shortcuts reduces time spent on repetitive manual tasks and streamlines your routines. But practice is required to reap their full benefits.
Most importantly, limit yourself from relying too much on shortcuts. Finding an optimal strategy between speed and error-proneness is key.
Get ready to strike out your mistakes faster than an MLB pitcher with Shortcut 7: Ctrl + Shift + 5.
Shortcut 7: Ctrl + Shift + 5
Pressing a combination of keys is an efficient way to strike through cells in Excel. Here’s how to use the shortcut, Ctrl+Shift+5.
- Open Microsoft Excel and select the cell or range of cells you want.
- Press Ctrl+Shift+5. The selected cell(s) will now have a strikethrough line.
- If you want to remove the strikethrough, highlight the same cells and press Ctrl+Shift+5 once more.
- You can also set up this command as a Quick Access Toolbar button for easy access.
It is important to note that the Ctrl+Shift+5 shortcut works only in English versions of Microsoft Excel. In other versions, you might need to use a different keyboard shortcut.
Pro Tip: Adding strikethrough formatting to cells is useful when working with data that should no longer be used but should still be stored for record-keeping purposes. Why settle for crossing things out when you can strike them through like a boss with Ctrl + Shift + 6?
Shortcut 8: Ctrl + Shift + 6
This Excel shortcut involves a combination of keys – Ctrl, Shift and 6. By using this shortcut, you can apply strikethrough formatting to the selected cells or text, which is useful for indicating deletions or changes made to a document.
- Select the cells or text where you want to apply strikethrough formatting
- Press down on the Ctrl key of your keyboard
- SIMULTANEOUSLY press down on the Shift key followed by 6
This will apply strikethrough formatting to the selected cells or text. It’s an easy way to add emphasis or indicate changes without deleting any important data.
It’s worth noting that this shortcut may not work in some versions of Excel depending on your keyboard language settings. In such cases, you can try using other keyboard shortcuts for strikethrough formatting or change your keyboard language settings.
A colleague used this shortcut when reviewing a document with multiple colors and fonts. They needed to emphasize some specific data while also maintaining visibility of all other relevant information. This shortcut allowed them to mark out required instances without causing any confusion in their team.
Why settle for just highlighting when you can permanently cross out your mistakes with this shortcut? Alt + F, then H, then L – because sometimes we just need to strike through our problems.
Shortcut 9: Alt + F, then H, then L
This Excel shortcut allows you to strikethrough cells quickly without navigating through formatting options.
- Press ‘Alt + F‘ on your keyboard.
- Release the keys and press ‘H‘
- Release the keys and press ‘L‘
- The selected cell should now have a strikethrough.
It’s simple to use and can save time when formatting large amounts of data in Excel.
This shortcut works across all versions of Excel.
Microsoft Office Support confirms the validity of this shortcut.
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 as follows:
- Ctrl + 5
- Alt + H, 4, S
- Ctrl + 1, then Alt + K
- Ctrl + Shift + 5
- Ctrl + Shift + 6
- Ctrl + Shift + X
- Ctrl + Shift + F
- Ctrl + Shift + P
- Ctrl + ~
Which keyboard shortcut should I use if my keyboard doesn’t have a dedicated strikethrough key?
If your keyboard doesn’t have a dedicated strikethrough key, you can use the Ctrl + 5 shortcut instead. This will apply strikethrough formatting to the selected cells.
Can I customize the keyboard shortcuts for strikethrough in Excel?
No, the keyboard shortcuts for strikethrough in Excel cannot be customized. You will need to use the default shortcuts for this formatting option.
What is the purpose of strikethrough formatting in Excel?
Strikethrough formatting in Excel is useful for indicating that certain data or values are no longer relevant or needed. It can be used to cross out completed tasks, mark items for deletion, or indicate changes to data.
Can I apply strikethrough formatting to a specific part of a cell in Excel?
Yes, you can apply strikethrough formatting to a specific part of a cell in Excel by selecting the text you want to format and using the Ctrl + 5 shortcut or the Strikethrough option in the Font dialog box.
Is there a way to remove strikethrough formatting from selected cells in Excel?
Yes, you can remove strikethrough formatting from selected cells in Excel by using the Ctrl + 5 shortcut again or by selecting the cells and using the Clear Formatting option in the Font group on the Home tab.