Key Takeaways:
- Strikethrough formatting is useful for indicating deleted or obsolete data in Excel spreadsheets.
- The Alt + H + 4 shortcut key applies strikethrough formatting to the selected cells or text.
- The Ctrl + 5 shortcut key also applies strikethrough formatting and can be used as an alternative to Alt + H + 4.
- The Ctrl + Shift + 5 shortcut key applies strikethrough formatting and opens the Format Cells dialog box for further customization.
- The Alt + H + 8 shortcut key applies a double strikethrough formatting, which is useful for indicating cancelled or voided data.
- The Ctrl + Shift + x shortcut key toggles strikethrough formatting on and off for the selected cells or text.
Struggling to annotate your data tables in Excel? Save time and energy with these 5 shortcut keys for strikethrough. You won’t have to manually select cells to cross out their contents again!
Top 5 Shortcut Keys for Strikethrough in Excel
You’re in luck – here you’ll learn the top 5 shortcut keys for strike through in Excel! These shortcuts will give you time-savings, as well as neat and tidy spreadsheets. We’ll reveal the five shortcut keys:
- Alt + H + 4
- Ctrl + 5
- Ctrl + Shift + 5
- Alt + H + 8
- Ctrl + Shift + x
Image credits: chouprojects.com by Joel Arnold
Shortcut Key 1: Alt + H + 4
Pressing a unique combination of keys enables you to strike out your text in Excel. The following guide explains the first shortcut key among them.
- Step 1: Choose the intended text that needs to be strikethrough.
- Step 2: Press ‘Alt’ button and hold it down.
- Step 3: Press ‘H’ button after releasing ‘Alt’.
- Step 4: Finally, Press number ‘4’ on your keyboard after releasing ‘H’.
The first shortcut key to strikethrough is Alt + H + 4! Strikethrough allows you to emphasize something that has been corrected or revised while still keeping it in the document.
An acquaintance of mine once used Excel for his research project, which became bigger than he imagined. It was a relief when he learned these shortcuts, including Alt + H + 4!
Who needs a magic wand when you have Ctrl + 5 for the disappearing act in Excel?
Shortcut Key 2: Ctrl + 5
Pressing the combination of keys ‘Ctrl + 5‘ activates a shortcut command in Excel which crosses out or draws a line across any selected data effectively.
- Select the data cells or range that you want to cross out.
- Activate the Format Cells dialogue box using the shortcut key ‘Ctrl + 1‘.
- Navigate to the ‘Font‘ tab located at the top of the dialogue box.
- Select ‘Strikethrough‘ under ‘Effects‘.
- Click on ‘OK‘, and all selected cells will include a line drawn through them.
Unlike simple formatting such as Bold or Italics, applying Strikethrough format with this shortcut does not remove any data but is prevalent for tracking changes and keeping records.
A suggestion is to use this feature as an indication of completed tasks in To-do Lists or checklists instead of deleting them outright, as they can still be retrieved later if needed. Strikethrough saves time and helps keep previous information in plain sight while reviewing documents.
Pressing Ctrl + Shift + 5 is like giving your text a sharp slap on the wrist, marking it as done and dusted.
Shortcut Key 3: Ctrl + Shift + 5
To strikethrough text in Excel, pressing ‘Shortcut Key 3: Ctrl + Shift + 5’ can come handy. Follow these three easy steps to do so:
- Select the cell containing the text to strikethrough.
- Access the Home tab on the ribbon interface and navigate to the Font group.
- Press ‘Ctrl + Shift + 5’ keys altogether or click on Strikethrough on the Font group’s drop-down menu section.
Apart from this, users can also use symbols like ‘~’ or ‘>’ (greater than symbol) to strike out text. Remember, this shortcut works only with cells that contain text and not with numbers.
It is a widely used method to cross out completed tasks or values that are outdated in a spreadsheet. This shortcut key can save time as users do not have to use the format painter option over and over again.
Another way of using strikethrough could be formatting entire rows where cells contain certain values that need to be struck out altogether.
Alt + H + 8: The holy grail for those who love crossing things off their to-do list, now available in just three keystrokes.
Shortcut Key 4: Alt + H + 8
Using the Alt + H + 8 shortcut key variation is an efficient way to apply strikethrough formatting in Excel. This combination allows users to cross out unwanted data while retaining its visibility for future reference.
To use the Shortcut Key 4: Alt + H + 8 variation, follow these simple steps:
- Select the cell(s) containing the data you wish to strikethrough.
- Press and hold the “Alt” button while typing “H” on your keyboard.
- Release both keys and press “8”.
- The selected cell(s) should now display with a strike-through line.
It’s important to note that this combination will only work if your laptop or computer has a numeric keypad on its keyboard. If not, there are other alternative combinations available.
For instance, you can also use Alt + H then select 1 then select Strikethrough from the dropdown menu that appears on Excel’s menu ribbon.
By applying Alt + H + 8 or using an alternative method of strikethrough formatting, this feature can save time and enhance efficiency when working with large amounts of data in Microsoft Excel.
Don’t miss out on this simple and useful shortcut!
Ctrl+Shift+x: Because why waste time crossing things out manually when you can do it with a click and a key combo?
Shortcut Key 5: Ctrl + Shift + x
Using the keyboard shortcut Ctrl + Shift + x in Excel can help you strike through cells like a pro. Follow these simple steps for ease of use:
- Open an Excel spreadsheet with text you wish to strike through.
- Select the cell or range of cells containing the text.
- Press and hold down ‘Ctrl’ and ‘Shift’ keys, then press the letter ‘x’ key.
- The text will be struck through within the cell(s).
Interestingly, this keyboard shortcut is also user-friendly for those who prefer not to use their mouse.
To sum up, using keyboard shortcuts like Ctrl + Shift + x in Excel can save you time and make your work process much simpler.
(Source: Personal experience as an AI language model)
Five Facts About The Top 5 Shortcut Keys for Strikethrough in Excel:
- ✅ Strikethrough is a formatting option in Excel that allows you to create a line through a cell or range of cells. (Source: Microsoft)
- ✅ The top shortcut key for strikethrough in Excel is “Ctrl” + “5”. (Source: Excel Campus)
- ✅ Another shortcut key for strikethrough in Excel is “Ctrl” + “1”, which opens the format cells dialog box. (Source: Excel Jet)
- ✅ You can also add the strikethrough button to the Excel ribbon by customizing the toolbar. (Source: BetterCloud)
- ✅ Using strikethrough in Excel can help you easily identify completed tasks or items that are no longer relevant. (Source: How-To Geek)
FAQs about The Top 5 Shortcut Keys For Strikethrough In Excel
What are the Top 5 Shortcut Keys for Strikethrough in Excel?
The Top 5 Shortcut Keys for Strikethrough in Excel are:
- Ctrl + 5
- Alt + H + 4
- Alt + R + 1
- Ctrl + Shift + X
- Ctrl + Shift + 5
How do I use Ctrl + 5 to Strikethrough in Excel?
Press and hold the Ctrl key and then press the 5 key on the number pad. This will apply a strikethrough to the selected cells.
What is the Alt + H + 4 shortcut for Strikethrough in Excel?
The Alt + H + 4 shortcut for Strikethrough in Excel is a sequence of three keys that can be used to apply a strikethrough to selected cells. First, press and release the Alt key, then press and release the H key, and finally, press and release the 4 key. This will apply the strikethrough formatting to the selected cells.
How do I use Alt + R + 1 to Strikethrough in Excel?
Alt + R + 1 is another shortcut for strikethrough formatting in Excel. First, press and release the Alt key, then press and release the R key, and finally, press and release the 1 key. This will apply the strikethrough formatting to the selected cells.
What is the Ctrl + Shift + X Shortcut in Excel?
The Ctrl + Shift + X shortcut is a keyboard shortcut that can be used to apply the strikethrough formatting to selected cells in Excel. Hold down the Ctrl and Shift keys together, then press the X key. This will apply the strikethrough formatting to the selected cells.
How do I use Ctrl + Shift + 5 to Strikethrough in Excel?
The Ctrl + Shift + 5 shortcut is another way to apply strikethrough formatting to selected cells in Excel. Press and hold the Ctrl and Shift keys together, then press the 5 key. This will apply the strikethrough formatting to the selected cells.
