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:
- 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.
- Next, press the Alt+F11 keys on your keyboard. This will open the Microsoft Visual Basic for Applications window.
- In the Microsoft Visual Basic for Applications window, click Insert > Module. This will insert a new module into the window.
- In the new module, paste the following code:
Sub Strikethrough()
'
' Strikethrough Macro
'
'
Selection.Font.Strikethrough = True
End Sub
- Now, close the Microsoft Visual Basic for Applications window and return to Excel.
- To use the strikethrough keyboard shortcut, simply select the cell or range of cells that you want to strikethrough and press the Alt+Shift+F11 keys on your keyboard. That's it!
As you can see, using the strikethrough keyboard shortcut in Excel is a breeze. Give it a try the next time you need to strikethrough a cell or range of cells. You'll be glad you did.