I have a workbook with approx 30 worksheets. Periodically I need to print around 20 of them and send to someone. I can print them to a single pdf by selecting using ctrl and choosing ‘selected sheets.’
But how can I have them saved as separate pdfs named according to the worksheet name (or even if they are generically named like ‘filename 1’, filename 2’ etc?
Or even if necessary print all sheets as separate files (then I’d go to the folder and delete the ones I do not need before sending).
Printing and naming each one manually regularly is really repetitive.
EDIT: Ironically, in searching for an answer I found more people (who were excel users) looking for the opposite where they wanted a single pdf and were getting multiple files.
I found an online “pdf splitter” website that will suffice in the interim but would still like to know if this is possible in Calc. I’d be surprised if I’m the only one that has a use for this functionality. As it is 20 some files to save and rename regularly would be tiresome but many have many more where it would be a huge burden.