【 Cross Out Data or Text in Excel 】 Step by Step Guide ▷ 2022

The count on functions to compare 2 data sets and establish the differences between them. The problem arises when it is needed print these tables and show that there is variations.

For this, there is a visual effect of excel so that people can know that the data was seen and controlled by the user. In these cases, the tool strikethrough text.

So that you can get the most benefit from this function that it offers you Excelwe recommend that you continue reading this article until the end because We will teach you all the secrets it holds.

Why cross out a fact or word instead of deleting or replacing it?

This tool is used frequently when you have to compare the spreadsheet with some physical document. In this way, each time a concept is crossed out, it is established that the same is found on both sides.

I also know use this function when to do one comparison between two excel templates using proper tools, but they don’t stand out when you print the document. This is why you can use the text strikethrough to have, on a physical piece of paper, the control check.

Learn how to cross out any data or text in an Excel spreadsheet

To cross out data or text in an Excel spreadsheet you will have to follow this process:

• Beam right click on the cell What do you want to cross out?
• Then choose the option “Cell format…”.
• Click on the tab “Font”.
• Then find the group “Effects” and check the box “Strikethrough”.
• If you want you can change the color of the line and the letter choosing the option “Color”.

Whenever you want remove strikethrough you will have to follow the same steps and uncheck the corresponding box.

Does the data and text that I cross out influence the results of the functions or formulas in the table?

Both numeric and text data when crossed out are not modified. so your values follow in the results of the formulas and functions, since this tool is only a visual effect that helps the user perform other types of controls. In case you need these cells do not influence a formulait will have to delete them and not cross them out.