Forum Discussion
Help with Excel 'Format copy' does not include 'new line (Alt Enter) within a cell.
a 'new line' (Alt Enter) is just text not formatting. The only 'formatting' to be 'copied' would be word wrap which is related but different. Word wrap (in the alignment grouping on the home tab) will wrap text inside a cell when it reaches the end of the cell. If excel detects a 'new line' character in the text it will typically turn word wrap on and that character will force a line break before it necessarily reaches the end of the cell. A cell with a 'new line' character in it but with word wrap turned off will NOT go to a new line.
I do not know what you mean by 'Format copy' but if you copy a cell with word wrap turned on and paste formatting onto another cell it will turn word wrap on. Also if you use the format painter it will also turn it on.
Note that I meant format painter by 'format copy'.