Forum Discussion
Excell 2016
Hello Micro_Merv
I have just replicated your query and found the easiest option after creating the first row, whereby you have your row height and column widths configured as you want them. I merged four cells horizontally then copied that merged cell into what would be the first cell of unmerged cells in the required rows. This then transformed four adjoining cells into one merged cell.
Apologies if you have tried this already.
@DickScrongle.
Yes ! That worked to some extent, but only when you want to create the same size box, as mine are different on various lines it then does not work.
But ! here is the anomaly I then merged the other boxes I wanted to make and it worked.
What I really need is it to work every time, and it seems at the moment it is hit and miss.
- Tried this a second time from scratch and I can't merge anything right from the off
