PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
“WRAP TEXT IN EXCEL IS THE PROCESS OF WRAPPING(folding or compacting) THE TEXT TO MAKE IT VISIBLE IN A SINGLE CELL”.
WRAP; as the word has literal mean of folding things up and the option is available in many other applications like notepad, is similar in the case of Excel too.
WRAP TEXT: In excel, if you type a long text in a cell and it has filled the visible area of the cell, it’ll start overlapping over the content of the other cell, and when you click the other cell the text of the first cell will be hidden.(The situation is shown in the picture below).
Think of a situation when you want your text to be clearly visible all the time. So we use this function WRAP TEXT for that particular situation.
The complete text is ” Welcome to Gyankosh” But the cell is showing only the portion-“Welcome”, “TO GYANKOSH” is hidden and hello is shown as it is in the next cell.
Lets apply wrap text and check the results.
After applying WRAP TEXT , all the content is fully visible. This demo shows the use of wrap text.
“MERGING IS THE PROCESS OF JOINING THE TWO OR MORE CELL IN EXCEL”.
THE CELLS CAN BE IN SAME ROW OR DIFFERENT ROWS. THE CELLS CAN BE IN COLUMNS ALSO BUT NEED TO BE ADJACENT.
As the name suggests it does the job of merging (join the two cells into one) two cells.
The two cells are merged for the presentation purpose mainly, or if there is a group which belong to the same class or any particular need as per choice.
It is also done when we have a class and there are many subclasses which we want to show under a main Class.
If we don’t want to use WRAP TEXT merging can be done to make the cells longer.
The shown text is same as we discussed in case of WRAP TEXT. The complete text “Welcome to Gyankosh” is not visible in the cell. Hello is the content of other cell.
In addition to the above mentioned option of merging, few more options are present in the menu, which will be shown if the down arrow near the button is clicked. The pic is shown in the following picture.
MERGE AND CENTER:
MERGE ACROSS:
MERGE CELLS:
UNMERGE CELLS:
merge the cells and align to center
merge the columns of the selected rows
merge all the selected cells with the text aligned to left.
unmerge all the cells with text in upper left corner.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE