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

Copper 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

@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