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]
Let us try to create vertical text in excel.
The vertical text can be the need of any report where we want the heading to be vertical.
TEXT BEING VERTICAL can have two meanings.
1. Vertical text but in the same cell.
2. Vertical text in the different cells.
VERTICAL TEXT IN THE SAME CELL:
Follow the steps to create a vertical text in the same cell.
1. Enter the text normally, where we want to enter.
2. Go to HOME TAB>ORIENTATION>VERTICAL TEXT.
3. The text will become vertical simply. Check out the following picture for the results.
2.VERTICAL TEXT IN DIFFERENT CELLS:
If the text is in cells horizontally and we want to place it vertically we can use the following methods.
Let us take an example where the following text is put in the cells horizontally.
HELLO as shown in the picture below.
USING PASTE SPECIAL
USING TRANSPOSE FUNCTION.
USING PASTE SPECIAL:
STEPS TO MAKE THE TEXT VERTICAL USING THE PASTE SPECIAL FUNCTION
The result will appear as the word HELLO will become vertical .
GIVEN TEXT- HELLO as shown in the picture below.
STEPS TO MAKE THE TEXT VERTICAL USING THE TRANSPOSE FUNCTION.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE