Often times QuickBooks users will use the Description field on sales transactions to describe multiple tasks or events for that item. A frequent question that we receive is how to format the excel file so that there will be multiple lines instead of the description wrapping.
In your excel file provide all the relevant info in the cell. Then right before the first character that you want to appear on a new line put your cursor and select the alt and enter keys on your keyboard at the same time. Please also refer to the screen shots below. The screen shots are for QuickBooks Online but this technique can also be used for Transaction Pro Importer 4.o that works with the QuickBooks desktop versions.
Sample Import File
Invoice in QuickBooks Online
If you have any other handy excel tips that you have used please share them below in the comments.