Rajouter une ligne dans une cellule

%3CLINGO-SUB%20id%3D%22lingo-sub-1627665%22%20slang%3D%22fr-FR%22%3EAdd%20a%20line%20to%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1627665%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20add%20several%20lines%20in%20a%20single%20Excel%20cell.%20None%20of%20the%20suggestions%20on%20offer%20work%20on%20my%20PC.%20Can%20you%20help%20me%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1627665%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1627827%22%20slang%3D%22en-US%22%3ERe%3A%20Rajouter%20une%20ligne%20dans%20une%20cellule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1627827%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F779441%22%20target%3D%22_blank%22%3E%40MarcJM%3C%2FA%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETo%20add%20multiple%20lines%20in%20a%20cell%2C%20simply%20combine%20%22Alt%20%2B%20Enter%22%20when%20you%20want%20a%20new%20line.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3Esome%20info%26nbsp%3B%22Alt%20%2B%20Enter%22%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3Emore%20info%26nbsp%3B%22Alt%20%2B%20Enter%22%3C%2FEM%3E%3C%2FP%3E%3CP%3E%3CEM%3Edone%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1599053427942.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216067iC13EA23D04E85180%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Bennadeau_0-1599053427942.png%22%20alt%3D%22Bennadeau_0-1599053427942.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1627893%22%20slang%3D%22en-US%22%3ERE%3A%20Rajouter%20une%20ligne%20dans%20une%20cellule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1627893%22%20slang%3D%22en-US%22%3EIf%20you%20are%20creating%20the%20text%20by%20formula%20then%20include%20the%20line-feed%20character%20CHAR(10).%20Text%20wrapping%20needs%20to%20be%20turned%20on%20for%20the%20cell.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Bonjour,

 

Je souhaite ajouter plusieurs lignes dans une seule cellule Excel. Aucune des suggestions proposées ne fonctionne sur mon PC. Pouvez vous m'aider?

2 Replies
Highlighted

Hi @MarcJM,

To add multiple lines in a cell, simply combine "Alt + Enter" when you want a new line.

some info "Alt + Enter"

more info "Alt + Enter"

done

 

Bennadeau_0-1599053427942.png

 

Highlighted
If you are creating the text by formula then include the line-feed character CHAR(10). Text wrapping needs to be turned on for the cell.