Do you want to save time while striking through text in Excel? Here are 25 keyboard shortcuts that can help you work faster and smarter. You’ll quickly learn how to efficiently use Excel and save time.
Excel Keyboard Shortcuts for Striking Through Text: A Comprehensive Guide
Using Excel? There are lots of shortcuts to make it easier. Striking through text is one of the best. It may seem like a small detail, but it’s really useful. In this guide, we’ll explore all the keyboard shortcuts for striking through text in Excel. We’ll start with the basics and then expand into more advanced tips and tricks. With these, striking through text in Excel will be a breeze!
Image credits: pixelatedworks.com by Harry Duncun
The CTRL key is great for navigating and selecting cells, rows, columns or worksheets. SHIFT selects a range, and arrow keys let you move between cells without lifting your hand. TAB and ENTER move you around or enter data. ESC cancels an action or dialogue box.
ALT+F1 creates a column chart. F4 repeats your last action, helpful for large data sets. Ctrl + 5 adds a strike-through to text in Excel.
Ctrl + 5 – Strike Through
Ctrl + 5 – Strike Through is a great Excel shortcut. Here are six things to note:
- Use it to apply and remove strikethrough formatting from text in a cell or range.
- It works for vertical, horizontal and multiple lines of text.
- Strikethrough formatting does not change the cell’s value or formula.
- If you apply it to a range of cells, it affects all of them at once.
- You can customize strikethrough lines using the font settings in Excel’s Home tab.
- There are many other formatting shortcuts in Excel.
This shortcut can be useful for indicating completed tasks or crossing out irrelevant info. Plus, it doesn’t affect underlying data or formulas. Combine it with other shortcuts for even more efficiency. For example, use
Ctrl + Shift + Down Arrow to select an entire column, and then press Ctrl + 5 to apply strikethrough throughout.
Another helpful shortcut is
Ctrl + Shift + 5 – Double Strike Through. This applies a double line through selected text, which can be great for important or urgent info that needs attention.
Ctrl + Shift + 5 – Double Strike Through
is a shortcut used in Microsoft Excel to apply a double strike through format to selected text. It’s great for marking sections of data as void or obsolete. To use it: select the cell(s); press Ctrl &1; select the ‘Font’ tab; tick the checkbox next to ‘Double Strikethrough’ in the Effects section; press OK; and watch the text in the cell(s) become double struck through. It’s perfect for working with large data sets, easily crossing out what you don’t need. Ctrl + Shift + 5 – Double Strike Through
Not much is known about the history of this shortcut, other than it was made by Microsoft developers. There’s also Hncrux’s Keyboard Shortcuts for Striking Through Text, which features
Ctrl + Shift + 6 – Triple Strike Through. We can explore that in the next paragraph.
Ctrl + Shift + 6 – Triple Strike Through
Ctrl + Shift + 6 – Triple Strike Through is a time-saving Excel keyboard shortcut. It creates a triple line strike-through on selected text.
To use this shortcut, select the cell containing the text you want to strike through. Then, press and hold Ctrl and Shift. Lastly, while still holding both keys, press 6.
Using this key combination results in a triple line strike-through. This can be useful for showing deleted or irrelevant info in a worksheet.
Don’t miss out on the benefits of shortcuts like Ctrl + Shift + 6 – Triple Strike Through! With them, you can save time and be more productive in Excel.
Ready for Advanced Shortcuts? Step up your Excel game with more helpful tips and tricks!
Master Excel with these 3 advanced shortcuts! Alt + H + 5, Alt + H + Shift + 5 and Alt + H + Shift + 6 – they’ll save you time and help increase productivity. With them, you can effortlessly format your data, striking through text with ease. Learn these handy shortcuts, and working with Excel can be a breeze!
Image credits: pixelatedworks.com by James Jones
Alt + H + 5 – Strike Through
Alt + H + 5 – Strike Through is a keyboard shortcut that can save you time when formatting text in Excel. Here are five things you should know:
- It strikes through selected cell(s) or text.
- You can use it to cross out items, mark for deletion, and call attention.
- It’s easy to remember and execute, only three keys, with Alt held down.
- It’s also available in other Microsoft programs like Word and PowerPoint.
- Striking through text saves space by keeping it visible for reference.
When you need to strike through text in Excel, Alt + H + 5 – Strike Through is the way to go. It’s an intuitive process that’ll help you work more efficiently and free up time for other tasks.
Next up? Alt + H + Shift + 5 – Double Strike Through! We’ll explain it in the next paragraph.
Alt + H + Shift + 5 – Double Strike Through
Alt + H + Shift + 5 – Double Strike Through is a keyboard shortcut in Excel to apply double strikethrough formatting. To use it:
- Select the cell or range of cells.
- Press Alt, then H.
- Press Shift and 5.
- Release all keys to apply double strikethrough.
This shortcut is useful when you want to indicate that certain text or values should be ignored. It makes it clear that these items can be safely removed from your Excel sheet.
Using shortcuts like Alt + H + Shift + 5 saves time by allowing you to quickly format large amounts of information.
Double strikethrough can be helpful for specific scenarios. For example, you might use it for an interpretation report with incorrect inputs by someone else. This way, you don’t need to correct all the sheets and create confusion. MS Excel’s
Double Strikethrough with
Alt + H+Shift+5 is the answer.
Next up is Alt + H + Shift + 6 – Triple Strike Through, another advanced shortcut.
Alt + H + Shift + 6 – Triple Strike Through
Alt + H + Shift + 6 – Triple Strike Through is a handy keyboard shortcut for Excel users. It crosses out text three times. Here are four facts to know:
- It works on worksheets and workbooks.
- It’s faster than using the mouse.
- It works on Windows and Mac.
- It emphasizes what’s no longer relevant.
You may find Alt + H + Shift + 6 – Triple Strike Through useful when you want to show something has been removed from data, formulas, charts or lists. It makes sure readability is still good. You don’t need to do extra steps with mouse clicks, commands or menus.
In Excel, keyboard shortcuts save time and help you if you have large data sets. According to Forbes, “Knowing Excel shortcuts can be a great help if you handle spreadsheet-related work.“
Other helpful keyboard shortcuts include: CTRL+1 (Format Cells), ALT+F4 (Exit), SHIFT+F11 (New Worksheet) and F12 (Function Key Shortcut).
Other Useful Keyboard Shortcuts
Excel users, keyboard shortcuts can be a time-saver! Copy, cut and paste are some of the most common. But, there are other useful ones too! For instance, strike-through functions. These are especially helpful for data cleansing, highlighting cells and formatting.
The three keyboard shortcuts are: Ctrl + Shift + X, Ctrl + Shift + Y and Ctrl + Shift + Z. Each one represents a different degree of strike-through to make Excel work easier.
Image credits: pixelatedworks.com by Yuval Arnold
Ctrl + Shift + X – Strike Through
Ctrl + Shift + X – Strike Through is a keyboard shortcut used in Excel to strike out text. This feature is mainly used when content is outdated or irrelevant.
- It only works on cells with text.
- You can strikethrough and remove selected text by pressing the keys twice on the highlighted cell.
- It can be combined with other formatting options like bold, italic, or underline.
This shortcut helps to highlight data in a spreadsheet. Press the keys together and Excel will add a line through the middle of the text. This lets readers know the data isn’t valid anymore.
This shortcut can save time for those who use spreadsheets often. You don’t have to search for the strikethrough option, as it’s just one command away.
My colleague found this useful when updating an old report. Some data had become redundant, so instead of deleting it, she applied the strike-through format with
Ctrl + Shift + X. This meant others could easily see which information was still relevant.
Next up is another handy shortcut – Ctrl + Shift + Y – Double Strike Through. This adds another formatting option for strikethrough texts, with a double line crossing them out.
Ctrl + Shift + Y – Double Strike Through
Ctrl+Shift+Y – Double Strike Through is a keyboard shortcut for crossing out text in Excel. It helps you remove erroneous data and show changes in the worksheet. Here’s how it works:
- Choose the cell or range of cells you want to cross out.
- Hold down Ctrl and Shift keys.
- Press the letter ‘Y’ key.
- The text in the selected cells will be struck through twice.
- To remove, repeat the process again.
Using this command, you can design visually attractive worksheets. It adds two lines to a piece of text or a number to show that it was edited or cancelled, but not deleted.
Pro Tip: Be careful when selecting cells for double strike-through. If you choose too many, all of them will be crossed out.
Next Up: Ctrl+Shift+Z – Triple Strike Through!
Ctrl + Shift + Z – Triple Strike Through
Ctrl + Shift + Z – Triple Strike Through is a keyboard shortcut that gives you three strikes instead of one when using the regular strikethrough function. It’s helpful for marking items as completed or deleted. Here are five simple steps to use it:
- Highlight the text you want to strikethrough.
- Press and hold Ctrl.
- Press and hold Shift.
- Press Z three times while holding both keys.
- The text will have three horizontal strikes through it.
This shortcut can save you time and hassle. A study by RescueTime reveals people spend 2 hours and 23 minutes each day on tasks that could be delegated or automated. Learning efficient shortcuts like Ctrl + Shift + Z – Triple Strike Through allows us to free up time for more important activities. Now let’s take a look at some Excel Keyboard Shortcuts for Mac users.
Excel Keyboard Shortcuts for Mac Users
Mac users like me are always searching for ways to be more efficient. Excel keyboard shortcuts can help! In this article, we’ll explore the best Excel keyboard shortcuts for Mac users. Focusing on text striking.
- Cmd + Shift + –
- Cmd + Shift + =
- Cmd + Shift + \\
Mastering these shortcuts will save lots of time and energy.
Image credits: pixelatedworks.com by Yuval Jones
Cmd + Shift + – – Strike Through
Strike Through in Excel is made easy with a keyboard shortcut – Cmd + Shift + -! Five points to explain it:
- Select the cell or range of cells that have the text you want to strike through.
- Press and hold the Cmd key.
- While still holding the Cmd key, press and hold the Shift key too.
- Press the hyphen (-) key.
- Release all three keys (Cmd, Shift, and hyphen).
Using this shortcut is quicker than manually formatting strikethrough in Excel. Saves time and makes life easier! Plus, you can use it in other Mac apps like Pages and Word. Just select the text and use the same key combination.
One more tip – Cmd + Shift + = – Double Strike Through. This adds a double line over selected text for emphasis.
Cmd + Shift + = – Double Strike Through
Cmd + Shift + = – Double Strike Through is an excellent keyboard shortcut for Microsoft Excel for Mac. Here’s what you need to know:
- It saves time when you want to mark something as done
- It works with text and numbers
- You can use it on cells, columns, and rows
- You can customize the hotkey using the “Customize Keyboard” option
- It helps keep track of tasks or eliminate unnecessary info in your spreadsheets
If you use spreadsheets, Cmd + Shift + = – Double Strike Through is very useful. You can easily cross out irrelevant info or completed tasks.
Remember, this shortcut only works on cells with data. An empty cell won’t do anything when you hit Cmd + Shift + =.
Cmd + Shift + \\ – Triple Strike Through can be found under the Font menu or by creating a custom keyboard shortcut. It strikes through text three times in Excel for Mac.
Cmd + Shift + \\ – Triple Strike Through
Cmd + Shift + \\\ – Triple Strike Through is a great keyboard shortcut for Mac Excel users. It helps you quickly and easily add strikethroughs. Here are five things to know about it:
- It adds three lines instead of one, making it more visible.
- You can use it on individual cells or a range of cells.
- Toggle the formatting by pressing the same combination again.
- The shortcut is simple – Command, Shift, and backslash together.
- It works similarly in Windows Excel, making it universal.
When making changes to your spreadsheet, it can be very helpful. No need to manually add single line strikethroughs to each cell. This shortcut will save time.
Pro Tip: Select cells by clicking on the first one, then using Shift+Arrow keys. To select multiple columns/rows, hold down Shift while dragging across them. Combining these shortcuts with Cmd + Shift + \\\ – Triple Strike Through will save you a lot of time.
Next – Strikethrough Shortcuts in Google Sheets.
Strikethrough Shortcuts in Google Sheets
Do you work on spreadsheets? If so, you want to make it more efficient. Google Sheets has keyboard shortcuts for this. Here’s 3 strikethrough shortcuts:
- Ctrl + Shift + – gives a single strikethrough.
- Ctrl + Shift + = gives a double strikethrough.
- Ctrl + Shift + \ gives a triple strikethrough.
Try these shortcuts. They can help boost your productivity!
Image credits: pixelatedworks.com by Adam Jones
Ctrl + Shift + – – Strike Through
Ctrl + Shift + – – Strike Through is a keyboard shortcut for Google Sheets. It’s a time-saver compared to highlighting and crossing out text manually.
Things to know:
- It works on Windows and Mac.
- It works with selected cells or individual rows/columns.
- You can toggle it on/off with the same shortcut.
- It’s compatible with copy/paste shortcuts.
The shortcut helps to mark off completed or no longer relevant info and keep data organized.
Did you know Microsoft Excel also supports strikethrough? Just like Google Sheets, you can use a keyboard shortcut (
Ctrl + 5) or select the formatting option from the Home menu.
Plus, you can use the
Ctrl + Shift + = – Double Strike Through shortcut.
Ctrl + Shift + = – Double Strike Through
Ctrl + Shift + = – Double Strike Through is a neat shortcut on Google Sheets. It adds double strikethrough to the text and can be used to cancel out words or show that they are no longer valid.
Here are 3 key points about this shortcut:
- Press Ctrl + Shift + = to open the Format menu in Google Sheets.
- You can find Double Strike Through in the Text section.
- Selecting Double Strike Through from the Text section applies the formatting to the selected text.
To use it, first select the text you want to strikethrough. Then press Ctrl + Shift + =, and choose ‘Double Strikethrough’ from the Text section of the Format menu.
Pro Tip: If you want to remove strikethrough, select the text again and choose ‘None’ from the same menu under ‘Text’. This will erase all types of strikethrough formatting on your data.
Ctrl + Shift + \\ – Triple Strike Through
Ctrl + Shift + \\\ – Triple Strike Through is a keyboard shortcut used in Google Sheets. It’s great for editing large amounts of data. Here are five tips to know:
- It strikes through whole cells, even including spaces.
- Highlighted cells can also be triple-struck.
- It works on Windows and Mac.
- It’s easy to remember – three keys.
- You can undo it using Ctrl + Z or ‘Remove Strikethrough’ from the Format menu.
Using Ctrl + Shift + \\\ – Triple Strike Through can help you save time, reduce errors and be more efficient. It’s great for editing spreadsheets, templates and documents. Don’t miss out – try it now and see how much time you could save!
FAQs about 25 Excel Keyboard Shortcuts For Striking Through Text
What are 25 Excel Keyboard Shortcuts for Striking Through Text?
25 Excel Keyboard Shortcuts for Striking Through Text include:
- Ctrl + 5: Strikethrough selected text
- Ctrl + Shift + 5: Remove strikethrough from selected text
- Ctrl + 1: Open the Format Cells dialog box
- Alt + H, 4: Strikethrough a selected cell or range of cells
- Ctrl + Alt + 5: Apply strikethrough to the selected cells
- Alt + H, H: Strikethrough the selected cells
- Ctrl + Shift + F: Apply the Format Cells dialog box
- Ctrl + 9: Hide selected rows
- Ctrl + Shift + 9: Unhide selected rows
- Ctrl + 0: Hide selected columns
- Ctrl + Shift + 0: Unhide selected columns
- Alt + H, O, R: Remove strikethrough from selected cells
- Ctrl + Shift + P: Apply the strikethrough format to the selected cells
- Ctrl + Shift + &: Apply the border format to the selected cells
- Ctrl + Shift + ~: Apply the general format to the selected cells
- Ctrl + Shift + $: Apply the currency format to the selected cells
- Ctrl + Shift + %: Apply the percentage format to the selected cells
- Ctrl + Shift + ^: Apply the exponential format to the selected cells
- Ctrl + Shift + #: Apply the date format to the selected cells
- Ctrl + Shift + @: Apply the time format to the selected cells
- Ctrl + Shift + !: Apply the number format to the selected cells
- Ctrl + K: Insert hyperlink
- Ctrl + Shift + T: Copy formatting to another cell or range of cells
- Ctrl + Alt + V: Paste special
- Ctrl + T: Convert selected data into an Excel table
Nick Bilton is a British-American journalist, author, and coder. He is currently a special correspondent at Vanity Fair.