How to keep excel cell data visible in one cell (How to wrap text)

 

In excel, wrap text is used to keep excel cell visible in one cell, in other words it restrain data to flow in other cells.

Let’s see how it works.

  • First of all select the cell you want to wrap.
  • Right Click after selecting the cell.
  • Select “Format Cells”.
  • Select “Wrap Text” in opened window.
  • Now press “ok” and adjust the height of cell to fit the text.
wrap text in excel

Read more…

22 Excel Tips for Becoming a Spreadsheet Pro

How to remove duplicates in Excel

20 Excel Tricks That Can Make Anyone An Excel Expert