Home

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
balayla
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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies