How to strikethrough text or data in a Microsoft Excel spreadsheet? step by step guide

The spreadsheets count on functions to compare 2 data sets and establish the differences between them. The problem arises when you need print these tables and prove 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 has.

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 strikethrough text to have, on a physical paper, the control check.

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

To cross out a 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 line and letter color 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 I strike out influence the results of functions or formulas in the table?

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