Excell 2016

[Micro_Merv]

I am finding this very frustrating, I open Excel, New workbook, no protection, no sharing.

I start making my sheet with every second row elongated vertically to the height of two cells, no problem. Then Horizontally I want to merge certain cells into one bigger one. The first row I merge 4 cells into one big one, when I try to do the same thing on another row nothing happens.

I have tried "Merge & Centre" "Merge Across" & just "Merge Cells" but after the first row nothing happens. I need to print the grid lines and the boxes of differing sizes.

I am only a basic user of excel, although I can do much more in word.

[#2]

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. 

[#3]

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.

[#4]

Tried this a second time from scratch and I can't merge anything right from the off