I have rows (B20:G20) to (B24:G24) merged. I want to type text in B20 and when it gets to the end of G20 to automatically flow into B21; and when it gets to G21 to automatically flow into row (B22:G22) and so on.
I can press enter at the end of lets say G20 and go to B21 but I have to be careful to limit the end of the text so it fits in B20:G20 so I want to automate this.
Basically I want a word wrap to the next row at the end of cell column G.
Bookmarks