How to strikethrough text in excel

In the process of working on the visual design of text in Excel tables, it is often necessary to highlight this or that information. This is achieved by adjusting such parameters as the type of font, its size, color, fill, underline, alignment, format, etc. Popular tools are displayed on the program ribbon so that they are always at hand. But there are other features that are not needed as often, but it is useful to know how to find them and apply them if you need them. These include, for example, strikethrough text. In this article, we will see how you can do this in Excel.

Method 1: Strikethrough an Entire Cell

To achieve this goal, we adhere to the following action plan:

1. In any convenient way, select the cell (or area of ​​cells), the contents of which we want to cross out. Then right-click on the selection and select the item from the drop-down list “Cell Format”. You can also just press the keyboard shortcut instead Ctrl + 1 (after selection is made).
2. The format window will appear on the screen. Switching to the tab “Font” in the parameter block “Change” find option “crossed out”, mark it and click OK.
3. As a result, we get the strikethrough text in all selected cells.

Method 2: Crossing out a single word (fragment)

The method described above is suitable in cases where you want to cross out the entire contents of a cell (range of cells). If you need to cross out individual fragments (words, numbers, symbols, etc.), follow the steps below:

1. Double-click on the cell or place the cursor on it and then press the key F2. In both cases, the edit mode is activated, which will allow us to select the part of the content to which we want to apply formatting, namely the strikethrough.As in the first method, by right-clicking on the selection, we open the context menu, in which we select the item – “Cell Format”.Note: selection can also be performed in the formula bar by first selecting the desired cell. In this case, the context menu is invoked by clicking on the selected fragment in this particular line.
2. We can notice that the cell formatting window that opens this time contains only one tab “Font”, which is what we need. Here we also include the parameter “crossed out” and click OK.
3. The selected part of the cell content has become crossed out. Click Enterto complete the editing process.

Method 3: Apply Tools on the Ribbon

On the ribbon of the program, there is also a special button that allows you to get into the cell formatting window.

1. To begin with, we select a cell/fragment of its contents or a range of cells. Then in the main tab in the tool group “Font” click on the small icon with an arrow pointing diagonally down.
2. Depending on what selection was made, a formatting window will open – either with all tabs, or with one (“Font”). Further actions are described in the relevant sections above.

Method 4: hotkeys

Most functions in Excel can be launched using special keyboard shortcuts, and strikethrough text is no exception. All you have to do is press the combination Ctrl + 5, after the selection is made.

The method, of course, can be called the fastest and most comfortable, but for this you need to remember this key combination.

Conclusion

Despite the fact that strikethrough text is not as popular as, for example, bold or italic, it is sometimes necessary for the qualitative presentation of information in tables. There are many ways to cope with the task, and each user can choose the one that seems most convenient for him to implement.