Whenever we prepare any report in excel, we have two constituents in any report.
The Text portion and the Numerical portion.
But just storing the text and numbers doesn’t make the super reports. Many times we need to automate the process in the reports to minimize the effort and improve the accuracy.
Many functions are provided by the Excel which work on Text and give us the useful output as well. But few problems are still left on which we need to apply some tricks with the available tools.
THIS WAS AN EXCERPT FROM THE FIRST ARTICLE OF THIS SERIES MANIPULATING TEXT IN EXCEL – PART I
In this articles , we will continue learning many more techniques about the manipulation of text in Excel.
TEXT IS AN INACTIVE NUMBER TYPE[FORMAT] IN EXCEL. ANYTHING STORED AS TEXT [NUMBER OR DATE] WON’T RESPOND TO ANY STANDARD FORMULAS OR FUNCTIONS BUT SPECIALLY DESIGNED TEXT FUNCTIONS. [EXCEPTIONS DO OCCUR IN CASE OF NUMBERS]
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.
The text will be crossed out.
Look at the final position.
SHORTCUT TO CROSS OUT TEXT / STRIKETHROUGH
We can simply use a simple shortcut to strikethrough or cross out the text by selecting the cell containing the text and pressing CTRL+5.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE