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.