In Microsoft Excel, you can add a line through your text, which is called “Strikethrough.” This can be helpful for various tasks like marking completed items. It’s a handy skill to have, and it makes working with Excel even better. In this article, we will dig into how to apply strikethrough formatting in Excel swiftly and effortlessly using keyboard shortcuts.
Using Keyboard Shortcut:
Let’s explore how to apply strikethrough formatting in Excel with ease, thanks to keyboard shortcuts:
Select Your Text:
Begin by selecting the cell or cells containing the text you wish to strikethrough.
Windows Shortcut (Ctrl + 5):
The keyboard shortcut for applying strikethrough formatting in Excel on Windows is `Ctrl + 5`. To use this shortcut, hold down the “Ctrl” key and press “5.” This will promptly apply strikethrough formatting to the selected text.
Multiple Selections:
You can also apply strikethrough formatting to multiple non-contiguous cells simultaneously. Just hold the “Ctrl” key while selecting each cell or cell range, and then use the keyboard shortcut.
Undoing Strikethrough Formatting:
Made a mistake or changed your mind? You can undo strikethrough formatting by applying the same keyboard shortcut again while the text is selected. This will toggle the strikethrough effect on and off.
In Excel, the ability to apply strikethrough formatting quickly and effortlessly using keyboard shortcuts can significantly enhance your data presentation. By following these simple steps and mastering the keyboard shortcuts, you can make your spreadsheets more effective and visually engaging, ultimately improving your Excel skills.