In tables and pivot tables, when your data contains text columns, you can use the wrap text formatting option to display the entire value over multiple lines. Table and pivot table rows may span one or more lines, depending on the length of text.

This does not apply to the name or title of the column.

To wrap the text, follow these steps:

  1. In the table, select the column that has lengthy text values.
    Here, we selected the column Product.
  2. SelectΒ  Wrap text () next to the formula bar:
    How to activate text wrap
  3. The text in the column is wrapped to the next line. Longer text wraps over more lines accordingly. For example,
    The Product value wraps over 3 lines in the rows where Product Key is 6 and 8, while it only wraps over 2 lines for the other records in the following screenshot:
    How text wrap looks in a column