The Excel Strike Through Shortcut You Need to Know

If you’re like most people, you probably use Microsoft Excel on a daily basis. And if you’re like most people, you probably don’t know about the strike through shortcut. This is a shame, because the strike through shortcut is one of the most useful shortcuts in Excel. Here’s what you need to know about the strike through shortcut.

The strike through shortcut is a keyboard shortcut that allows you to quickly add a line through your text. To use the shortcut, simply select the text that you want to add a line through, and then press the following keys on your keyboard: Alt + H + 5.

That’s it! The shortcut will automatically add a line through your selected text. This is a great way to quickly add emphasis to certain words or phrases, or to indicate that something is crossed out.

One thing to keep in mind is that the strike through shortcut only works with text that is already formatted as plain text. So, if you try to use the shortcut on a cell that contains a number or a formula, it won’t work. However, you can easily convert your numbers and formulas to plain text by selecting them and then pressing the Ctrl + Shift + F12 keys on your keyboard.

So, there you have it! The next time you need to add a line through your text in Excel, be sure to use the strike through shortcut. It’s a quick and easy way to get the job done.

Excel is a powerful tool that can help you manage and analyze data with ease. However, with so many features and functions, it can be overwhelming to navigate. That’s why shortcuts are essential to help you work more efficiently. One of the most useful shortcuts in Excel is the strike-through shortcut. In this article, we’ll explore how to use this shortcut and other Excel shortcuts that can save you time and effort.

What is the Strike-Through Shortcut?

The strike-through shortcut is a formatting tool that allows you to cross out text in a cell. This is useful when you want to indicate that a value is no longer relevant or has been replaced by a new value. To use the strike-through shortcut, simply select the cell or cells you want to format and press the following keys:

Windows:

Ctrl + 5

Mac:

Command + Shift + X

Once you’ve pressed the shortcut keys, the selected text will be crossed out. You can also use this shortcut to remove the strike-through formatting by selecting the cell and pressing the shortcut keys again.

Other Useful Excel Shortcuts

Now that you know how to use the strike-through shortcut, let’s explore some other Excel shortcuts that can save you time and effort:

1. Copy and Paste

Copying and pasting is a common task in Excel. Instead of using the mouse to navigate to the copy and paste buttons, you can use the following shortcuts:

Windows:

Copy: Ctrl + C

Paste: Ctrl + V

Mac:

Copy: Command + C

Paste: Command + V

2. Insert Current Date or Time

If you need to insert the current date or time into a cell, you can use the following shortcuts:

Windows:

Current Date: Ctrl + ; (semicolon)

Current Time: Ctrl + Shift + ; (semicolon)

Mac:

Current Date: Command + ; (semicolon)

Current Time: Control + Shift + : (colon)

3. Select Entire Rows or Columns

If you need to select an entire row or column, you can use the following shortcuts:

Windows:

Select Row: Shift + Spacebar

Select Column: Ctrl + Spacebar

Mac:

Select Row: Shift + Spacebar

Select Column: Command + Spacebar

4. Autofill

Autofill is a useful feature that allows you to quickly fill a series of cells with a pattern. To use Autofill, select the cell with the pattern you want to fill and drag the fill handle (the small square in the bottom right corner of the cell) across the cells you want to fill. You can also use the following shortcut:

Windows and Mac:

Ctrl + D (to fill down)

Ctrl + R (to fill right)

Conclusion

Excel shortcuts can save you time and effort when working with data. The strike-through shortcut is just one of many shortcuts that can help you work more efficiently. By using these shortcuts, you can streamline your workflow and become an Excel power user.

Related

Did you find this article useful?

Share it with your friends or colleagues

About Aepoch Advisors

We are a boutique accounting and consulting firm servicing international businesses operating in China. We offers book keeping and business advisory service. We also help our clients select and implement SAAS business applications
 
Cloud technology significantly reduces cost foreign companies traditionally spent on tax compliance and ERP systems. Our cloud professionals can help with streamlining your management and controling structure, as well as advising you on how to reduce risks and maximize profits with software purposely built for Chinese business. Contact us today to learn more about our services.