HOW TO CROSS OUT TEXT IN EXCEL

Table of Contents

INTRODUCTION

Crossing out the text is needed many times while making the reports.

CROSSING OUT TEXT PLACES A HORIZONTAL LINE THROUGH THE TEXT.


The formatting of the text consists of many operations such as setting the size of the text or numbers, making them bold for giving emphasis,
underlining them for showing the importance and

Crossing out needed to show some values which are important to be shown but removed from the list

So, in this article we would learn various fast and speedy ways to strike through the text in excel.



WHAT IS CROSSING OUT OR STRIKE THROUGH TEXT IN EXCEL?

CROSSING OUT OR STRIKE THROUGH simply means to put a horizontal line through the word.

Cross out or strike through or strike out means cancelling a word or nullifying something which was already present.

WHEN IS CROSS OUT USED IN EXCEL ?

CROSSING OUT THE TEXT to show that

  • Something which has been removed from the data.
  • Any task which was there but now has been completed.
  • Anything , where we want to show the presence of some information but which has been omitted or has become redundant.

For the example,

Suppose, we have a list of chores

  1. Do the dishes.
  2. Wash the car.
  3. Go to Market.
  4. Meet any friend and so on.

After we have complete two jobs. Our list can be shown as

  1. Do the dishes.
  2. Wash the car.
  3. Go to Market.
  4. Meet any friend and so on.



CROSS OUT, STRIKE THROUGH, STRIKE OUT , ALL THESE WORDS MEANS THE SAME. IT MEANS THE STRIKE THROUGH TEXT



WAYS TO CROSS OUT TEXT IN EXCEL

We can use many ways to strike through the text in Excel.

The ways available are :

  • RIGHT CLICK > FORMAT CELLS.
  • EXCEL RIBBON
  • KEYBOARD SHORTCUT

Let us discuss all the ways one by one in detail.

CROSS OUT TEXT IN EXCEL USING RIGHT CLICK OPTION

This section deals with the techniques to  CROSS OUT the text in Excel.

STEPS TO  CROSSOUT THE TEXT IN EXCEL.

  • Right Click the cell containing the text which needs to be crossed out and choose FORMAT CELLS.
  • In the dialog box opened, go to FONT TAB and click STRIKETHROUGH as shown in the picture below.
STEPS TO STRIKE THROUGH IN EXCEL
  • Click OK.
  • The text will be CROSSED OUT.

Look at the final picture.

CROSS OUT TEXT IN EXCEL USING EXCEL RIBBON OPTION

We can also strikethrough our text directly from the EXCEL RIBBON.

STEPS TO CROSS OUT USING THE OPTION PRESENT IN EXCEL RIBBON:

  • Select the cell in which you want to strikethrough the text.
  • Click the FONT SETTINGS button on the EXCEL RIBBON. Location is shown below in the picture.
FONT SETTINGS BUTTON LOCATION
  • After clicking FONT SETTINGS button, again the FORMAT CELLS DIALOG BOX will open.
  • Check the STRIKETHROUGH option.
  • Click OK.
  • The text in the selected cell will start showing the Strikethrough format.
STEPS TO STRIKE THROUGH IN EXCEL
  • Click OK.
  • The text will be striked through.

The final text looks like this one.

RESULT



CROSS OUT TEXT IN EXCEL USING KEYBOARD SHORTCUT

The fastest way of operation in any software is still the use of KEYBOARD SHORTCUTS.

We are lucky to have a keyboard shortcut for the use of STRIKETHROUGH too.

Follow the steps to use keyboard shortcut to CROSS OUT any text in Excel.

  • Select the cell in which we want to strikethrough the text.
  • Press CTRL , and press 5.
  • It’ll strikethrough the text within fractions of seconds.
USE CTRL+5 SHORTCUT TO STRIKETHROUGH AND PRESS AGAIN TO REMOVE STRIKETHROUGH
  • After clicking FONT SETTINGS button, again the FORMAT CELLS DIALOG BOX will open.
  • Check the STRIKETHROUGH option.
  • Click OK.
  • The text in the selected cell will start showing the CROSS OUT format.

REMOVE CROSS OUT FORMAT FROM TEXT IN EXCEL

STRIKETHROUGH is a toggle function [ When keyboard shortcut is used ].

TOGGLE FUNCTIONS WORK IN AN ON OFF WAY.

Once used, they’ll put the effect on, pressed again they’ll remove the effect. Simply select the cell or text and click CTRL+5. [ 5 on the main keyboard and not on the numeric pad]

Strikethrough will be removed.Similarly, we can easily remove strikethrough by

  • Select the cells from which you want to remove Strikethrough.
  • Open FONT SETTINGS WINDOW or RIGHT CLICK > FORMAT CELL.
  • Deselect STRIKETHROUGH and click OK.
  • CROSSED OUT FORMAT will be reversed.

CROSS OUT ONLY A PART OF THE TEXT WITHIN A CELL

Some students ask this questions whether we can CROSS OUT a part of the text in a single cell .

The answer is YES!! 

Strikethrough option to cross out would work only on the part of the text which you have selected before applying the operation.

It means, if you want to cross out a portion of a text, simply select it and use any of the above mentioned methods to StrikeThrough the selected text easily.Look at the animation below.

SELECT THE PORTION OF THE TEXT AND APPLY THE SAME PROCEDURE TO CROSS OUT

These were a few ways to strike out or cross out text in Excel.