How to display Power Query results with line feed or carriage return

Although you can inject linefeeds (“#(lf)”) and carriage returns (“#(cr)”) in Power Query, lines will not break in the Excel-display. This simple trick makes your lines break nicely in Excel:


  1. Click into the formula bar
  2. Click back into your sheet & the lines will be broken:


3. Apply that format to the whole column.

4. Make that format stick for future refreshes: Table Tools -> Design -> External Table Data -> Properties -> Check: “Preserve column sort/filter/layout”

Enjoy & stay queryious 🙂

Leave a Reply