- Strikethrough is a useful formatting tool in Excel, and can add value to spreadsheets by helping users to flag completed tasks or crossed-out data. Shortcut Key #1 is the easiest way to access and apply strikethrough to text and cells.
- The other keyboard shortcut keys described in this article – Clear Strikethrough, Increase/Decrease Font Size, Bold Font, Italicize Font, Underline Font, Copy/Paste Formatting, Insert Hyperlink, Wrap Text, Merge Cells, Autofill, Format Painter, Find and Replace – are also essential productivity hacks for Excel users and can help to speed up data entry, formatting, and analysis tasks.
- By learning and practicing these shortcut keys for strikethrough and other Excel formatting tools, users can improve their efficiency and productivity, simplify complex spreadsheet tasks, and enhance their overall Excel skill set.
Do you feel overwhelmed and time-strapped when working with long spreadsheets in Excel? This article will provide you with the 15 shortcut keys that can help you easily apply strikethrough formatting to cells!
Top 15 Excel Shortcut Keys for Strikethrough
Master your Excel skills! Learn the top 15 shortcut keys for strikethrough. Quickly and efficiently format your spreadsheet. Accuracy and presentation guaranteed! Shortcuts include:
- clear strikethrough
- font size
- copying/pasting formatting
- text wrapping
- merging cells
- format painter
- find-and-replace functions
Image credits: chouprojects.com by Joel Duncun
Shortcut Key #1 – Strikethrough
When you want to strikethrough in Excel without using the formatting toolbar, you can use a keyboard shortcut. To use Shortcut Key #1 – Strikethrough, follow these 4 steps:
- Select the cell(s) where you want to apply strikethrough.
- Press the ‘Ctrl’ and ‘1’ keys together. This will open the ‘Format Cells’ dialog box.
- In the ‘Format Cells’ dialog box, navigate to the ‘Font’ tab.
- Check the box next to ‘Strikethrough’ under Effects and click OK.
This simple key combination can save time formatting cells in Excel.
In addition, strikethrough is useful when showcasing deleted or corrected information without removing it from view completely.
Pro Tip: You can also apply strikethrough to text in Word using this same keyboard shortcut. Clearing your mistakes has never been easier with this shortcut, unless you’re trying to erase your ex from your memory.
Shortcut Key #2 – Clear Strikethrough
To remove the strikethrough from Excel cells, follow the second shortcut key. This method is straightforward and saves time in removing the unwanted effect from your data.
- Select the cell(s) that have strikethrough applied to them.
- Press the “Ctrl” + “1” keys to open the Format Cells dialog box.
- Click on the “Font” tab in the Format Cells dialog box.
- Uncheck the “Strikethrough” checkbox under “Effects.”
- Click on “OK” to apply changes to your selected cells.
This simple 6-step guide will help you remove strikethroughs quickly without having to manually remove it one-by-one.
A small tip for Excel users: By using this shortcut, not only can you remove strikethroughs from a cell, but you can also undo other effects like subscripting and superscripting.
Excel removes only one type of effect at a time. For example, if your cell has strike-through, bold and underline effects applied simultaneously, clearing strike-through first will erase it and leave the other two intact.
It is said that removing strike-through was introduced into Excel because people were mistakingly doing so via typing # or / characters next to their value. Hence this feature came as a rescue in removing unwanted format changes from their values.
Why settle for a regular font size when you can go big or go home with shortcut key #3?
Shortcut Key #3 – Increase Font Size
To boost productivity, here’s a valuable tip for manipulating text in Excel. Increase Font size in Excel is a crucial feature. Knowing how to use the increase font shortcut key can save time while using the application.
Here’s a 3-Step Guide on how to Increase Font Size by using Shortcut Key #3:
- Select the cell or range of cells which you want to change.
- Press “Ctrl” and “+”. It will quickly increase the font size by one point. For Windows users: Press “Ctrl + Shift + >” to enlarge the cell contents gradually. Reverse this on your keyboard with “Ctrl + Shift + <” shortcut key stroke.
- If you want to go back, just press “Ctrl” and “-“.
By using this simple shortcut key, you can reduce data entry time that corresponds to transforming data.
Users must know about the other adjustment options they have with this command before starting their work.
Did you know some third-party software has even boasted enhanced accuracy over Microsoft’s native controls? By analyzing user behaviour and granting features missing from MS Excel, companies like Adatum Automation in India have revolutionized the way we do spreadsheets.
Make your spreadsheets look like they’re whispering with Excel’s Decrease Font Size shortcut – because sometimes subtlety is key.
Shortcut Key #4 – Decrease Font Size
Decreasing font size in Excel is crucial when optimizing formatting and readability. Here’s a short guide on how to easily decrease the font size using Excel shortcut keys:
- First, select the cells you want to change the font size.
- Press the “Ctrl” key and the “Shift” key simultaneously.
- While continuing to hold down both keys, press the “<" key to decrease the font size of the selected cells.
- Release all three keys and your text should have decreased in size.
- To undo this action, repeat steps 1-3 but press the “>” key instead.
It’s important to remember that decreasing font size too much can make your text difficult to read. Use this function sparingly for maximum impact.
Quick tip: Hold down the Ctrl key while scrolling with your mouse’s scroll wheel to quickly adjust font size.
Applying various formats in a spreadsheet efficiently is a time-saving skill that can enable effective communication of vital data needed for decision-making.
As Microsoft Excel continues its legacy, learning new shortcuts serves as an excellent way for users to improve their work efficiency further.
One day, John was working on a finance sheet containing countless numbers and percentage calculations when he stumbled upon Ctrl + Shift + < shortcut key. The ease it brings just amazed him, which made an arduous task a lot quicker than estimated!
Boldly go where no formatting has gone before with Shortcut Key #5 – Bold Font.
Shortcut Key #5 – Bold Font
The impressive ‘Shortcut Key #5’ allows you to apply bold formatting with ease. Here’s a concise guide detailing how:
- Select the text that requires bold formatting.
- Press ‘CTRL + B’ to enable bold font.
- If you want to remove the bold format, select the text and press ‘CTRL + B’ again.
- Alternatively, if you only need to emphasize certain parts of the selected text, use the ‘CTRL+B,T’ shortcut instead.
For those looking for more information, it is worth noting that this shortcut key also works in ‘Google Sheets,’ allowing users to save more time during spreadsheet editing.
Pro Tip: Using ‘Shortcut Key #5 – Bold Font’ enhances readability and emphasizes important data in your spreadsheets.
Get ready to slant your way to success with Shortcut Key #6 – Italicize Font.
Shortcut Key #6 – Italicize Font
Italicize text with ease by utilizing shortcut key #6. Follow these five easy steps:
- Highlight the text you want to italicize.
- Press and hold down the “Ctrl” key.
- Press the letter “I.”
- Release both keys simultaneously.
- Your text will now be italicized.
In addition, it is also possible to select multiple cells and format them all at once using this shortcut.
To further enhance your document’s appearance, you can experiment with different fonts and sizes. Use bold or underline formatting selectively to make specific words pop out. However, overusing them could hinder readability.
For even more customization options, use Excel’s Format Cells feature (shortcut key: Ctrl +1) which gives access to a plethora of font styles, colors, and effects.
By mastering these tricks, you can create standout spreadsheets without sacrificing too much time formatting!
Time to underline the fact that this Excel shortcut key is a game-changer.
Shortcut Key #7 – Underline Font
To underline a font in Excel, use a specific shortcut key that allows you to do it quickly and easily. With this tool, you can make your text stand out and emphasize important points.
Here is a 3-Step Guide on how to use the Underline Font Shortcut Key in Excel:
- 1. Select the cells or data where you want to apply the underline font.
- Next, press the “Ctrl + U” keys at the same time to activate the shortcut command.
- Finally, you will see that the font has been underlined once executed successfully.
It’s worth noting that this shortcut key is an efficient way of achieving an Underline Font effect rather than going through a series of button clicks. It saves time when working with large datasets while also increasing productivity.
When applying this feature, bear in mind that it works best for emphasizing short phrases rather than long sentences. This way, it will be easier to read and understand.
Interestingly, Strikethrough and Underline shortcuts are often confused because they use similar keystrokes (Ctrl + 5 or Ctrl + U). So it’s crucial to take note of which one you’re using before executing any commands.
Copying formatting has never been easier, unless you’re trying to copy someone’s fashion sense.
Shortcut Key #8 – Copy Formatting
Copying formatting can save time when working in Excel. Here’s how to use the related shortcut key:
- Select the cell with formatting you want to copy.
- Press “Ctrl” + “C” at the same time to copy.
- Select the cell or range of cells where you want to apply the formatting.
- Go to “Home” tab and click on “Paste” dropdown menu located in Clipboard group.
- Select “Formats” from the options, or press “Ctrl” + “Alt” + “V“, then hit “F“. This applies only formatting but not that data that was copied.
It’s crucial to ensure all copied information is relevant and desired as it only applies the copied data outside of cells’ content.
Copying format is an effective way of making spreadsheets look professional.
Did you know? The first version of Microsoft Excel was released for Macintosh systems in September 1985.
Copying and pasting never felt so satisfying – Shortcut Key #9 lets you paste that desired formatting with ease.
Shortcut Key #9 – Paste Formatting
To paste formatting in Excel, use the appropriate shortcut key. Here is a guide on how to do it:
- Select the cell that contains the formatting you want to copy.
- Press Ctrl+C to copy the cell’s content.
- Select the cell where you want to apply the formatting.
- Press Ctrl+Alt+V and then F to select the Formatting option.
It is worth noting that this shortcut can also be accessed by right-clicking on a selected cell and choosing Paste Special > Formatting.
Notably, using Paste Formatting can save time and ensure consistency across multiple cells or worksheets.
A coworker was once able to complete their report much faster than usual simply because they learned about these helpful Excel shortcuts – including Paste Formatting. They were able to quickly format all of their data in one go rather than manually doing so for each individual row or column.
I guess you could say inserting a hyperlink in Excel is like giving your spreadsheet a passport to the internet.
Shortcut Key #10 – Insert Hyperlink
Insert relevant hyperlink easily using this top-notch shortcut key.
- Select the cell or text in which you want to insert a hyperlink.
- Press Ctrl + K on your keyboard, and the Insert Hyperlink dialog box will appear.
- In the Address box, paste or type the URL or file path of the hyperlink to be inserted.
- Customize your hyperlink under Text to Display section or leave it as it is for default display text with rendering hyperlinks in blue underline text format.
- Click OK or press Enter, and your hyperlink is now added to your selected text or cell!
Note: For Mac Users, use Command + K.
Adding Hyperlinks comes handy while creating reports and an easy-to-use way to redirect users to further important details. Pro Tip: Use descriptive links rather than raw URLs – they are visually appealing and help in creating a user-friendly interface in documents.
Wrap it up like a burrito with Shortcut Key #11 – Wrap Text in Excel.
Shortcut Key #11 – Wrap Text
Wrapping text in Excel allows you to display all the text in a cell without it spilling over into adjacent cells. Using this feature can help make your spreadsheet more organized and easier to read.
Here’s a 6-step guide on how to use Shortcut Key #11 – Wrap Text:
- Select the cell or range of cells containing the text you want to wrap.
- Press the ‘Ctrl’ key and ‘1’ key simultaneously or right-click and select ‘Format Cells…’ from the menu that appears.
- In the Format Cells dialog box, click on the ‘Alignment’ tab.
- Under Text control, check the ‘Wrap text’ checkbox.
- Click on OK or press Enter to see your changes take effect.
It’s important to note that wrapping text may cause cells to become larger, which can impact overall formatting of your spreadsheet. It’s best practice to adjust column width accordingly after using this feature.
Did you know? Before automatic cell wrapping became available in Excel, users had to add manual line breaks within a cell using the Alt + Enter shortcut.
Merge cells: because who needs a clean and organized spreadsheet anyways?
Shortcut Key #12 – Merge Cells
Merge cells efficiently with this Excel shortcut key.
- Select the cells you want to merge
- Press Alt and H (Home Tab) on your keyboard
- Press M for “Merge & Center” or I for “Merge Across” or down arrow for more options
- Press Enter on your keyboard
- Your selected cells will now be merged based on the option you selected
This feature is useful when you wish to combine multiple cells into one and improve the appearance of your data.
Remember to use this shortcut key method to merge cells instead of manually merging, as it saves time and minimizes errors.
Ensure you are a master of these Excel shortcut keys as they help you navigate quickly through large amounts of data accurately.
Autofill like a boss and leave your Excel sheet looking spick and span.
Shortcut Key #13 – Autofill
The Excel Shortcut Key that automates the process of filling data is vital and saves time. The “Fill” option or “Shortcut Key #13 – Autofill” allows users to copy and paste content without manually typing it.
Here’s a 5-step guide to using the “Shortcut Key #13 – Autofill”:
- Select the cell with data you want to copy.
- Place your cursor on the bottom right corner of the cell so that it turns into a black cross.
- Click and hold down your mouse button, drag over the cells you wish to fill.
- Once you’ve selected all necessary cells, release your mouse button
- The data from the initial cell will be automatically filled into every other cell in sequence.
In addition, Excel predicts patterns enabling unmatched sequences like serial numbers. The series can include months, days, auto increments, etc.
Pro Tip: Users may also double click on the black cross at the bottom right corner to autofill as many cells necessary swiftly.
Get your formatting brush ready, because Shortcut Key #14 – the Format Painter – is here to save your styling woes.
Shortcut Key #14 – Format Painter
The Strikethrough-Shortcut Key #14 is an efficient way to format text and enhance readability. With just a few clicks, this feature helps to cross out content and emphasize relevant information. Here’s how you can use it:
- Select the cell, row or column that contains the text you want to format.
- Click on the ‘Format Painter’ button located on the Home tab of the ribbon.
- Click on the cell, row or column where you want to apply strikethrough formatting.
Using the Strikethrough-Shortcut Key #14 not only highlights critical details but also saves time spent on manual editing. Additionally, it enables users to maintain uniformity across documents easily.
Lastly, using Shortcut Keys regularly can significantly boost productivity levels. Users must try different combinations and practice frequently for maximum proficiency.
Replace the need for tedious manual editing with just a few clicks – Shortcut Key #15 has got your back.
Shortcut Key #15 – Find and Replace
The 15th Excel shortcut key involves locating and swapping specific information effectively- specifically the ‘Find and Replace’ function.
Here’s a quick 5-step guide to using the ‘Find and Replace’ shortcut successfully:
- Open your spreadsheet, press Ctrl + F.
- Type in the content you wish to replace and press ‘Enter’ or click on ‘Find Next.’
- Once found, select ‘Replace’ for the ability to replace it with any alternate information desired.
- If there are multiple cells with the same data, hit ‘Replace All’.
- Lastly, click on OK both times to finalize changes.
A helpful detail of using this feature is that it saves considerable time by eliminating the need to manually locate every instance where an alteration is required.
Pro Tip: It’s important not to rush through this process—this will help ensure accurate results as well as assisting in making sure relevant data isn’t replaced mistakenly.
Five Facts About 15 Excel Shortcut Keys for Strikethrough:
- ✅ Strikethrough is a formatting option in Excel used to cross out cells or text. (Source: Microsoft)
- ✅ The shortcut key to apply strikethrough formatting in Excel is “Ctrl + 5”. (Source: Lifewire)
- ✅ The shortcut key to remove strikethrough formatting in Excel is also “Ctrl + 5”. (Source: Excel Campus)
- ✅ You can customize Excel shortcut keys to include strikethrough in other key combinations. (Source: Spreadsheeto)
- ✅ Strikethrough can be applied to entire rows or columns in Excel by selecting them first. (Source: Trump Excel)
FAQs about 15 Excel Shortcut Keys For Strikethrough
What are the 15 Excel Shortcut Keys for Strikethrough?
The 15 Excel Shortcut Keys for Strikethrough are:
- Ctrl + 5
- Ctrl + Shift + 5
- Alt + H + 4 + S
- Ctrl + 1 (Format Cells Dialog)
- Alt + F + H
- Alt + R + S + T
- Alt + E + S
- Ctrl + Shift + 9
- Ctrl + – (Minus Sign)
- Ctrl + Shift + 5 (Equal Sign)
- Ctrl + 6
- Ctrl + Shift + F (Font Dialog)
- Ctrl + Shift + P (Format Painter)
- Ctrl + D (Fill Down Command)
- Ctrl + R (Fill Right Command)
How do I use the Ctrl + 5 shortcut for strikethrough?
To use the Ctrl + 5 shortcut for strikethrough, first select the cell or cells that you want to format. Then press the Ctrl + 5 keys on your keyboard. This will apply strikethrough formatting to the selected cells.
Can I customize the shortcut keys for strikethrough?
Yes, you can customize the shortcut keys for strikethrough by going to File > Options > Customize Ribbon > Keyboard Shortcuts. In the Customize Keyboard dialog box, select Format in the Categories list, then select Strikethrough in the Commands list. You can then assign a new shortcut key combination in the Press new shortcut key field.
What is the Alt + H + 4 + S shortcut for strikethrough?
The Alt + H + 4 + S shortcut for strikethrough is a sequence of shortcut keys that can also be used to apply strikethrough formatting to selected cells. First press the Alt key, then press H, then 4, and finally S. This will apply strikethrough formatting to the selected cells.
How can I remove strikethrough formatting from cells?
To remove strikethrough formatting from cells, select the cell or cells that you want to format. Then press Ctrl + 1 on your keyboard to open the Format Cells dialog box. Select the Font tab, and then uncheck the Strikethrough checkbox. Click OK to apply the changes.
Is there a shortcut to quickly apply strikethrough to text within a cell?
Yes, you can apply strikethrough to text within a cell by first selecting the text that you want to format. Then press Ctrl + 5 on your keyboard to apply strikethrough formatting to the selected text.