Forum Discussion

ailsazheng's avatar
ailsazheng
Frequent Visitor
3 years ago
Solved

How to shorten table length

This seems like it would have a very simple solution, I just cannot find it. I have a table where the cell height is unnecessarily wide. How do I make the rows shorter so that it is just wide enough ...
Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    Usually when that happens, there is a value in each row that requries multiple rows to display. (e.g. a very long sentence). If this is happening to you, then you can either go to Format > Values > Text Wrap and turn that off. 
    The other issue may be that some of your values have extra (empty) lines at the end of them. To solve this, go into Power Query and trim / clean those empty lines from the value.

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

Usually when that happens, there is a value in each row that requries multiple rows to display. (e.g. a very long sentence). If this is happening to you, then you can either go to Format > Values > Text Wrap and turn that off. 
The other issue may be that some of your values have extra (empty) lines at the end of them. To solve this, go into Power Query and trim / clean those empty lines from the value.