Calc: how do I create a custom header

I need to create a header with the same number of columns as my spreadsheet

The header and footers are pretty static and always consist of three areas: Left, center and right section.

You should use print range instead: Select Format → Print ranges → Edit. If you define a print range you can choose rows to be repeated on each page.