Forum Discussion
How to make a headline in Excel for table?
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 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!
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))- I probably could've formulated it a bit clearer. I wanted to merge cells.
