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 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

 

PORTION OF TEXT IS HIDDEN

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.
CELL SHOWING THE COMPLETE TEXT AFTER APPLYING WRAP TEXT

After applying WRAP TEXT , all the content is fully visible. This demo shows the use of wrap text.

ALWAYS REMEMBER…

1.Sometimes without using Wrap Text also, we can see the text, condition being , that no text is present in the adjacent cell. But that is very unsafe way of forcing the text to be visible. So its always advisable to use Wrap Text if text is long and you need it to be in one cell only.

2.After applying wrap text, the size of cell may misbehave, you have to adjust it afterwards. So its advisable to apply the WRAP TEXT in the starting only so that you can see how the cell is behaving rather than applying it at the end.

 

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 sub classes 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.

PICTURE SHOWING THE HIDDEN TEXT

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.

 

MERGED CELLS TO SHOW THE HIDDEN TEXT

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. The description follows the picture.

DIFFERENT MERGE OPTIONS IN EXCEL

FUNCTIONACTION
MERGE AND CENTER:Merge the cells and align to center
MERGE ACROSS:Merge the columns of the selected rows
MERGE CELLS:Merge all the selected cells with the text aligned to left.
UNMERGE CELLS:Unmerge all the cells with text in upper left corner.

ANIMATED EXAMPLE OF MERGING CELLS IN EXCEL

The following picture shows the different steps of merging cells in excel.

 

STEPS TO PERFORM DIFFERENT MERGING OPERATIONS