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

The spreadsheets count on Functions to compare two sets of data and establish the differences between themThe problem arises when it is needed print these tables and prove that there are Variaciones.

For this, There is a visual effect in Excel that lets people know that the data was viewed and controlled by the user.In these cases, the tool is used to strikethrough of text.

So that you can get the most benefit from this feature 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 piece of information or a word instead of deleting or replacing it?

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

I also know Use this function when one should be done Comparison between two Excel templates using appropriate tools, but they don't stand out when you print the document. This is why you can use text strikethrough to have, on a physical piece of paper, the control check.

Learn how to strikethrough any data or text from a spreadsheet in Excel.

To strikethrough data or text in an Excel spreadsheet, you will need to follow this process:

• Take the right click in the cell that you want to cross out.
• Then choose the option “Cell formatting…”.
• Click on the tab "Fountain".
• Then, look for the group. "Effects" and activate the box “Crossed out”.
• If you want you can change the color of the line and the letter choosing the option "Colour".

Anytime remove the strikethrough You will have to follow the same steps and uncheck the corresponding box.

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

Both numerical and text data are not modified when they are crossed out. So their values They continue to be reflected in the results of formulas and functions, since this tool is only a visual effect that helps the user perform other types of controlsIn case you need these cells do not influence a formula, there will be delete them and don't cross them out.