So I was set with the daunting task of making text in one cell span several columns in Open Office Calc. When I don’t know how to do things I usually ask Google. Searching for “make text span two columns in open office” gave me no results except a bunch of programming macros wikis for Open Office. After much searching I realised that I might have to rephrase the actual question because when computer people use their lingo they seldom bother to rephrase the explanation in other terms than those in use. So merging cell it was. It got me thinking how information is not formed as questions/tasks but as commands in these programs. My task was to make text span several columns but the program only knows how to merge columns i.e. no results on Google.
So how do you do it?
Select the cells that the text should span => Click Format in the menu => Choose Merge Cells => And then once again Merge Cells in the sub menu.
This will make the cells one big cell and you can just let the text flow in there.