How to make a headline in Excel for table?

Copper Contributor

So basically what I would like is to link together  4 or so cells that have the same headline. In this case link A till D under one headline 'Cars' that covers the 4 cells instead of four times 'Cars'.


For example: 

A            B          C            D


Cars       Cars     Cars       Cars


Wheels  Tires     Mirrors   Lights

4 Replies


Doesn't make sense what you are trying to do. Below formula will generate 4 times cars from A1 to D1



@Inexperienced I believe you are referring to Merged Cells. You'll find that on the Home ribbon in the Alignment group


Better though to avoid merged cells and use Center across selection in stead. Press the small arrow in the bottom right-hand corner of the Alignment group and do this:




This is exactly what I needed! Thank you so much!
I probably could've formulated it a bit clearer. I wanted to merge cells.