If you want the text to wrap to multiple lines if the column is too narrow to display it on one line, double-click on the header of the column and select the Header Text Wrapping checkbox and press OK.