How do I make headers for columns in which their are 6 columns?

[jobo]

I have:
Oak Island
A LG LN 2LG 2LN LP

I want:
Oak Island as a header along with 8 other headers and the figures below as 6
columns.

Thanks.

 

[David Biddulph]

Select the range of cells across which you want the "Oak Island" to be
centred, and use Format Cells/ Alignment/ Center across selection.

 

[David Biddulph]

Select the range of cells across which you want the "Oak Island" to be
centred, and use Format Cells/ Alignment/ Center across selection.

 

[CellShocked]

I have:
Oak Island
A LG LN 2LG 2LN LP

I want:
Oak Island as a header along with 8 other headers and the figures below as 6
columns.

Thanks.

Make the 8 columns and write in their headers on row 2 of the
worksheet.

Above that in row 1 highlight all 8 cells that match up to the headers
in row 2. In the 'home' ribbon select "merge & center".

Then type in the Oak Island title text and select the "Left" alignment
button to shift the title text to the left... if you like.

Then, if you freeze those rows everything still works.