PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO CROSS OUT TEXT IN EXCEL

INTRODUCTION

Crossingout 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 strikethrough the text in excel.
 
 

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.

 

  1. Go to Market.
  2. Meet any friend and so on.

WAYS TO CROSS OUT TEXT IN EXCEL

We can use many ways to strikethrough 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 and choose FORMAT CELLS.

 
  • In the dialog box opened, go to FONT TAB and click STRIKETHROUGH as shown in the picture below.
CROSS OUT IN EXCEL
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.
easy ways to strikethrough text in excel
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.
easy ways to strikethrough text in excel
STEPS TO STRIKE THROUGH IN EXCEL
  • Click OK.
  • The text will be striked through.

The final text looks like this one.

 

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.
easy ways to strikethrough text in excel
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.

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.
easy ways to strikethrough text in excel
SELECT THE PORTION OF THE TEXT AND APPLY THE SAME PROCEDURE TO CROSS OUT

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

KINDLY SPEND FEW SECONDS HERE....

-We might be compensated for the visits or purchases you make by clicking the ads on this website .  They help us to keep bringing excellent quality articles for you.
-Click on the pictures if you can’t read. All of them are High Resolution .
-If you can’t find what you were looking for, kindly message in the chat box.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW