One of the most popular formatting styles is strikethrough. In other words, it is the ability to cross out text. And there’s a way to use this option in Microsoft Excel on any cell.
For example, let’s say you’ve created a list of things you want to do for the week in Microsoft Excel. As you complete the tasks, you can cross them off by marking them as done. Below you can find out what options there are for using strikethrough in Microsoft Excel.
How to cross out in Microsoft Excel on any cell
There are different ways to access the strikethrough feature in Excel. To use it – follow these steps:
- First of all, go to the Home tab.
- Then click on the “Font Settings” option located in the “Font” section.
- After that, you will see the “Strikethrough” option in the appearing list.
- Finally, select this option and you will see that the items in cells are become crossed out.
You can open the Format Cells window by right-clicking on a cell and selecting that option, which should be at the very bottom. There is also a way to use the “Ctrl + 1” keyboard shortcut. You can also try “Ctrl + Shift + F”.
An even faster way is to select the cell to which you want to apply the strikethrough and press “Ctrl + 5”. That’s all you need to do.
How to strikethrough in Microsoft Excel using the Quick Acces Toolbar
If you want to cross out text in Microsoft Excel using only the mouse, here’s what you have to do:
- To do this, right-click anywhere in the green area at the top (Quick Access Toolbar) and select “Customize Quick Access Toolbar”.
- When the Excel Options window appears, make sure that the first option you choose is the Quick Access Toolbar on the left.
- After that, select the “All Commands” option from the Choose command at the top.
- Then find the “Strikethrough” option in the list and select it.
- Click the Add button to make the options already listed appear.
- Finally, click OK at the bottom to save your changes.
You can also apply strikethrough only to specific words in a cell. At the top, highlight the word you want to cross out and then click on the strikethrough option. In the image below, you will see what it will look like.
If at any time you want to remove the strikethrough, all you have to do is repeat the steps you took to apply it. For example, if you used it the first time by pressing “Ctrl + 5”, select the cell and press the same keys.
Read Also:
- How to build a bubble chart in Microsoft Excel
- How to use the SUBSTITUTE function in Microsoft Excel
- How to add today’s date in Microsoft Excel
Why do you need to use strikethrough?
When editing a document, strikethrough conveys the editor’s intention to delete the content being edited. Crossed out text is a basic symbol of editing.
For example, editing using the change tracking feature in Microsoft Word indicates deletion with a red strikethrough. When you edit a document using Word’s review tools, you either accept or reject the proposed deletion. If you accept it, the crossed-out text disappears. If you reject it, the strikethrough disappears and the text remains as is.
When you see strikethroughs in documents that appear in black, it indicates that someone intends to make changes but isn’t using the change tracking feature.
You should also know that you can use the same strikethrough options in Google Docs. You can even cross out text on Telegram and Discord. As you can see, there’s nothing really complicated about this feature. That’s why you can apply it not only in word processors, but even in messengers.
how to undo this action?