Calc 25.2: Can I reduce the printed size of the print range to fit a single page while keeping the header and footer at 100% size?

I’d like to maintain the same header and footer test sizes across multiple sheets, and have the text in the print range shrink as necessary to fit on a single page.

It that possible in Calc? (The application is creating lyric sheets.)

In Excel this can be done with an option to scale, or in my use case not scale, the header and footer with the document. Is there an equivalent in Calc or another method?

Reduce the lyrics text size and columns width.
As a workaround, you can set the cell formatting to [x] Shrink to fit cell size, and change the column width in the print preview. But you will get different text sizes.
image

image

It is better to work with Writer (and columns, or tables) for that.

Many thanks for your response, but that’s what I’m trying to avoid.

My standard text font for the lyrics is Verdana 18pt and they sit centered in 40pt high rows. I can reduce the height of blank rows in between verses and/or choruses and bridges to give a bit of sense to the song’s structure.

And if there are a lot of lyrics I can move some of them to a second column, but position them to vertically align (for example) the 3rd verse in the 2nd column with the 2nd verse in the first column.

Most of my experience is in spreadsheets, so I admit I’m biased, but I find this much easier in a spreadsheet than in a word processor.

I’ll try to upload a couple of examples if the forum allows me as a new user.

Again, many thanks for your input.

Imagine - lyric v2.pdf (34.1 KB)
Old Folks at Home - lyric vA2.pdf (44.4 KB)

As you attach only some .pdf to show what you want to achieve, I’m lost again with the question for what you Insist on using Calc instead of Writer.
Writer allows for well formatted headers and footers while in Calc only exists something with the same name, but much less functionality.
Also I suppose you derived the .pdf from some primary document. Why didn’t you attach that, too?
Accepting a few retrictions you can also give shape to a Writer page using a TextTable
If the original “data source” is a spreadsheet, you can even embed it as an OLE object

Many thanks for your reply.

Basically I’m trying to replicate what I do in Excel (and I’m using the 2007 version, I think, in Win10) and I’d love to move all my Excel work into Calc, so even if new work in Writer is an option, the large body of existing work needs to remain in a spreadsheet.

I’ll try to check out your two suggestions.

Edit: The two pdfs that I attached were exports from two Excel files which both contain a much larger number of lyric sheets. They were only intended as examples of the format want to preserve.