how can text in a cell automatically overflow into the cells below

%3CLINGO-SUB%20id%3D%22lingo-sub-809294%22%20slang%3D%22en-US%22%3Ehow%20can%20text%20in%20a%20cell%20automatically%20overflow%20into%20the%20cells%20below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809294%22%20slang%3D%22en-US%22%3EIn%20an%20Excel%20Sheet%2C%20how%20can%20text%20in%20a%20cell%20automatically%20overflow%20into%20the%20cells%20below%2C%20if%20they%20are%20empty%3B%20without%20merging%20cells%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-809294%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-809326%22%20slang%3D%22en-US%22%3ERe%3A%20how%20can%20text%20in%20a%20cell%20automatically%20overflow%20into%20the%20cells%20below%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-809326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F393616%22%20target%3D%22_blank%22%3E%40balayla%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20do%20so%20but%20horizontally%20across%20columns%2C%20and%20that's%20explained%20in%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dgyui_D5g5MI%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Evideo.%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EVertically%20across%20rows%2C%20it%20seems%20not%20possible!%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EBut%20there%20is%20a%20fairly%20acceptable%20solution%20by%20going%20beyond%20the%20cells%20and%20use%20a%20text%20box%20shape%20on%20top%20of%20them%20and%20extend%20it%20to%20make%20it%20across%20the%20rows.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127324i29E1CB31F69F6949%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Text%20Box.png%22%20title%3D%22Text%20Box.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
In an Excel Sheet, how can text in a cell automatically overflow into the cells below, if they are empty; without merging cells?
1 Reply
Highlighted

@balayla

 

Hi,

 

You can do so but horizontally across columns, and that's explained in this video.

Vertically across rows, it seems not possible!

 

But there is a fairly acceptable solution by going beyond the cells and use a text box shape on top of them and extend it to make it across the rows.

Text Box.png