Excel has a neat feature called "Merge Across" which as the name implies, merges multiple cells into compound cells that each span two or more columns. I would like to know if I can achieve a similar thing but instead of merging across columns, I want the compound cells to span multiple rows.
Here is an image of what I want to achieve:
2 Answers
You could first merge & center one column by hand (in your example M4:M7), and then use "format painter" on the other columns (N4:O7). This is probably the best way to do it.
1You have probably found the answer by now, but in case someone else asks. The Merging rows option is right there in front of you in your screen dump. Just select the cells downwards (rows) that you want to merge (in your case M4:M7) and click the Merge & Center button. Or if you want to use the dropdown as shown, select the Merge Cells option.
You will then repeat the process for cells N4:N7 and O4:O7
[Edit: I guess there is not a ONE CLICK solution, but this is not that hard]5 second solution
2
