How to make a headline in Excel for table?

New 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

@Inexperienced 

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

=INDEX("Cars",1,SEQUENCE(1,4,1,0))

 

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

Riny_van_Eekelen_0-1659432373505.png

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:

Riny_van_Eekelen_1-1659432556326.png

 

 

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