Merge cells

[bobaol]

Hi, I have a question about merging cells in a row. Please consider the grid below, in a jpg image. So, in this situation, I want to merge A1 to K1, merge C2 and D2, merge H2 and I2, merge C3 to G3, merge H3 to K3. The blue cell, "Merge1Begin" is the start of the beginning a merged cell. For example, I want to merge c3 to g3 because it begins with Merge1Begin, then it has Merge2. So, I want C3 to G3 merged because of this pattern. I want to merge cells based on this pattern. any help is appreciated. thanks in advance.

 

[bobaol]

Oh, one more note, i went and read the link about Center Across Selection. Wow, that is very interesting. I will give it a play. thanks again!

 

[6StringJazzer]

there is one time when merging is required, such as presenting the data in a view that makes sense to the audience

One option for this situation is to do all your data entry and analysis without merged cells. Then add a sheet for presentation purposes that uses merged cells as needed, but all the cells are direct references to the cells on the other sheets. That isolates the merged cells from anywhere you are doing real work.