HOW TO STRIKETHROUGH TEXT IN EXCEL

INTRODUCTION

We make reports in Excel.
Reports consist of text
numbers and symbols. The need to strikethrough the text may arise any time in different situations.


STRIKETHROUGH MEANS TO DRAW A HORIZONTAL LINE IN THE TEXT THROUGH THE MIDDLE SUCH THAT IT SEEMS LIKE CROSSED OUT.


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

STRIKING THROUGH IS USED TO SHOW SOMETHING WHICH WAS THERE BUT NOW BEEN REMOVED OR NOT NEEDED OR COMPLETED.

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

WHEN IS STRIKE THROUGH USED IN EXCEL ?

STRIKING THROUGH 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.

WAYS TO STRIKETHROUGH 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.

STRIKETHROUGH TEXT IN EXCEL USING RIGHT CLICK OPTION

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

STEPS TO STRIKETHROUGH OR 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.
STEPS TO STRIKE THROUGH IN EXCEL
  • Click OK.
  • The text will be striked through.

Look at the final picture.

STRIKETHROUGH TEXT IN EXCEL USING EXCEL RIBBON OPTION

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

STEPS TO STRIKETHROUGH 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.

STRIKETHROUGH 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 STRIKETHROUGH 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 Strikethrough format.

REMOVE STRIKETHROUGH 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.
  • Strikethrough will be removed.

STRIKETHROUGH ONLY A PART OF THE TEXT WITHIN A CELL

Some students ask this questions whether we can strikethrough a part of the text in a single cell .The answer is YES!! Strikethrough would work only on the part of the text which you have selected before applying the operation.It means, if you want to apply the strikethrough on 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 STRIKETHROUGH