Print Specific Tabs from Multiple Google Sheets
When a Google Sheets file has many tabs, you may only need to print certain ones. Set print ranges or select specific sheets in Sheets' print settings before running the batch conversion. The PDF export respects those settings.
Setting which tabs to print in Sheets
Open each Sheets file and go to File > Print. In the print settings, choose 'Current sheet', 'Selected sheets', or 'Entire workbook'. Choose 'Selected sheets' and check only the tabs you want. Close the print dialog. The extension will use these settings when exporting the file.
Applying consistent tab settings across files
If all your Sheets files have the same tab structure, you may be able to set the same print settings on each. For large batches, plan which tabs each file should export before starting. This avoids needing to rerun the conversion after printing the wrong tabs.
After setting print ranges
Once each file has the correct print settings, go back to Drive, select all the Sheets files, and run the extension. The batch uses the per-file settings you configured.
Frequently Asked Questions
Does the extension export all tabs by default?
Yes, unless you have set specific print settings in the Sheets file. Configure print settings in each file before running the batch to control which tabs export.
Can I set different tab selections for different files in the same batch?
Yes. Each file's print settings are independent. Set the appropriate tabs in each file before running the batch.
Related article
Batch Convert Multiple Google Docs to PDF →Ready to Try It?
Install the free Chrome extension and start converting your Google Docs to PDF in one click.
Install Free Extension