How to Use the Strikethrough Keyboard Shortcut in Excel

If you’re like most people, you probably use the strikethrough keyboard shortcut in Excel all the time. But did you know that there’s an even easier way to do it? With a little bit of know-how, you can use the strikethrough keyboard shortcut in Excel in just a few seconds. Here’s how:

  1. First, open up Excel and select the cell or range of cells that you want to strikethrough. For this example, we’ll select cells A1:A5.
  2. Next, press the Alt+F11 keys on your keyboard. This will open the Microsoft Visual Basic for Applications window.
  3. In the Microsoft Visual Basic for Applications window, click Insert > Module. This will insert a new module into the window.
  4. In the new module, paste the following code:

Sub Strikethrough()

‘ Strikethrough Macro


Selection.Font.Strikethrough = True
End Sub

  1. Now, press the F5 key on your keyboard to run the macro. This will strikethrough the selected cells.
  2. Finally, press the Alt+F11 keys on your keyboard to close the Microsoft Visual Basic for Applications window.

And that’s all there is to it! With just a few simple steps, you can use the strikethrough keyboard shortcut in Excel to save time and increase your productivity. Give it a try today and see how much easier your life can be.

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. One of the most useful shortcuts in Excel is the strikethrough keyboard shortcut. This simple shortcut can save you time and make your data more organized. In this article, we will explore how to use the strikethrough keyboard shortcut in Excel.

What is Strikethrough?

Strikethrough is a formatting option that allows you to draw a line through a cell or a range of cells. This is useful when you want to indicate that a value or a piece of information is no longer relevant or has been deleted. Strikethrough can also be used to highlight data that has been replaced or updated.

How to Use the Strikethrough Keyboard Shortcut

The strikethrough keyboard shortcut is a simple combination of keys that can be used to apply or remove strikethrough formatting. Here are the steps to use the strikethrough keyboard shortcut:

Step 1: Select the Cell or Range of Cells

First, select the cell or range of cells that you want to apply strikethrough formatting to. You can do this by clicking on the cell or dragging your mouse over the range of cells.

Step 2: Open the Format Cells Dialog Box

Next, open the Format Cells dialog box by pressing the Ctrl + 1 keys on your keyboard. Alternatively, you can right-click on the selected cells and choose Format Cells from the context menu.

Step 3: Apply Strikethrough Formatting

In the Format Cells dialog box, click on the Font tab and check the Strikethrough box under Effects. Click OK to apply the formatting to the selected cells.

Step 4: Use the Strikethrough Keyboard Shortcut

Once you have applied strikethrough formatting to a cell or range of cells, you can use the strikethrough keyboard shortcut to quickly apply or remove the formatting. To apply strikethrough formatting, select the cell or range of cells and press the Ctrl + 5 keys on your keyboard. To remove strikethrough formatting, select the cell or range of cells and press the Ctrl + 5 keys again.

Conclusion

The strikethrough keyboard shortcut is a simple but powerful tool that can help you manage your data more efficiently in Excel. By using this shortcut, you can quickly apply or remove strikethrough formatting without having to navigate through menus or dialog boxes. This can save you time and make your data more organized and easier to read. So, the next time you need to indicate that a value or a piece of information is no longer relevant, remember to use the strikethrough keyboard shortcut in Excel.

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.