This is a returning question that I get a lot while I’m at work.

Please do not add spaces to a text in a cell to make it jump to the next line within the cell.
It will give away your work instantly as a not so professional excel worker.

If you want to put multiple lines in a cell you have to press Alt+Enter for the line break whilst inside a cell.

How to have multiple lines in excel

This is a very simple thing like how to find duplicates in excel

We have a facebook page of ExcelAngel! check us out on facebook.

[et_pb_ccfcm_facebook_comments_module ccfcm_app_id=”339898187197719″ _builder_version=”4.6.1″ _module_preset=”default”][/et_pb_ccfcm_facebook_comments_module]