PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
Contents
HOW TO USE WRAP TEXT AND MERGE CELLS IN EXCEL?
WRAP TEXT IN EXCEL
INTRODUCTION
“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.
WHEN TO USE WRAP TEXT IN EXCEL?
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.
EXAMPLE OF WRAP TEXT IN EXCEL
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.
STEPS TO WRAP TEXT IN EXCEL
- Select the cell/cells where the WRAP TEXT needs to be applied.
- CLICK on the button WRAP TEXT.
- The result is visible as shown in the picture.
- The complete text is shown in the cell by increasing the height of the row.
After applying WRAP TEXT , all the content is fully visible. This demo shows the use of wrap text.
WHAT IS MERGING CELLS IN EXCEL?
INTRODUCTION
“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.
WHEN TO USE MERGE IN EXCEL?
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.
EXAMPLE OF MERGE TEXT IN EXCEL
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.
STEPS TO MERGE CELLS IN EXCEL
- Select the cell/cells where the MERGING needs to be done.
- CLICK on the button MERGE AND CENTER.
- The result is visible as shown in the picture.
- The complete text is shown in the cell by increasing the height of the row.
OTHER OPTIONS TO MERGE CELLS IN EXCEL
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.
ANIMATED EXAMPLE OF MERGING CELLS IN EXCEL
OTHER WAYS TO REACH THIS ARTICLE
-
HOW TO FOLD TEXT IN EXCEL, HOW TO JOIN TWO CELLS IN EXCEL, HOW TO MAKE THE CELLS LONGER, HOW TO MAKE CLASS IN EXCEL, HOW TO FIT TEXT IN ONE CELL
YOU MAY LIKE
- HOW TO INSERT WORD ART, OBJECT AND SYMBOL
- USE OF FONTS, FONT SIZE, INDENTATION, TEXT TO THE RIGHT, TEXT TO THE LEFT, TEXT IN THE MIDDLE ETC.
- what is data validation in excel?
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.